pgsql-performance since 2007-09-01 00:00

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