Mailing lists [pgsql-performance]

1 March 2012

• 01:10   Re: Very long deletion time on a 200 GB database Lew
• 01:10   Re: Very long deletion time on a 200 GB database Gavin Flower
• 01:10   Inefficient min/max against partition (ver 9.1.1) McGehee, Robert
• 10:45   [planner] Ignore "order by" in subselect if parrent do count(*) Marcin Mirosław
• 10:50   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Szymon Guz
• 11:02   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Marcin Mirosław
• 11:09   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Szymon Guz
• 11:19   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Marcin Mirosław
• 15:34   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes
• 15:40   Bad estimation for "where field not in" Daniele Varrazzo
• 15:51   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Kevin Grittner
• 15:58   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes
• 16:35   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Scott Marlowe
• 16:38   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Dave Crooke
• 16:50   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Tom Lane
• 16:53   Re: Bad estimation for "where field not in" Ants Aasma
• 17:19   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Craig James
• 17:27   efficient data reduction (and deduping) Alessandro Gagliardi
• 17:35   Re: efficient data reduction (and deduping) Claudio Freire
• 17:35   Re: efficient data reduction (and deduping) Craig James
• 17:41   Re: efficient data reduction (and deduping) Peter van Hardenberg
• 17:52   Re: efficient data reduction (and deduping) Kevin Grittner
• 18:06   Re: Large insert and delete batches Kääriäinen Anssi
• 18:28   Re: efficient data reduction (and deduping) Alessandro Gagliardi
• 18:29   Re: efficient data reduction (and deduping) Alessandro Gagliardi
• 18:34   Re: efficient data reduction (and deduping) Alessandro Gagliardi
• 18:36   Re: efficient data reduction (and deduping) Alessandro Gagliardi
• 18:40   Re: efficient data reduction (and deduping) Claudio Freire
• 18:45   Re: efficient data reduction (and deduping) Claudio Freire
• 18:45   Re: efficient data reduction (and deduping) Alessandro Gagliardi
• 19:12   Re: efficient data reduction (and deduping) Kevin Grittner
• 19:52   Re: Large insert and delete batches Marti Raudsepp
• 20:18   Re: Bad estimation for "where field not in" Tom Lane
• 20:29   Re: [planner] Ignore "order by" in subselect if parrent do count(*) Tom Lane
• 21:53   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Stefan Keller
• 22:08   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andrew Dunstan
• 23:23   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire
• 23:28   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Peter van Hardenberg
• 23:35   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Jeff Janes
• 23:58   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire

2 March 2012

• 00:13   Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Tomas Vondra
• 00:17   Re: PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Andrew Dunstan
• 01:05   Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Claudio Freire
• 11:48   Re: Large insert and delete batches Anssi Kääriäinen
• 18:31   Re: Inefficient min/max against partition (ver 9.1.1) Tom Lane
• 23:30   Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory? Tomas Vondra

3 March 2012

• 21:43   ...WHERE TRUE" condition in union results in bad query pla Claus Stadler

4 March 2012

• 02:03   Re: ...WHERE TRUE" condition in union results in bad query pla Tom Lane
• 08:59   Advice sought : new database server Rory Campbell-Lange
• 10:50   Re: Advice sought : new database server Michael Friedl
• 13:19   Re: Advice sought : new database server Scott Marlowe
• 17:36   Re: Advice sought : new database server Rory Campbell-Lange
• 18:46   Re: Advice sought : new database server Andy Colson
• 18:50   Re: Advice sought : new database server Scott Marlowe
• 18:51   Re: Advice sought : new database server Scott Marlowe

5 March 2012

• 11:26   Re: Advice sought : new database server Rory Campbell-Lange
• 14:16   Partitioning / Strange optimizer behaviour Marc Schablewski
• 14:21   Re: Partitioning / Strange optimizer behaviour Tomas Vondra
• 14:44   Re: Partitioning / Strange optimizer behaviour Marc Schablewski
• 15:56   Re: Advice sought : new database server Craig James
• 20:59   Re: Advice sought : new database server Rory Campbell-Lange
• 21:37   SSD and RAID Mark Kirkwood
• 22:04   Re: SSD and RAID Tomas Vondra
• 22:15   Repeat execution of stable expressions Merlin Moncure
• 23:42   Re: Repeat execution of stable expressions Peter van Hardenberg

6 March 2012

• 07:17   Re: SSD and RAID Yeb Havinga
• 08:34   Re: SSD and RAID Yeb Havinga
• 10:12   Re: Advice sought : new database server Rory Campbell-Lange
• 14:01   Re: Repeat execution of stable expressions Merlin Moncure
• 15:22   Re: Repeat execution of stable expressions Jan Otto
• 18:29   Re: Repeat execution of stable expressions Merlin Moncure
• 23:33   Re: Advice sought : new database server Steve Crawford
• 23:37   Re: SSD and RAID Mark Kirkwood

7 March 2012

• 08:45   Re: SSD and RAID Yeb Havinga
• 13:16   Re: SSD and RAID Andrea Suisani
• 13:16   Re: SSD and RAID Andrea Suisani
• 19:18   Re: Advice sought : new database server Merlin Moncure
• 19:46   Re: Advice sought : new database server Scott Marlowe
• 20:07   Re: Advice sought : new database server Craig James
• 21:24   Re: Advice sought : new database server Shaun Thomas

8 March 2012

• 11:43   Re: Advice sought : new database server Ants Aasma
• 12:28   Re: Advice sought : new database server Rory Campbell-Lange
• 15:03   Re: Advice sought : new database server Jeff Janes
• 15:16   Re: Advice sought : new database server Jochen Erwied
• 15:18   Re: Advice sought : new database server Shaun Thomas

9 March 2012

• 10:16   Comments requested on IO performance : new db server Rory Campbell-Lange
• 15:12   Re: Comments requested on IO performance : new db server Merlin Moncure

10 March 2012

• 09:19   Re: Comments requested on IO performance : new db server Rory Campbell-Lange
• 09:51   Re: Comments requested on IO performance : new db server Rory Campbell-Lange
• 14:12   Re: Comments requested on IO performance : new db server Tomas Vondra

12 March 2012

• 14:06   Advice on Controller card for SAS disks See Sing Lau
• 14:06   count on transaction ID ddgs
• 14:06   Tuning wizard Michael Kopljan
• 14:06   Feature Request: No pg_dump lock on unlogged tables McGehee, Robert
• 14:41   Re: count on transaction ID Kevin Grittner
• 15:47   Re: count on transaction ID ddgs
• 16:04   Re: Tuning wizard Tomas Vondra
• 16:06   Re: count on transaction ID Kevin Grittner
• 16:10   Re: Advice on Controller card for SAS disks Tomas Vondra
• 16:34   Re: count on transaction ID ddgs
• 16:38   Re: Tuning wizard Scott Marlowe
• 16:43   Re: Advice on Controller card for SAS disks Scott Marlowe
• 16:57   Re: count on transaction ID Kevin Grittner

13 March 2012

• 00:55   Re: Tuning wizard Raghavendra
• 05:43   Gin index insert performance issue Rural Hunter
• 06:30   Re: Gin index insert performance issue Jesper Krogh
• 07:53   Re: Gin index insert performance issue Rural Hunter

15 March 2012

• 03:49   Re: Gin index insert performance issue Rural Hunter
• 08:32   index choosing problem Rural Hunter
• 11:44   Re: index choosing problem Ants Aasma

16 March 2012

• 07:34   Shared memory for large PostGIS operations maplabs@light42.com
• 13:55   Re: Shared memory for large PostGIS operations Andy Colson
• 14:22   Re: Shared memory for large PostGIS operations Kevin Grittner
• 14:32   Obtaining resource usage statistics from execution? (v 9.1) Karl Denninger
• 14:54   Re: Obtaining resource usage statistics from execution? (v 9.1) Tom Lane
• 15:08   Re: Obtaining resource usage statistics from execution? (v 9.1) Tomas Vondra
• 15:38   Re: Obtaining resource usage statistics from execution? (v 9.1) Karl Denninger
• 16:18   Re: Obtaining resource usage statistics from execution? (v 9.1) Ants Aasma
• 22:30   Re: Shared memory for large PostGIS operations Kevin Grittner

17 March 2012

• 13:21   Re: Shared memory for large PostGIS operations Andy Colson
• 16:16   Re: Shared memory for large PostGIS operations Kevin Grittner
• 20:56   slow self-join query Robert Poor

18 March 2012

• 00:57   Re: slow self-join query Scott Marlowe
• 12:22   Re: Shared memory for large PostGIS operations Brian Hamlin
• 14:37   Re: slow self-join query Robert Poor
• 14:51   Re: slow self-join query Andrew Dunstan
• 15:30   Re: slow self-join query Scott Marlowe
• 15:45   Re: slow self-join query Scott Marlowe

19 March 2012

• 03:57   Re: slow self-join query Robert Poor
• 13:35   Re: slow self-join query Merlin Moncure
• 14:27   Re: slow self-join query Kevin Grittner
• 15:22   Re: slow self-join query Robert Poor
• 16:46   Re: slow self-join query Kevin Grittner

21 March 2012

• 11:21   DBD-Pg prepared statement versus plain execution Rafael Martinez
• 11:42   timing != log duration Rafael Martinez
• 11:54   Re: timing != log duration Marti Raudsepp
• 13:00   Re: DBD-Pg prepared statement versus plain execution ktm@rice.edu
• 13:44   Re: DBD-Pg prepared statement versus plain execution Andy Colson
• 14:11   Re: timing != log duration Tom Lane
• 14:32   Re: set autovacuum=off Robert Haas
• 14:49   Re: timing != log duration Albe Laurenz

22 March 2012

• 07:29   Write workload is causing severe slowdown in Production Gnanakumar
• 09:42   Re: Write workload is causing severe slowdown in Production Vitalii Tymchyshyn
• 10:04   Re: Write workload is causing severe slowdown in Production Tomas Vondra
• 10:33   Re: Write workload is causing severe slowdown in Production Gnanakumar
• 10:43   Re: Write workload is causing severe slowdown in Production Tomas Vondra
• 12:11   Re: Write workload is causing severe slowdown in Production Gnanakumar
• 12:39   Re: Write workload is causing severe slowdown in Production Gnanakumar
• 12:52   Re: Write workload is causing severe slowdown in Production Tomas Vondra
• 12:55   Re: Write workload is causing severe slowdown in Production Tomas Vondra
• 15:14   Re: Write workload is causing severe slowdown in Production Kevin Grittner
• 16:18   Re: Write workload is causing severe slowdown in Production Merlin Moncure

23 March 2012

• 00:09   Re: Write workload is causing severe slowdown in Production Mark Kirkwood
• 00:39   Sudden Query slowdown on our Postgresql Server Sebastian Melchior
• 00:48   Re: Sudden Query slowdown on our Postgresql Server Stephen Frost
• 04:38   Re: Sudden Query slowdown on our Postgresql Server Sebastian Melchior
• 04:48   Re: Sudden Query slowdown on our Postgresql Server Scott Marlowe
• 04:54   Re: Sudden Query slowdown on our Postgresql Server Sebastian Melchior
• 05:19   Re: Sudden Query slowdown on our Postgresql Server Scott Marlowe
• 07:11   Re: Sudden Query slowdown on our Postgresql Server Yeb Havinga
• 07:52   Re: Sudden Query slowdown on our Postgresql Server Sebastian Melchior
• 10:11   Re: Write workload is causing severe slowdown in Production Gnanakumar
• 10:24   Re: Write workload is causing severe slowdown in Production Tomas Vondra
• 12:26   Re: Write workload is causing severe slowdown in Production Gnanakumar
• 14:09   Re: Write workload is causing severe slowdown in Production Kevin Grittner

26 March 2012

• 07:11   Determining working set size Peter van Hardenberg
• 09:50   anyone tried to use hoard allocator? Tomas Vondra
• 11:10   Re: anyone tried to use hoard allocator? Pavel Stehule
• 16:00   Re: anyone tried to use hoard allocator? Steve Atkins

27 March 2012

• 19:58   Re: Determining working set size Joshua Berkus
• 20:06   Linux machine aggressively clearing cache Joshua Berkus
• 20:10   Re: Linux machine aggressively clearing cache Claudio Freire
• 20:40   Re: Linux machine aggressively clearing cache Dave Crooke
• 20:58   Re: Distinct + Limit Francois Deliege
• 20:58   Distinct + Limit Francois Deliege

28 March 2012

• 00:19   Re: Distinct + Limit Ants Aasma
• 14:13   Re: Distinct + Limit Tom Lane
• 16:40   Re: Distinct + Limit Merlin Moncure
• 18:37   Re: Linux machine aggressively clearing cache Joshua Berkus

29 March 2012

• 17:59   database slowdown while a lot of inserts occur Campbell, Lance
• 18:04   Re: database slowdown while a lot of inserts occur Campbell, Lance
• 18:14   Re: database slowdown while a lot of inserts occur Filippos Kalamidas
• 18:17   Re: database slowdown while a lot of inserts occur Deron
• 19:27   Re: database slowdown while a lot of inserts occur Bob Lunney
• 19:40   Re: database slowdown while a lot of inserts occur Andrew Dunstan
• 20:14   Re: database slowdown while a lot of inserts occur Shrirang Chitnis
• 21:37   Re: database slowdown while a lot of inserts occur Scott Marlowe

30 March 2012

• 14:46   Tablespaces on a raid configuration Campbell, Lance
• 14:54   Re: Tablespaces on a raid configuration ktm@rice.edu
• 15:02   Re: Tablespaces on a raid configuration Greg Spiegelberg
• 15:03   Re: Tablespaces on a raid configuration Andrew Dunstan
• 16:11   Re: Tablespaces on a raid configuration Merlin Moncure
• 17:31   Re: Tablespaces on a raid configuration Craig James

31 March 2012

• 00:51   Re: Linux machine aggressively clearing cache Josh Berkus
• 01:11   Re: database slowdown while a lot of inserts occur Tomas Vondra
• 01:21   Re: database slowdown while a lot of inserts occur Tomas Vondra
• 01:32   Re: Tablespaces on a raid configuration Tomas Vondra
• 13:43   Re: Tablespaces on a raid configuration Aidan Van Dyk