Mailing lists [pgsql-performance]

1 August 2007

• 03:29   Re: Using EXECUTE in a function Merlin Moncure
• 08:27   Re: TRUNCATE TABLE Adriaan van Os
• 14:22   Re: TRUNCATE TABLE Kevin Grittner
• 15:11   RES: Improving select peformance Carlos H. Reimer
• 15:12   Re: TRUNCATE TABLE Alvaro Herrera
• 16:53   Re: RES: Improving select peformance Alvaro Herrera
• 17:59   Re: select on 1milion register = 6s Jan Dittmer
• 18:11   Re: Postgres configuration for 64 CPUs, 128 GB RAM... Luke Lonergan

2 August 2007

• 00:26   RES: RES: Improving select peformance Carlos H. Reimer
• 16:08   cpu throttling Bryan Murphy
• 16:14   Re: cpu throttling Alan Hodgson
• 18:10   Re: cpu throttling Bryan Murphy
• 21:32   Why are distinct and group by choosing different plans? Ron Mayer
• 22:37   Re: Why are distinct and group by choosing different plans? Gregory Stark

3 August 2007

• 00:48   Re: Why are distinct and group by choosing different plans? Tom Lane
• 01:47   RES: RES: Improving select peformance Carlos H. Reimer
• 02:13   Re: RES: RES: Improving select peformance Tom Lane
• 13:59   Performance problems with large telemetric datasets on 7.4.2 Sven Clement
• 14:20   Re: Performance problems with large telemetric datasets on 7.4.2 Mark Lewis
• 14:26   Re: Performance problems with large telemetric datasets on 7.4.2 Dan Langille
• 15:57   Re: Performance problems with large telemetric datasets on 7.4.2 Sven Clement
• 17:55   Re: Performance problems with large telemetric datasets on 7.4.2 Josh Berkus
• 18:11   Postgres optimizer Mouhamadou Dia
• 18:28   Re: Postgres optimizer Mark Lewis
• 20:10   CLOG Patch Jignesh K. Shah
• 20:28   Re: CLOG Patch Simon Riggs
• 21:14   Re: Performance problems with large telemetric datasets on 7.4.2 Andrew Kroeger
• 22:18   Re: cpu throttling Decibel!
• 22:34   Re: Performance problems with large telemetric datasets on 7.4.2 Tom Lane

4 August 2007

• 14:02   RES: RES: RES: Improving select peformance Carlos H. Reimer
• 20:03   Re: Performance problems with large telemetric datasets on 7.4.2 Sven Clement
• 20:36   Default Performance between 8.0 and 8.1 Ted Jordan
• 21:39   Re: TRUNCATE TABLE Adriaan van Os

5 August 2007

• 16:08   Re: Performance problems with large telemetric datasets on 7.4.2 Heikki Linnakangas

6 August 2007

• 01:56   Re: Default Performance between 8.0 and 8.1 Merlin Moncure
• 05:49   Re: TRUNCATE TABLE Decibel!
• 07:10   Re: Performance problems with large telemetric datasets on 7.4.2 Sven Clement
• 09:19   Extreme slow select query 8.2.4 Henrik Zagerholm
• 09:42   Re: Performance problems with large telemetric datasets on 7.4.2 Ragnar
• 09:51   Re: Performance problems with large telemetric datasets on 7.4.2 Heikki Linnakangas
• 09:54   Re: Performance problems with large telemetric datasets on 7.4.2 Sven Clement
• 12:22   Planner making wrong decisions 8.2.4. Insane cost calculations. Henrik Zagerholm
• 13:07   Re: Planner making wrong decisions 8.2.4. Insane cost calculations. Gregory Stark
• 14:46   Re: Planner making wrong decisions 8.2.4. Insane cost calculations. Henrik Zagerholm
• 14:59   Re: Extreme slow select query 8.2.4 Tom Lane
• 15:31   Re: Planner making wrong decisions 8.2.4. Insane cost calculations. Gregory Stark
• 15:32   Re: [GENERAL] Planner making wrong decisions 8.2.4. Insane cost calculations. Tom Lane
• 15:50   Re: Extreme slow select query 8.2.4 Henrik Zagerholm
• 17:59   Re: Default Performance between 8.0 and 8.1 Ted Jordan
• 18:46   Re: TRUNCATE TABLE Tom Lane
• 19:47   Re: Extreme slow select query 8.2.4 Heikki Linnakangas
• 20:17   Re: Extreme slow select query 8.2.4 Henrik Zagerholm
• 21:29   Re: [GENERAL] Planner making wrong decisions 8.2.4. Insane cost calculations. Henrik Zagerholm
• 22:23   Re: [GENERAL] Planner making wrong decisions 8.2.4. Insane cost calculations. Tom Lane

7 August 2007

• 12:58   Update table performance Mark Makarowsky
• 13:33   Re: Update table performance Richard Huxton
• 14:07   Re: Performance problems with large telemetric datasets on 7.4.2 Scott Marlowe
• 14:53   Re: Update table performance Scott Marlowe
• 16:03   Re: Update table performance Alan Hodgson
• 18:00   Re: Update table performance Decibel!
• 18:03   Re: Update table performance Chris Browne
• 19:36   Re: Update table performance Scott Marlowe
• 21:42   Re: Update table performance Decibel!
• 23:13   Re: Update table performance Mark Makarowsky

8 August 2007

• 01:46   Re: Update table performance Erik Jones
• 08:01   Re: Update table performance Heikki Linnakangas
• 15:15   Re: Update table performance Erik Jones
• 17:28   Re: Update table performance Decibel!
• 17:52   Re: When/if to Reindex Vivek Khera
• 19:13   Re: When/if to Reindex Steven Flatt
• 19:28   Re: When/if to Reindex Bill Moran
• 20:02   How to ENABLE SQL capturing??? smiley2211
• 20:36   Re: How to ENABLE SQL capturing??? Steinar H. Gunderson
• 20:36   Re: When/if to Reindex Decibel!
• 20:58   Re: How to ENABLE SQL capturing??? Bryan Murphy

9 August 2007

• 01:52   Re: When/if to Reindex Tom Lane
• 03:35   mid 2007 "best bang for the buck" hardware opinions justin
• 04:06   Re: mid 2007 "best bang for the buck" hardware opinions Scott Marlowe
• 04:46   Re: mid 2007 "best bang for the buck" hardware opinions justin
• 12:34   Re: Update table performance Merlin Moncure
• 13:04   Re: When/if to Reindex Bill Moran
• 13:14   Re: Update table performance Michael Stone
• 13:42   Re: Update table performance Trevor Talbot
• 13:51   Re: When/if to Reindex Steven Flatt
• 14:40   Re: mid 2007 "best bang for the buck" hardware opinions Vivek Khera
• 15:32   Re: Update table performance Decibel!
• 20:02   Dell Hardware Recommendations Joe Uhl
• 21:16   Re: Dell Hardware Recommendations Decibel!
• 21:50   Re: Dell Hardware Recommendations Merlin Moncure
• 22:05   Re: Dell Hardware Recommendations Decibel!
• 22:21   Re: Dell Hardware Recommendations Arjen van der Meijden

10 August 2007

• 00:54   Re: Dell Hardware Recommendations Joe Uhl
• 01:58   Re: Dell Hardware Recommendations Scott Marlowe
• 04:59   Re: Dell Hardware Recommendations Decibel!
• 05:23   Re: Dell Hardware Recommendations Greg Smith
• 05:25   Re: Update table performance Kenneth Marshall
• 05:25   Performance on writable views Enrico Weigelt
• 05:27   Re: select count(*) performance slawekj
• 05:28   select count(*) performance runic
• 05:28   Re: Update table performance Piotr Kołaczkowski
• 05:29   Implementing an regex filter Enrico Weigelt
• 05:42   Re: Dell Hardware Recommendations david@lang.hm
• 10:36   Re: Dell Hardware Recommendations Merlin Moncure
• 10:53   Re: Dell Hardware Recommendations Merlin Moncure
• 11:44   Re: select count(*) performance Merlin Moncure
• 13:08   Re: select count(*) performance Brian Hurt
• 17:30   Re: Dell Hardware Recommendations Merlin Moncure
• 17:54   Re: How to ENABLE SQL capturing??? smiley2211
• 17:54   Re: CLOG Patch Jignesh K. Shah
• 19:05   Re: Help optimize view Relyea, Mike
• 19:34   Bitmap Index Scan optimization opportunity Kevin Grittner
• 19:43   Re: Dell Hardware Recommendations Vivek Khera
• 20:02   Re: CLOG Patch Simon Riggs
• 20:05   Re: Bitmap Index Scan optimization opportunity Heikki Linnakangas
• 20:36   Re: Dell Hardware Recommendations Merlin Moncure
• 20:47   Re: Dell Hardware Recommendations Joel Fradkin
• 21:22   Re: How to ENABLE SQL capturing??? Jeff Frost
• 21:43   Re: Help optimize view Tom Lane
• 21:43   Re: How to ENABLE SQL capturing??? smiley2211
• 21:48   Re: How to ENABLE SQL capturing??? Joshua D. Drake

11 August 2007

• 07:43   Re: Performance on writable views Heikki Linnakangas
• 13:57   Re: Performance on writable views Joshua D. Drake
• 15:32   Re: select count(*) performance Kevin Grittner

13 August 2007

• 11:38   Re: select count(*) performance valgog
• 13:50   Re: Dell Hardware Recommendations Vivek Khera
• 14:07   Re: select count(*) performance Kevin Grittner
• 15:04   Re: How to ENABLE SQL capturing??? Jonathan Ellis
• 15:36   Re: Help optimize view Relyea, Mike
• 15:40   Re: How to ENABLE SQL capturing??? Joshua D. Drake
• 16:02   Re: How to ENABLE SQL capturing??? Gregory Stark
• 16:13   Re: How to ENABLE SQL capturing??? Joshua D. Drake
• 16:25   Re: Help optimize view Kevin Grittner
• 18:49   Re: Help optimize view Relyea, Mike
• 19:51   Proposal: Pluggable Optimizer Interface Julius Stroffek
• 20:02   Re: Help optimize view Kevin Grittner
• 20:17   Re: Help optimize view Tom Lane
• 20:20   Re: [HACKERS] Proposal: Pluggable Optimizer Interface Stefan Kaltenbrunner
• 20:38   Stable function optimisation Philipp Specht
• 21:00   Re: Help optimize view Relyea, Mike
• 21:01   Re: Stable function optimisation Tom Lane
• 21:23   Re: [HACKERS] Proposal: Pluggable Optimizer Interface Tom Lane
• 21:25   Re: Help optimize view Kevin Grittner
• 21:29   Re: [HACKERS] Proposal: Pluggable Optimizer Interface Julius Stroffek
• 22:18   Re: Performance on writable views Jim Nasby
• 22:25   Re: [HACKERS] Proposal: Pluggable Optimizer Interface Tom Lane
• 22:37   Re: Help optimize view Kevin Grittner
• 23:06   Re: [HACKERS] Proposal: Pluggable Optimizer Interface Josh Berkus
• 23:18   Re: [HACKERS] Proposal: Pluggable Optimizer Interface Tom Lane

14 August 2007

• 00:59   Re: Dell Hardware Recommendations Dave Cramer
• 10:21   RAID 10 or RAID 10 + RAID 1 Michael Ben-Nes
• 21:32   Re: RAID 10 or RAID 10 + RAID 1 Decibel!

15 August 2007

• 19:43   Indexscan is only used if we use "limit n" Sebastián Baioni
• 20:00   Re: Indexscan is only used if we use "limit n" Alvaro Herrera
• 20:02   Re: Indexscan is only used if we use "limit n" joao
• 20:03   Re: Indexscan is only used if we use "limit n" Mark Lewis
• 20:48   Re: Stable function optimisation Philipp Specht

16 August 2007

• 08:52   Integrated perc 5/i Michael Ben-Nes
• 13:00   Re: Integrated perc 5/i Merlin Moncure
• 16:33   Bad planner decision - bitmap scan instead of index Frank Schoep
• 16:43   Re: Integrated perc 5/i Steinar H. Gunderson
• 17:01   Re: Bad planner decision - bitmap scan instead of index Tom Lane
• 17:47   Re: Integrated perc 5/i Michael Ben-Nes
• 17:53   Re: Integrated perc 5/i Luke Lonergan
• 17:59   Re: Integrated perc 5/i Steinar H. Gunderson
• 19:43   Re: Bad planner decision - bitmap scan instead of index Frank Schoep
• 19:51   Re: Integrated perc 5/i Decibel!
• 21:05   Re: Integrated perc 5/i tyrrill_ed@emc.com
• 22:15   Re: Integrated perc 5/i Merlin Moncure
• 22:25   Re: Integrated perc 5/i Scott Marlowe
• 22:41   Re: Integrated perc 5/i Decibel!
• 23:09   Re: Indexscan is only used if we use "limit n" Josh Berkus

17 August 2007

• 01:13   Re: Integrated perc 5/i Luke Lonergan
• 07:28   Re: Bad planner decision - bitmap scan instead of index hubert depesz lubaczewski
• 08:43   Re: Bad planner decision - bitmap scan instead of index Frank Schoep
• 15:29   Re: Bad planner decision - bitmap scan instead of index Michael Stone
• 15:59   Re: Bad planner decision - bitmap scan instead of index Frank Schoep
• 22:48   Re: High update activity, PostgreSQL vs BigDBMS Guy Rouillier
• 22:54   Re: Simple select hangs while CPU close to 100% - Analyze Jozsef Szalay
• 23:35   Stable function optimisation Philipp Specht
• 23:35   Help optimize view Relyea, Mike
• 23:35   Re: select count(*) performance Detlef Rudolph
• 23:36   Raid Configurations Robert D Oden
• 23:36   Performance Solaris vs Linux Fredrik Bertilsson
• 23:36   Fwd: Table Partitioning Nurlan Mukhanov
• 23:56   Re: Raid Configurations Merlin Moncure

18 August 2007

• 01:14   Re: select count(*) performance Scott Marlowe
• 03:04   Re: Simple select hangs while CPU close to 100% - Analyze Alvaro Herrera
• 03:08   Re: Performance Solaris vs Linux Alvaro Herrera
• 10:13   Re: Performance Solaris vs Linux Chris Mair
• 11:12   Re: Fwd: Table Partitioning Henrik

19 August 2007

• 01:02   Re: Help optimize view Kevin Grittner
• 01:12   Re: Help optimize view Kevin Grittner
• 13:20   schema design question mark overmeer
• 14:24   Re: schema design question Adam Tauno Williams
• 15:23   Re: schema design question mark overmeer
• 18:12   Re: schema design question David Fetter
• 18:27   Re: schema design question Steinar H. Gunderson
• 18:41   Re: schema design question David Fetter
• 19:48   Re: [pgsql-jobs] Looking for database hosting Andrew Hammond
• 20:13   Re: schema design question mark overmeer
• 20:16   Re: [pgsql-jobs] Looking for database hosting Luke Lonergan
• 20:23   Re: schema design question David Fetter
• 20:42   Re: schema design question Steinar H. Gunderson
• 21:50   Re: Looking for database hosting: FIX CC LIST!! Josh Berkus
• 21:56   Re: [pgsql-jobs] Looking for database hosting Leon Mergen

20 August 2007

• 00:22   Re: schema design question Adam Tauno Williams
• 00:37   Re: [pgsql-jobs] Looking for database hosting Andrew Hammond
• 14:03   Re: Help optimize view Relyea, Mike
• 14:36   Terminology Question Campbell, Lance
• 14:50   Re: Terminology Question Scott Marlowe
• 17:55   Re: Terminology Question Joshua D. Drake

21 August 2007

• 15:50   Re: Performance Solaris vs Linux Julius Stroffek
• 21:26   Autovacuum is running forever Sachchida Ojha
• 21:30   Re: Autovacuum running forever Sachchida Ojha
• 21:36   Re: Autovacuum is running forever Michael Glaesemann
• 21:41   Re: Autovacuum is running forever Sachchida Ojha
• 21:47   Re: Autovacuum running forever Scott Marlowe
• 21:49   Re: Autovacuum is running forever Sachchida Ojha
• 21:54   Re: Autovacuum is running forever Alvaro Herrera
• 21:56   Re: Autovacuum is running forever Sachchida Ojha
• 22:01   Re: Autovacuum is running forever Scott Marlowe
• 22:03   Re: Autovacuum is running forever Scott Marlowe
• 22:05   Re: Autovacuum is running forever Scott Marlowe
• 22:11   Re: Autovacuum is running forever Sachchida Ojha
• 22:20   Re: Autovacuum is running forever Scott Marlowe
• 23:16   Re: Autovacuum is running forever Scott Marlowe

22 August 2007

• 04:08   Optimising "in" queries Stephen Davies
• 04:09   Poor Performance after Upgrade Ben Perrault
• 04:20   Re: Optimising "in" queries Scott Marlowe
• 04:24   Re: Poor Performance after Upgrade Steinar H. Gunderson
• 09:19   Re: Poor Performance after Upgrade vincent
• 10:56   Re: Poor Performance after Upgrade Russell Smith
• 11:02   Re: Optimising "in" queries Russell Smith
• 13:25   Re: Optimising "in" queries Michael Glaesemann
• 15:33   io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
• 15:57   Re: io storm on checkpoints, postgresql 8.2.4, linux Mark Mielke
• 16:01   Re: io storm on checkpoints, postgresql 8.2.4, linux Joshua D. Drake
• 16:02   Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
• 16:16   Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
• 16:23   Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
• 16:28   Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
• 16:30   Re: Fast tsearch2, trigram matching on short phrases Steinar H. Gunderson
• 16:55   Re: When/if to Reindex Steven Flatt
• 18:48   Re: Fast tsearch2, trigram matching on short phrases Oleg Bartunov
• 18:50   Re: Optimising "in" queries Kevin Grittner
• 20:24   Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
• 20:30   Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
• 20:30   Re: io storm on checkpoints, postgresql 8.2.4, linux Greg Smith
• 20:43   Re: Fast tsearch2, trigram matching on short phrases Oleg Bartunov
• 20:43   Long running transaction in pg_activity_log Sachchida Ojha
• 20:58   Re: Long running transaction in pg_activity_log Sachchida Ojha
• 21:09   Re: Fast tsearch2, trigram matching on short phrases Carlo Stonebanks
• 21:41   Re: Long running transaction in pg_activity_log Tobias Brox
• 21:58   Re: Long running transaction in pg_activity_log Farhan Mughal
• 23:51   Re: When/if to Reindex Gregory Stark

23 August 2007

• 00:21   Re: Optimising "in" queries Michael Glaesemann
• 07:38   Re: Optimising "in" queries Russell Smith
• 07:46   Re: Optimising "in" queries Russell Smith
• 13:09   asynchronous commit feature Merlin Moncure
• 14:37   Re: io storm on checkpoints, postgresql 8.2.4, linux Dmitry Potapov
• 16:47   Installing PostgreSQL Campbell, Lance
• 17:01   Re: io storm on checkpoints, postgresql 8.2.4, linux Greg Smith
• 17:12   Re: Installing PostgreSQL Richard Huxton
• 17:24   long-running query - needs tuning Kevin Kempter
• 17:25   Re: Installing PostgreSQL Campbell, Lance
• 17:26   Re: Installing PostgreSQL Greg Smith
• 17:28   Re: Installing PostgreSQL Richard Huxton
• 17:38   Re: Installing PostgreSQL Campbell, Lance
• 18:15   Re: Optimising "in" queries Stephen Davies
• 18:22   deadlock_timeout parameter in Postgresql.cof Sachchida Ojha
• 18:29   deadlock_timeout parameter in Postgresql.cof Sachchida Ojha
• 18:52   Re: deadlock_timeout parameter in Postgresql.cof Bill Moran
• 18:56   Re: long-running query - needs tuning Tom Lane
• 19:46   Re: Optimising "in" queries Alvaro Herrera
• 21:31   Re: Raid Configurations Decibel!
• 22:25   Re: When/if to Reindex Steven Flatt

24 August 2007

• 02:19   Re: Optimising "in" queries Tom Lane
• 03:59   Re: When/if to Reindex Tom Lane
• 05:27   Re: When/if to Reindex Mark Kirkwood
• 06:49   Re: When/if to Reindex Gregory Stark
• 08:53   partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton
• 10:24   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mikko Partio
• 10:32   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton
• 10:39   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas
• 14:22   Re: When/if to Reindex Steven Flatt
• 16:15   Re: When/if to Reindex Tom Lane
• 16:20   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 16:26   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 16:56   Re: When/if to Reindex Steven Flatt
• 17:29   Re: When/if to Reindex Tom Lane
• 17:49   Re: When/if to Reindex Steven Flatt
• 20:05   significant vacuum issues - looking for suggestions Kevin Kempter
• 20:07   Re: When/if to Reindex Gregory Stark
• 20:42   Re: significant vacuum issues - looking for suggestions Bill Moran
• 20:53   Re: significant vacuum issues - looking for suggestions Kevin Grittner
• 21:08   Re: significant vacuum issues - looking for suggestions Bill Moran
• 21:39   Re: significant vacuum issues - looking for suggestions Tom Lane
• 21:44   Re: When/if to Reindex Tom Lane

25 August 2007

• 00:42   Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai
• 00:54   Re: Partioning tsearch2 a table into chunks and accessing via views Brandon Shalton
• 01:29   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Joshua D. Drake
• 05:34   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai
• 05:35   Re: significant vacuum issues - looking for suggestions Kevin Kempter
• 16:18   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Joshua D. Drake
• 18:14   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai
• 18:18   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Brandon Shalton
• 18:18   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Joshua D. Drake
• 19:49   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai
• 19:58   Re: Partioning tsearch2 a table into chunks and accessing via views Erik Jones
• 20:09   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Erik Jones
• 20:24   Shared memory usage Max Zorloff
• 20:40   Re: [GENERAL] Shared memory usage Martijn van Oosterhout
• 21:24   Re: [GENERAL] Shared memory usage Max Zorloff
• 21:34   Re: [GENERAL] Shared memory usage Max Zorloff

27 August 2007

• 10:21   Re: Shared memory usage Adam Tauno Williams
• 11:48   Postgres performance problem Ruben Rubio
• 12:20   Re: Shared memory usage Max Zorloff
• 12:34   Re: Postgres performance problem Chris Mair
• 12:52   Re: Postgres performance problem ruben@rentalia.com
• 13:14   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Tomas Tamosaitis
• 13:29   Re: Postgres performance problem Bill Moran
• 14:36   Performance issue Willo van der Merwe
• 14:45   Re: Performance issue Bill Moran
• 15:56   Re: Performance issue Tom Lane
• 20:11   Re: asynchronous commit feature Decibel!
• 21:00   Re: significant vacuum issues - looking for suggestions Decibel!
• 21:18   Re: asynchronous commit feature Merlin Moncure
• 21:56   Re: significant vacuum issues - looking for suggestions Kevin Grittner
• 22:01   Re: significant vacuum issues - looking for suggestions Kevin Kempter
• 22:04   Re: significant vacuum issues - looking for suggestions Decibel!
• 22:05   Re: significant vacuum issues - looking for suggestions Kevin Kempter
• 22:07   Re: significant vacuum issues - looking for suggestions Kevin Kempter

28 August 2007

• 04:15   server performance issues - suggestions for tuning Kevin Kempter
• 07:52   Re: server performance issues - suggestions for tuning Richard Huxton
• 08:49   index & Bitmap Heap Scan Paul
• 09:34   Re: Performance issue Willo van der Merwe
• 10:21   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas
• 13:05   Performance across multiple schemas Robins
• 13:12   Re: server performance issues - suggestions for tuning Kevin Grittner
• 13:44   Re: Performance across multiple schemas Robins
• 13:50   Re: Performance across multiple schemas Tom Lane
• 14:27   Re: server performance issues - suggestions for tuning Andrew Sullivan
• 14:32   Re: server performance issues - suggestions for tuning Scott Marlowe
• 14:43   Re: Autovacuum is running forever Sachchida Ojha
• 14:44   Re: Optimising "in" queries Stephen Davies
• 14:44   Re: io storm on checkpoints, postgresql 8.2.4, linux Kenneth Marshall
• 14:46   Re: Optimising "in" queries Stephen Davies
• 14:47   Performance issue Willo van der Merwe
• 14:48   Bitmap Heap Scan before using index GOERGLER Paul
• 15:01   Re: io storm on checkpoints, postgresql 8.2.4, linux Erik Jones
• 15:09   8.2.4 Chooses Bad Query Plan Pallav Kalva
• 15:22   8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll
• 15:32   Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Scott Marlowe
• 15:58   Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Gregory Stark
• 16:14   Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Joshua D. Drake
• 16:20   Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Kevin Grittner
• 16:25   Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll
• 16:36   Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll
• 16:51   Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Mark Lewis
• 16:56   Re: index & Bitmap Heap Scan Tom Lane
• 18:36   Re: Postgres performance problem Anton Melser
• 18:36   Re: 8.2.4 Chooses Bad Query Plan Tom Lane
• 18:48   Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Tom Lane
• 18:53   Performance problem with table containing a lot of text (blog) Kari Lavikka
• 19:04   Re: Performance problem with table containing a lot of text (blog) Dan Harris
• 19:10   Re: Performance problem with table containing a lot of text (blog) Kari Lavikka
• 19:29   Re: 8.2.4 Chooses Bad Query Plan Pallav Kalva
• 21:06   Re: 8.2.4 Chooses Bad Query Plan Tom Lane
• 21:34   Re: io storm on checkpoints, postgresql 8.2.4, linux Decibel!

29 August 2007

• 02:45   Re: Performance across multiple schemas Robins
• 08:16   Re: index & Bitmap Heap Scan Paul
• 08:30   Re: Performance problem with table containing a lot of text (blog) Heikki Linnakangas
• 09:39   Re: Performance problem with table containing a lot of text (blog) Kari Lavikka
• 10:15   Re: Performance problem with table containing a lot of text (blog) Heikki Linnakangas
• 14:33   Performance issue with nested loop Jens Reufsteck
• 16:59   Re: 8.2 Query 10 times slower than 8.1 (view-heavy) Evan Carroll
• 16:59   Performance issue with nested loop Jens Reufsteck
• 17:00   LIKE query verses = Karthikeyan Mahadevan
• 17:00   Re: Performance across multiple schemas Robins Tharakan
• 17:12   Re: LIKE query verses = Mark Lewis
• 17:52   Re: LIKE query verses = Tom Lane
• 19:26   Re: Shared memory usage Greg Smith
• 19:31   Transaction Log mbguy2000-1@yahoo.com
• 19:37   Transaction Log Markus Benne
• 19:54   Re: Transaction Log Mark Mielke
• 20:11   Re: Transaction Log Steve Atkins
• 20:18   Re: Transaction Log Steinar H. Gunderson
• 20:22   Re: Transaction Log Bill Moran
• 20:37   Re: Transaction Log Alan Hodgson

30 August 2007

• 05:42   Re: Shared memory usage Max Zorloff
• 07:52   Re: Postgres performance problem ruben@rentalia.com
• 09:50   Re: [Solved] Postgres performance problem Ruben Rubio
• 17:32   Re: [Solved] Postgres performance problem Decibel!
• 18:08   Re: [Solved] Postgres performance problem Mark Lewis
• 18:13   Re: [Solved] Postgres performance problem Richard Huxton

31 August 2007

• 15:31   8.2 Autovacuum BUG ? Pallav Kalva
• 15:39   Re: 8.2 Autovacuum BUG ? Tom Lane
• 16:05   Re: 8.2 Autovacuum BUG ? Pallav Kalva
• 16:12   Re: 8.2 Autovacuum BUG ? Alvaro Herrera
• 16:25   Re: 8.2 Autovacuum BUG ? Pallav Kalva
• 16:29   Re: 8.2 Autovacuum BUG ? Mark Lewis
• 18:04   Re: 8.2 Autovacuum BUG ? Chris Browne
• 18:32   Re: 8.2 Autovacuum BUG ? Mikko Partio
• 18:42   Re: 8.2 Autovacuum BUG ? Pallav Kalva
• 18:47   Re: 8.2 Autovacuum BUG ? Alvaro Herrera
• 18:51   Re: 8.2 Autovacuum BUG ? Alvaro Herrera
• 19:08   Re: 8.2 Autovacuum BUG ? Tom Lane
• 19:36   Re: 8.2 Autovacuum BUG ? Erik Jones
• 19:36   Re: [Solved] Postgres performance problem Vivek Khera
• 19:48   Re: 8.2 Autovacuum BUG ? Tom Lane
• 20:04   Re: 8.2 Autovacuum BUG ? Chris Browne
• 23:25   Re: 8.2 Autovacuum BUG ? Greg Smith
• 23:41   Re: Fwd: 8.2 Query 10 times slower than 8.1 (view-heavy) Tom Lane
• 23:48   Re: 8.2 Autovacuum BUG ? Tom Lane