pgsql-performance - September 2007

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 10 11 12 13 14 16 17 18 19 20 21 22 23 24 25 26 27 28 29

Sept. 1, 2007

Thread Author Time
Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Mark Lewis 00:09
schemas to limit data access Brennan, Sean (IMS) 03:02
schemas to limit data access Brennan, Sean (IMS) 03:02
schemas to limit data access Brennan, Sean (IMS) 03:08
Slow Query Shawn 17:29
Re: Slow Query Tom Lane 18:09
Re: Slow Query Shawn 20:18
Re: Performance issue with nested loop Decibel! 23:50

Sept. 2, 2007

Thread Author Time
Re: Slow Query Shawn 00:35
Re: Slow Query Tom Lane 03:00
Re: Slow Query Kevin Grittner 15:49

Sept. 3, 2007

Thread Author Time
Re: Slow Query Shawn 16:15
Re: Slow Query Shawn 16:57
Re: Slow Query Kevin Grittner 18:07
Re: Slow Query Kevin Grittner 18:32
Re: Slow Query Shawn 23:53

Sept. 4, 2007

Thread Author Time
Re: Slow Query Tom Lane 00:49
Re: schemas to limit data access Merlin Moncure 01:08
Re: Slow Query Kevin Grittner 02:40
Vacum Analyze problem rafael 17:27
Re: Vacum Analyze problem Mikko Partio 17:33
Re: Vacum Analyze problem Kevin Kempter 17:45
Re: Vacum Analyze problem rafael 17:46
Re: Vacum Analyze problem Bill Moran 17:55
About autovacuum Jean-David Beyer 18:39
Re: Vacum Analyze problem rafael 18:46
Re: Vacum Analyze problem Richard Broersma Jr 18:52
join tables vs. denormalization by trigger Walter Mauritz 18:53
Re: About autovacuum Bill Moran 19:01
Re: join tables vs. denormalization by trigger Mark Lewis 19:18
Performance on 8CPU's and 32GB of RAM Carlo Stonebanks 22:45
Re: join tables vs. denormalization by trigger Marc Mamin 22:48
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 23:03
Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera 23:06
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 23:15
Re: Vacum Analyze problem Gregory Stark 23:24

Sept. 5, 2007

Thread Author Time
No pg_dumplo on 8.2.4 Daniel Rubio 07:31
Re: Performance on 8CPU's and 32GB of RAM Hannes Dorbath 08:20
optimize query with a maximum(date) extraction JS Ubei 09:53
FW: optimize query with a maximum(date) extraction Gregory Williamson 11:06
Re: optimize query with a maximum(date) extraction Gregory Stark 11:30
Re: optimize query with a maximum(date) extraction Gregory Stark 12:06
Re: optimize query with a maximum(date) extraction Peter Childs 12:43
Re: optimize query with a maximum(date) extraction Pavel Stehule 12:48
Re : optimize query with a maximum(date) extraction JS Ubei 13:11
Re: optimize query with a maximum(date) extraction hubert depesz lubaczewski 13:22
Re: optimize query with a maximum(date) extraction Gregory Stark 14:14
Re: optimize query with a maximum(date) extraction Gregory Stark 14:23
Re: optimize query with a maximum(date) extraction Gregory Stark 14:28
Re: No pg_dumplo on 8.2.4 Tom Lane 15:03
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks 15:06
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 15:15
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks 15:23
Re: optimize query with a maximum(date) extraction Tom Lane 15:23
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 15:45
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks 15:57
Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera 16:03
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 16:06
Re: Performance on 8CPU's and 32GB of RAM Trevor Talbot 17:16
Re: Performance on 8CPU's and 32GB of RAM Ron Mayer 18:09
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 19:29
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 19:36
Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers 21:02
Re: Performance on 8CPU's and 32GB of RAM Trevor Talbot 21:08
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 21:59
Re: Performance on 8CPU's and 32GB of RAM Adam Tauno Williams 22:15
Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 22:33
utilising multi-cpu/core machines? Thomas Finneid 22:41
RESEND:Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 22:48
Re: utilising multi-cpu/core machines? Jonah H. Harris 23:02
Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers 23:19

Sept. 6, 2007

Thread Author Time
Re: utilising multi-cpu/core machines? Trevor Talbot 00:07
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 00:12
Re: Performance on 8CPU's and 32GB of RAM Joshua D. Drake 02:50
Re: Performance on 8CPU's and 32GB of RAM Ansgar -59cobalt- Wiechers 06:47
Hardware spec Willo van der Merwe 06:54
Re: Hardware spec Richard Huxton 08:17
Re: Hardware spec Willo van der Merwe 09:26
Re: Hardware spec Jean-David Beyer 11:16
Re: Hardware spec Willo van der Merwe 11:37
SAN vs Internal Disks Harsh Azad 12:35
ADO -PostgreSQL OLE DB Provider Jayaram Bhat 13:15
Re: utilising multi-cpu/core machines? Kevin Grittner 13:46
Re: Hardware spec Florian Weimer 14:19
Re: Hardware spec Willo van der Merwe 14:33
Re: SAN vs Internal Disks Mark Lewis 14:42
Re: Hardware spec] Jean-David Beyer 15:00
Re: Hardware spec Florian Weimer 15:21
postgres memory management issues? Richard Yen 16:06
Re: ADO -PostgreSQL OLE DB Provider Richard Broersma Jr 16:08
Re: SAN vs Internal Disks Scott Marlowe 16:25
Re: SAN vs Internal Disks Harsh Azad 16:58
Re: SAN vs Internal Disks Harsh Azad 17:03
Re: SAN vs Internal Disks Joshua D. Drake 17:12
Re: SAN vs Internal Disks Arjen van der Meijden 17:39
Re: SAN vs Internal Disks Scott Marlowe 18:07
Re: SAN vs Internal Disks Harsh Azad 18:15
Re: SAN vs Internal Disks Mark Lewis 18:29
Re: SAN vs Internal Disks Scott Marlowe 18:42
Re: SAN vs Internal Disks Joe Uhl 19:02
Re: SAN vs Internal Disks Joel Fradkin 19:14
Re: SAN vs Internal Disks Arjen van der Meijden 19:38
Re: SAN vs Internal Disks Arjen van der Meijden 19:40
Reasonable amount of indices Patric 20:08
Re: Performance on 8CPU's and 32GB of RAM James Mansion 20:30
Re: Performance on 8CPU's and 32GB of RAM James Mansion 20:39
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks 20:46
Re: Performance on 8CPU's and 32GB of RAM James Mansion 20:55
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 20:59
Re: Performance on 8CPU's and 32GB of RAM Alvaro Herrera 21:21
Re: Reasonable amount of indices Alvaro Herrera 22:09
Re: SAN vs Internal Disks Scott Marlowe 22:35
Re: Performance on 8CPU's and 32GB of RAM Carlo Stonebanks 23:18
Re: Reasonable amount of indices Tom Lane 23:18

Sept. 7, 2007

Thread Author Time
How planner decides left-anchored LIKE can use index Carlo Stonebanks 00:06
Re: How planner decides left-anchored LIKE can use index Tom Lane 00:28
Re: SAN vs Internal Disks Greg Smith 04:26
Re: SAN vs Internal Disks Florian Weimer 08:14
Re: Performance on 8CPU's and 32GB of RAM Florian Weimer 08:17
Re: Postgres with Sun Cluster HA/Solaris 10 Markus Schiltknecht 08:23
Re: postgres memory management issues? Richard Huxton 08:42
Re: postgres memory management issues? Claus Guttesen 09:01
Re: postgres memory management issues? Gregory Stark 09:31
DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni 09:37
Re: postgres memory management issues? Florian Weimer 09:38
Re: utilising multi-cpu/core machines? Sven Geisler 09:50
Re: SAN vs Internal Disks Michael Stone 10:04
Re: postgres memory management issues? Michael Stone 10:11
Re: DRBD and Postgres: how to improve the perfomance? Heikki Linnakangas 10:12
Re: SAN vs Internal Disks Tobias Brox 10:33
Re: DRBD and Postgres: how to improve the perfomance? Merlin Moncure 12:56
Re: SAN vs Internal Disks Michael Stone 13:16
Re: postgres memory management issues? Tom Lane 14:56
Re: Performance on 8CPU's and 32GB of RAM Scott Marlowe 16:16
Re: SAN vs Internal Disks Matthew Schumacher 17:21
Re: Performance on 8CPU's and 32GB of RAM Harald Armin Massa 17:32
Re: SAN vs Internal Disks Bryan Murphy 17:56
Re: SAN vs Internal Disks Alan Hodgson 18:18
Re: SAN vs Internal Disks Brian Hurt 18:21
Re: SAN vs Internal Disks Joshua D. Drake 18:21
Re: DRBD and Postgres: how to improve the perfomance? Simon Riggs 19:00
Re: Postgres with Sun Cluster HA/Solaris 10 Subbiah Stalin-XCGF84 19:24
Re: SAN vs Internal Disks Greg Smith 20:04
Re: SAN vs Internal Disks Vivek Khera 20:35
Re: SAN vs Internal Disks david 21:10
Re: SAN vs Internal Disks Joshua D. Drake 21:15
Re: DRBD and Postgres: how to improve the perfomance? Bernd Helmle 21:54

Sept. 8, 2007

Thread Author Time
Re: DRBD and Postgres: how to improve the perfomance? Simon Riggs 06:28
Re: optimize query with a maximum(date) extraction Dimitri 08:00
Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark 10:04
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake 16:15
Re: DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner 16:33
Re: DRBD and Postgres: how to improve the perfomance? Tom Lane 16:39
Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark 16:49
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake 16:53
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake 17:02
Re: DRBD and Postgres: how to improve the perfomance? Stefan Kaltenbrunner 17:25
Re: DRBD and Postgres: how to improve the perfomance? Gregory Stark 17:32
Re: DRBD and Postgres: how to improve the perfomance? Bernd Helmle 18:22
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake 21:25
Re: DRBD and Postgres: how to improve the perfomance? Joshua D. Drake 21:30

Sept. 10, 2007

Thread Author Time
Re: Slow Query Shawn 01:31
Re: DRBD and Postgres: how to improve the perfomance? Greg Smith 04:06
Re: DRBD and Postgres: how to improve the perfomance? Tom Lane 04:54
random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Carlo Stonebanks 19:25
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan 20:19
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke 20:52
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Josh Berkus 21:26
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark 21:44
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Scott Marlowe 21:59
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jeff Davis 22:03
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke 22:08
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Mark Mielke 22:22
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan 22:45
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan 22:46

Sept. 11, 2007

Thread Author Time
What to vacuum after deleting lots of tables Craig James 04:12
Re: What to vacuum after deleting lots of tables Tom Lane 04:23
[Again] Postgres performance problem 📎 Ruben Rubio 06:33
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark 07:28
Re: [Again] Postgres performance problem db 07:31
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Luke Lonergan 07:33
Re: [Again] Postgres performance problem 📎 Ruben Rubio 07:49
Barcelona vs Tigerton Mindaugas 07:57
Re: Barcelona vs Tigerton Luke Lonergan 08:31
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Heikki Linnakangas 09:00
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer 11:07
Re: DRBD and Postgres: how to improve the perfomance? Maila Fatticcioni 14:47
Re: DRBD and Postgres: how to improve the perfomance? Steinar H. Gunderson 14:57
Re: Barcelona vs Tigerton Greg Smith 15:11
More Vacuum questions... Kevin Kempter 16:24
500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running 📎 El-Lotso 16:57
Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running 📎 El-Lotso 17:02
Re: More Vacuum questions... Heikki Linnakangas 17:29
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Gregory Stark 18:16
Re: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running Tom Lane 18:23
Re: DRBD and Postgres: how to improve the perfomance? Mario Weilguni 18:26
Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1 Jean-David Beyer 18:49
efficient pattern queries (using LIKE, ~) Fernan Aguero 18:54
Re: efficient pattern queries (using LIKE, ~) Mario Weilguni 19:08
Re: Barcelona vs Tigerton Guy Rouillier 19:52

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 10 11 12 13 14 16 17 18 19 20 21 22 23 24 25 26 27 28 29