Mailing lists [pgsql-performance]

1 August 2007

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

2 August 2007

• 13:08   cpu throttling Bryan Murphy
• 13:14   Re: cpu throttling Alan Hodgson
• 15:10   Re: cpu throttling Bryan Murphy
• 18:32   Why are distinct and group by choosing different plans? Ron Mayer
• 19:37   Re: Why are distinct and group by choosing different plans? Gregory Stark
• 21:48   Re: Why are distinct and group by choosing different plans? Tom Lane
• 22:47   RES: RES: Improving select peformance Carlos H. Reimer
• 23:13   Re: RES: RES: Improving select peformance Tom Lane

3 August 2007

• 10:59   Performance problems with large telemetric datasets on 7.4.2 Sven Clement
• 11:20   Re: Performance problems with large telemetric datasets on 7.4.2 Mark Lewis
• 11:26   Re: Performance problems with large telemetric datasets on 7.4.2 Dan Langille
• 12:57   Re: Performance problems with large telemetric datasets on 7.4.2 Sven Clement
• 14:55   Re: Performance problems with large telemetric datasets on 7.4.2 Josh Berkus
• 15:11   Postgres optimizer Mouhamadou Dia
• 15:28   Re: Postgres optimizer Mark Lewis
• 17:10   CLOG Patch Jignesh K. Shah
• 17:28   Re: CLOG Patch Simon Riggs
• 18:14   Re: Performance problems with large telemetric datasets on 7.4.2 Andrew Kroeger
• 19:18   Re: cpu throttling Decibel!
• 19:34   Re: Performance problems with large telemetric datasets on 7.4.2 Tom Lane

4 August 2007

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

5 August 2007

• 13:08   Re: Performance problems with large telemetric datasets on 7.4.2 Heikki Linnakangas
• 22:56   Re: Default Performance between 8.0 and 8.1 Merlin Moncure

6 August 2007

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

7 August 2007

• 09:58   Update table performance Mark Makarowsky
• 10:33   Re: Update table performance Richard Huxton
• 11:07   Re: Performance problems with large telemetric datasets on 7.4.2 Scott Marlowe
• 11:53   Re: Update table performance Scott Marlowe
• 13:03   Re: Update table performance Alan Hodgson
• 15:00   Re: Update table performance Decibel!
• 15:03   Re: Update table performance Chris Browne
• 16:36   Re: Update table performance Scott Marlowe
• 18:42   Re: Update table performance Decibel!
• 20:13   Re: Update table performance Mark Makarowsky
• 22:46   Re: Update table performance Erik Jones

8 August 2007

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

9 August 2007

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

10 August 2007

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

11 August 2007

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

13 August 2007

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

14 August 2007

• 07:21   RAID 10 or RAID 10 + RAID 1 Michael Ben-Nes
• 18:32   Re: RAID 10 or RAID 10 + RAID 1 Decibel!

15 August 2007

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

16 August 2007

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

17 August 2007

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

18 August 2007

• 00:04   Re: Simple select hangs while CPU close to 100% - Analyze Alvaro Herrera
• 00:08   Re: Performance Solaris vs Linux Alvaro Herrera
• 07:13   Re: Performance Solaris vs Linux Chris Mair
• 08:12   Re: Fwd: Table Partitioning Henrik
• 22:02   Re: Help optimize view Kevin Grittner
• 22:12   Re: Help optimize view Kevin Grittner

19 August 2007

• 10:20   schema design question mark overmeer
• 11:24   Re: schema design question Adam Tauno Williams
• 12:23   Re: schema design question mark overmeer
• 15:12   Re: schema design question David Fetter
• 15:27   Re: schema design question Steinar H. Gunderson
• 15:41   Re: schema design question David Fetter
• 16:48   Re: [pgsql-jobs] Looking for database hosting Andrew Hammond
• 17:13   Re: schema design question mark overmeer
• 17:16   Re: [pgsql-jobs] Looking for database hosting Luke Lonergan
• 17:23   Re: schema design question David Fetter
• 17:42   Re: schema design question Steinar H. Gunderson
• 18:50   Re: Looking for database hosting: FIX CC LIST!! Josh Berkus
• 18:56   Re: [pgsql-jobs] Looking for database hosting Leon Mergen
• 21:22   Re: schema design question Adam Tauno Williams
• 21:37   Re: [pgsql-jobs] Looking for database hosting Andrew Hammond

20 August 2007

• 11:03   Re: Help optimize view Relyea, Mike
• 11:36   Terminology Question Campbell, Lance
• 11:50   Re: Terminology Question Scott Marlowe
• 14:55   Re: Terminology Question Joshua D. Drake

21 August 2007

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

22 August 2007

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

23 August 2007

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

24 August 2007

• 00:59   Re: When/if to Reindex Tom Lane
• 02:27   Re: When/if to Reindex Mark Kirkwood
• 03:49   Re: When/if to Reindex Gregory Stark
• 05:53   partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton
• 07:24   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Mikko Partio
• 07:32   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Anton
• 07:39   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Heikki Linnakangas
• 11:22   Re: When/if to Reindex Steven Flatt
• 13:15   Re: When/if to Reindex Tom Lane
• 13:20   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 13:26   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Luke Lonergan
• 13:56   Re: When/if to Reindex Steven Flatt
• 14:29   Re: When/if to Reindex Tom Lane
• 14:49   Re: When/if to Reindex Steven Flatt
• 17:05   significant vacuum issues - looking for suggestions Kevin Kempter
• 17:07   Re: When/if to Reindex Gregory Stark
• 17:42   Re: significant vacuum issues - looking for suggestions Bill Moran
• 17:53   Re: significant vacuum issues - looking for suggestions Kevin Grittner
• 18:08   Re: significant vacuum issues - looking for suggestions Bill Moran
• 18:39   Re: significant vacuum issues - looking for suggestions Tom Lane
• 18:44   Re: When/if to Reindex Tom Lane
• 21:42   Partioning tsearch2 a table into chunks and accessing via views Benjamin Arai
• 21:54   Re: Partioning tsearch2 a table into chunks and accessing via views Brandon Shalton
• 22:29   Re: [GENERAL] Partioning tsearch2 a table into chunks and accessing via views Joshua D. Drake

25 August 2007

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

27 August 2007

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

28 August 2007

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

29 August 2007

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

30 August 2007

• 02:42   Re: Shared memory usage Max Zorloff
• 04:52   Re: Postgres performance problem ruben@rentalia.com
• 06:50   Re: [Solved] Postgres performance problem Ruben Rubio
• 14:32   Re: [Solved] Postgres performance problem Decibel!
• 15:08   Re: [Solved] Postgres performance problem Mark Lewis
• 15:13   Re: [Solved] Postgres performance problem Richard Huxton

31 August 2007

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