Mailing lists [pgsql-performance]

1 April 2008

• 00:23   Performance Implications of Using Exceptions Ravi Chemudugunta
• 00:52   Re: Performance Implications of Using Exceptions Stephen Frost
• 00:56   Re: Performance Implications of Using Exceptions Stephen Denne
• 01:23   Re: Performance Implications of Using Exceptions Ravi Chemudugunta
• 02:26   Re: Performance Implications of Using Exceptions Robins Tharakan
• 04:29   Re: Performance Implications of Using Exceptions Tom Lane
• 05:16   Re: POSIX file updates Tom Lane
• 07:54   Re: Bad prepare performance Cédric Villemain
• 11:54   check performance parameters Sabin Coanda
• 12:46   Cursors and different settings for default_statistics_target Hell, Robert
• 13:56   Re: check performance parameters Matthew
• 15:30   Re: Cursors and different settings for default_statistics_target Tom Lane
• 15:38   Insert time Ioana Danes
• 15:50   Re: Cursors and different settings for default_statistics_target Hell, Robert
• 16:17   Re: Cursors and different settings for default_statistics_target Tom Lane
• 16:35   Re: Cursors and different settings for default_statistics_target Hell, Robert
• 16:42   Re: Cursors and different settings for default_statistics_target Tom Lane
• 19:58   Re: Cursors and different settings for default_statistics_target Steinar H. Gunderson
• 20:58   Too many commands in a transaction samantha mahindrakar
• 21:15   Re: Cursors and different settings for default_statistics_target Hell, Robert
• 22:23   Re: Cursors and different settings for default_statistics_target Tom Lane

2 April 2008

• 06:12   SSDs James Mansion
• 06:44   Re: SSDs Arjen van der Meijden
• 10:13   Re: Cursors and different settings for default_statistics_target Hell, Robert
• 19:06   Re: POSIX file updates James Mansion
• 19:16   Re: Performance Implications of Using Exceptions James Mansion
• 20:46   Re: POSIX file updates Andreas Kostyrka
• 22:44   Re: POSIX file updates James Mansion
• 23:40   Re: POSIX file updates Greg Smith
• 23:50   Re: POSIX file updates Greg Smith

3 April 2008

• 04:36   Re: SSDs Merlin Moncure
• 04:56   Max shared_buffers bitaoxiao
• 05:28   Re: POSIX file updates James Mansion
• 09:24   Re: Performance Implications of Using Exceptions chemuduguntar@gmail.com
• 10:11   Re: Max shared_buffers sathiya psql
• 13:28   Re: Performance Implications of Using Exceptions Robins Tharakan
• 16:49   Re: Max shared_buffers Scott Marlowe
• 17:16   Re: Max shared_buffers Andrej Ricnik-Bay
• 17:21   Re: Max shared_buffers Matthew
• 17:23   [Fwd: Re: Max shared_buffers] Justin
• 17:49   Re: Max shared_buffers Scott Marlowe
• 17:58   Re: Max shared_buffers Craig Ringer
• 23:31   Query plan excluding index on view Matt Klinker
• 23:50   Re: Query plan excluding index on view Tom Lane

4 April 2008

• 04:58   Re: Query plan excluding index on view Matt Klinker
• 05:49   Re: Query plan excluding index on view Tom Lane
• 06:03   Forcing more agressive index scans for BITMAP AND Ow Mun Heng
• 10:40   Re: Forcing more agressive index scans for BITMAP AND Matthew
• 10:59   Re: Forcing more agressive index scans for BITMAP AND PFC
• 18:47   Re: Query plan excluding index on view Matt Klinker

5 April 2008

• 00:48   Partitioned tables - planner wont use indexes kevin kempter
• 01:07   Re: Partitioned tables - planner wont use indexes paul rivers
• 01:26   Re: Partitioned tables - planner wont use indexes Gregory Stark
• 04:20   Re: Query plan excluding index on view Tom Lane

6 April 2008

• 20:17   Re: Performance Implications of Using Exceptions James Mansion

7 April 2008

• 08:15   Forcing more agressive index scans for BITMAP AND Ow Mun Heng
• 10:50   Re: Forcing more agressive index scans for BITMAP AND Matthew
• 12:18   Looking for bottleneck during load test Hell, Robert
• 12:37   Re: Looking for bottleneck during load test Ivan Voras
• 15:46   Re: [SOLVED] Query plan excluding index on view Matt Klinker
• 15:51   Severe performance problems for simple query Dimi Paun
• 16:08   Re: Partitioned tables - planner wont use indexes Bricklen Anderson
• 16:19   Re: Severe performance problems for simple query Matthew
• 16:28   Re: Severe performance problems for simple query Matthew
• 16:32   Re: Severe performance problems for simple query Heikki Linnakangas
• 16:41   Re: Severe performance problems for simple query Dimi Paun
• 16:45   Re: Severe performance problems for simple query Dimi Paun
• 17:03   Re: Severe performance problems for simple query Matthew
• 17:14   performance using table partitions in Postgres 8.2.6 Janet Jacobsen
• 18:06   Re: performance using table partitions in Postgres 8.2.6 Albert Cervera Areny
• 18:27   Performance with temporary table samantha mahindrakar
• 18:35   what worked: performance improvements for geo-spatial searching on FreeBSD Mark Stosberg
• 18:40   recommendations for web/db connection pooling or DBD::Gofer reviews Mark Stosberg
• 18:42   Re: recommendations for web/db connection pooling or DBD::Gofer reviews Joshua D. Drake
• 18:48   Re: what worked: performance improvements for geo-spatial searching on FreeBSD Oleg Bartunov
• 19:38   Re: Severe performance problems for simple query Florian Weimer
• 19:50   per-review of PgBouncer / Slony design Mark Stosberg
• 20:14   Re: Looking for bottleneck during load test Hell, Robert
• 20:20   Re: Looking for bottleneck during load test Bill Moran
• 20:40   Re: Looking for bottleneck during load test Greg Smith
• 20:50   Re: Looking for bottleneck during load test Bill Moran

8 April 2008

• 03:02   bulk insert performance problem Christian Bourque
• 03:19   Re: bulk insert performance problem Craig Ringer
• 03:35   Re: bulk insert performance problem Chris
• 03:42   bulk data loading Potluri Srikanth
• 03:50   Re: bulk insert performance problem bitaoxiao
• 06:08   Re: Forcing more agressive index scans for BITMAP AND Ow Mun Heng
• 07:40   Re: bulk data loading Magnus Hagander
• 08:41   Re: bulk insert performance problem hubert depesz lubaczewski
• 09:03   Re: Looking for bottleneck during load test Ivan Voras
• 09:18   Re: Looking for bottleneck during load test Hell, Robert
• 11:02   Re: Forcing more agressive index scans for BITMAP AND Matthew
• 13:45   Re: what worked: performance improvements for geo-spatial searching on FreeBSD Mark Stosberg
• 13:53   Re: bulk insert performance problem Mark Stosberg
• 14:04   Re: bulk insert performance problem Matthew
• 15:51   Re: Performance with temporary table Richard Huxton
• 16:17   Re: Performance with temporary table Alvaro Herrera
• 17:39   Re: Re: what worked: performance improvements for geo-spatial searching on FreeBSD Oleg Bartunov
• 19:28   Re: Performance with temporary table samantha mahindrakar
• 19:43   Re: Performance with temporary table Alvaro Herrera
• 22:36   Re: recommendations for web/db connection pooling or DBD::Gofer reviews PFC
• 22:44   Re: bulk insert performance problem PFC

9 April 2008

• 09:58   EXPLAIN detail Luigi N. Puleio
• 10:04   Re: EXPLAIN detail Pavan Deolasee
• 10:28   Re: EXPLAIN detail Craig Ringer
• 10:33   Re: EXPLAIN detail Matthew
• 10:55   Re: Performance with temporary table valgog
• 11:06   Re: EXPLAIN detail Luigi N. Puleio
• 11:16   Re: EXPLAIN detail Craig Ringer
• 13:46   Re: EXPLAIN detail Luigi N. Puleio
• 14:15   Re: EXPLAIN detail Craig Ringer
• 14:44   Re: EXPLAIN detail Luigi N. Puleio
• 15:29   Re: EXPLAIN detail Craig Ringer
• 18:37   Re: EXPLAIN detail PFC
• 20:00   Re: Performance Implications of Using Exceptions Decibel!
• 20:10   Re: Performance with temporary table Decibel!
• 20:58   large tables and simple "= constant" queries using indexes John Beaver
• 21:21   Re: large tables and simple "= constant" queries using indexes Arjen van der Meijden
• 21:36   Re: large tables and simple "= constant" queries using indexes Bill Moran
• 22:17   Re: EXPLAIN detail Richard Broersma
• 22:26   Re: large tables and simple "= constant" queries using indexes PFC
• 22:31   Re: large tables and simple "= constant" queries using indexes Jeremy Harris
• 23:33   Re: Performance with temporary table samantha mahindrakar
• 23:41   Re: Performance with temporary table samantha mahindrakar

10 April 2008

• 02:32   Re: Performance with temporary table Erik Jones
• 02:43   Re: Performance with temporary table samantha mahindrakar
• 03:14   varchar index joins not working? Adam Gundy
• 07:22   Re: large tables and simple "= constant" queries using indexes Arjen van der Meijden
• 08:21   Re: large tables and simple "= constant" queries using indexes PFC
• 08:46   Re: varchar index joins not working? Richard Huxton
• 09:51   Re: large tables and simple "= constant" queries using indexes Matthew
• 14:45   Re: large tables and simple "= constant" queries using indexes John Beaver
• 14:49   Creating large database of MD5 hash values Jon Stewart
• 14:52   Re: varchar index joins not working? Adam Gundy
• 15:03   Re: large tables and simple "= constant" queries using indexes Erik Jones
• 15:26   Re: Performance with temporary table valgog
• 16:37   Re: large tables and simple "= constant" queries using indexes John Beaver
• 17:09   Re: large tables and simple "= constant" queries using indexes Bill Moran
• 18:48   Re: large tables and simple "= constant" queries using indexes Greg Smith
• 18:54   Re: varchar index joins not working? Adam Gundy
• 19:11   Partitioned tables - planner wont use indexes kevin kempter
• 21:29   Re: recommendations for web/db connection pooling or DBD::Gofer reviews Mark Stosberg
• 21:33   Re: large tables and simple "= constant" queries using indexes PFC
• 22:28   Performance is low Postgres+Solaris MUNAGALA REDDY
• 22:28   Re: Looking for bottleneck during load test Ivan Voras
• 22:28   Re: large tables and simple "= constant" queries using indexes Gaetano Mendola
• 22:28   Re: Views and functions returning sets of records Rajashri Tupe
• 22:28   shared_buffers in 8.2.x Gaetano Mendola
• 22:33   Re: shared_buffers in 8.2.x Erik Jones
• 23:28   Re: Performance is low Postgres+Solaris Reid Thompson

11 April 2008

• 00:14   Re: Performance is low Postgres+Solaris Reid Thompson
• 07:24   Re: Views and functions returning sets of records Craig Ringer
• 10:37   Re: Partitioned tables - planner wont use indexes PFC
• 11:22   Performance increase with elevator=deadline Albe Laurenz
• 12:24   Re: Creating large database of MD5 hash values Chris
• 14:13   Re: Creating large database of MD5 hash values Florian Weimer
• 14:38   Re: Creating large database of MD5 hash values Alvaro Herrera
• 14:44   Re: recommendations for web/db connection pooling or DBD::Gofer reviews Vivek Khera
• 14:47   Re: Performance increase with elevator=deadline Gregory Stark
• 15:29   Re: Creating large database of MD5 hash values Jon Stewart
• 16:10   Re: Performance increase with elevator=deadline Jeff
• 16:40   Re: Performance increase with elevator=deadline Matthew
• 17:04   Re: Creating large database of MD5 hash values Florian Weimer
• 18:04   Re: Performance increase with elevator=deadline Craig Ringer
• 19:56   Re: Performance increase with elevator=deadline Greg Smith
• 20:26   Re: Performance is low Postgres+Solaris Greg Smith

12 April 2008

• 09:09   Re: Cached Query Plans PFC

14 April 2008

• 06:39   db size Adrian Moisey
• 06:53   Re: db size Vinubalaji Gopal
• 07:14   Re: varchar index joins not working? Richard Huxton
• 07:38   Re: db size Craig Ringer
• 09:12   shared_buffers performance Gaetano Mendola
• 09:14   Re: db size PFC
• 09:22   Re: db size Adrian Moisey
• 09:29   Re: db size PFC
• 09:41   Re: db size Craig Ringer
• 09:44   Re: db size Adrian Moisey
• 09:57   Re: db size PFC
• 10:56   Re: shared_buffers performance Gregory Stark
• 11:26   Re: shared_buffers performance Richard Huxton
• 13:14   Re: db size Bill Moran
• 15:43   Re: shared_buffers performance Greg Smith
• 15:44   Re: shared_buffers performance Greg Smith
• 17:02   Re: varchar index joins not working? Adam Gundy
• 17:46   Re: varchar index joins not working? Tom Lane
• 17:54   Re: varchar index joins not working? Richard Huxton
• 19:33   Re: shared_buffers performance Tom Lane
• 19:58   Re: shared_buffers performance Gregory Stark
• 20:08   Re: shared_buffers performance Greg Smith
• 21:12   Re: varchar index joins not working? Adam Gundy
• 22:01   Re: varchar index joins not working? Tom Lane
• 22:16   Re: varchar index joins not working? Adam Gundy

15 April 2008

• 07:33   Re: db size Adrian Moisey
• 09:25   Re: shared_buffers performance Gaetano Mendola
• 09:25   Re: shared_buffers performance Gaetano Mendola
• 11:12   Re: db size Bill Moran
• 13:27   Re: Performance increase with elevator=deadline Florian Weimer
• 15:07   Re: shared_buffers performance Gaetano Mendola
• 19:02   Oddly slow queries Thomas Spreng
• 19:02   Re: Performance increase with elevator=deadline david@lang.hm
• 23:19   Re: Oddly slow queries PFC

16 April 2008

• 04:07   Re: Oddly slow queries Thomas Spreng
• 05:31   Re: Performance increase with elevator=deadline Albe Laurenz
• 08:17   Re: Oddly slow queries PFC
• 15:06   SQL Function Slowness, 8.3.0 Gavin M. Roy
• 15:10   Re: SQL Function Slowness, 8.3.0 Tom Lane
• 15:14   Re: SQL Function Slowness, 8.3.0 Mark Mielke
• 15:23   Background writer underemphasized ... Marinos Yannikos
• 16:26   Re: Oddly slow queries Chris Browne
• 18:34   Re: Background writer underemphasized ... Chris Browne
• 18:48   Re: Background writer underemphasized ... Bill Moran
• 18:48   Re: SQL Function Slowness, 8.3.0 Gavin M. Roy
• 18:58   Re: SQL Function Slowness, 8.3.0 Joshua D. Drake
• 19:45   Re: Background writer underemphasized ... Greg Smith
• 19:56   Re: Background writer underemphasized ... Greg Smith
• 20:07   Re: Background writer underemphasized ... Bill Moran
• 20:15   Anybody using the Dell Powervault MD3000 array? Jeffrey Baker
• 20:17   Re: Anybody using the Dell Powervault MD3000 array? Gavin M. Roy
• 20:20   Re: Anybody using the Dell Powervault MD3000 array? Joshua D. Drake
• 20:24   Re: SQL Function Slowness, 8.3.0 Tom Lane
• 20:37   Re: Anybody using the Dell Powervault MD3000 array? Jeffrey Baker
• 20:39   Re: Anybody using the Dell Powervault MD3000 array? Joshua D. Drake
• 20:53   Re: Anybody using the Dell Powervault MD3000 array? Gavin M. Roy
• 21:14   Query running slow samantha mahindrakar
• 21:48   Re: Oddly slow queries Thomas Spreng
• 23:15   Re: Query running slow PFC

17 April 2008

• 00:08   Re: Anybody using the Dell Powervault MD3000 array? Craig James
• 03:20   Re: Oddly slow queries Andrew Sullivan
• 06:29   Re: db size Adrian Moisey
• 07:58   Strange behavior: pgbench and new Linux kernels Greg Smith
• 08:15   Re: db size Richard Huxton
• 08:37   Re: db size Adrian Moisey
• 08:43   Re: db size Adrian Moisey
• 08:52   Re: db size Richard Huxton
• 09:35   Exact index overhead Gunther Mayer
• 10:00   Re: Exact index overhead Richard Huxton
• 10:03   Re: Exact index overhead Heikki Linnakangas
• 10:16   Re: Exact index overhead Pavan Deolasee
• 12:04   rename constraint sathiya psql
• 12:14   Re: rename constraint Thomas Spreng
• 15:49   Re: Exact index overhead Gunther Mayer
• 15:52   Re: Strange behavior: pgbench and new Linux kernels Matthew
• 16:11   Re: SQL Function Slowness, 8.3.0 Simon Riggs
• 16:13   Re: SQL Function Slowness, 8.3.0 Tom Lane
• 16:24   Re: SQL Function Slowness, 8.3.0 Simon Riggs
• 16:41   Re: SQL Function Slowness, 8.3.0 Tom Lane
• 16:49   Re: SQL Function Slowness, 8.3.0 Simon Riggs
• 17:01   Re: SQL Function Slowness, 8.3.0 Craig Ringer
• 17:09   Re: Strange behavior: pgbench and new Linux kernels Jeffrey Baker
• 17:15   Re: SQL Function Slowness, 8.3.0 Alvaro Herrera
• 17:50   Re: Strange behavior: pgbench and new Linux kernels Matthew
• 18:15   Re: Strange behavior: pgbench and new Linux kernels Greg Smith
• 18:19   Re: POSIX file updates Greg Smith
• 18:24   seq scan issue... kevin kempter
• 18:30   Re: seq scan issue... Jeffrey Baker
• 18:31   Re: seq scan issue... Rodrigo Gonzalez
• 18:46   Re: Background writer underemphasized ... Marinos Yannikos
• 23:38   Re: SQL Function Slowness, 8.3.0 Tom Lane
• 23:48   Re: seq scan issue... PFC

18 April 2008

• 00:26   Re: Strange behavior: pgbench and new Linux kernels Greg Smith
• 00:35   Re: Strange behavior: pgbench and new Linux kernels david@lang.hm
• 03:25   Re: Strange behavior: pgbench and new Linux kernels Greg Smith
• 03:41   Re: SQL Function Slowness, 8.3.0 Craig Ringer
• 03:55   Group by more efficient than distinct? Francisco Reyes
• 04:01   Re: SQL Function Slowness, 8.3.0 Tom Lane
• 04:22   Re: SQL Function Slowness, 8.3.0 Craig Ringer
• 05:31   Re: Strange behavior: pgbench and new Linux kernels Tom Lane
• 06:47   Re: Strange behavior: pgbench and new Linux kernels Greg Smith
• 08:54   Re: Group by more efficient than distinct? Thomas Pundt
• 09:36   Re: Group by more efficient than distinct? Gregory Stark
• 10:30   Re: Group by more efficient than distinct? PFC
• 11:01   Re: Strange behavior: pgbench and new Linux kernels Matthew
• 14:38   Re: Performance increase with elevator=deadline Enrico Sirola
• 16:35   3-days-long vacuum of 20GB table Jeffrey Baker
• 17:04   Re: 3-days-long vacuum of 20GB table Tom Lane
• 17:19   Re: Strange behavior: pgbench and new Linux kernels Greg Smith
• 17:32   Re: 3-days-long vacuum of 20GB table Jeffrey Baker
• 17:35   Re: 3-days-long vacuum of 20GB table Jeffrey Baker
• 17:50   Message queue table.. Jesper Krogh
• 17:54   Re: 3-days-long vacuum of 20GB table Jeffrey Baker
• 18:19   Re: Message queue table.. Craig Ringer
• 18:24   Re: 3-days-long vacuum of 20GB table Alvaro Herrera
• 19:09   Re: 3-days-long vacuum of 20GB table Tom Lane
• 19:23   Re: Message queue table.. Jesper Krogh
• 19:27   Re: Message queue table.. Tom Lane
• 19:51   full_page_write and also compressed logging James Mansion
• 20:26   Re: Message queue table.. Chris Browne

19 April 2008

• 05:57   Re: 3-days-long vacuum of 20GB table Heikki Linnakangas
• 09:23   Re: Background writer underemphasized ... Greg Smith
• 15:01   Re: Background writer underemphasized ... James Mansion
• 16:48   Re: Exact index overhead Scott Marlowe
• 17:04   Re: Oddly slow queries Scott Marlowe
• 17:56   Re: Oddly slow queries Christopher Browne
• 19:29   Re: Background writer underemphasized ... Greg Smith

20 April 2008

• 14:37   Re: Background writer underemphasized ... James Mansion
• 15:12   Re: Group by more efficient than distinct? Francisco Reyes
• 15:15   Re: Group by more efficient than distinct? Francisco Reyes
• 15:53   Vacuum settings dforums
• 20:00   corrupted shared memory message Pablo Alcaraz

21 April 2008

• 01:31   Re: corrupted shared memory message Tom Lane
• 05:36   Re: Group by more efficient than distinct? Luke Lonergan
• 09:50   connections slowing everything down? Adrian Moisey
• 11:16   Performance of the Materialize operator in a query plan Viktor Rosenfeld
• 14:04   Re: connections slowing everything down? Erik Jones
• 14:15   Re: connections slowing everything down? Adrian Moisey
• 14:45   Re: Performance of the Materialize operator in a query plan Tom Lane
• 14:46   Re: connections slowing everything down? Erik Jones
• 15:03   Re: Vacuum settings Alvaro Herrera
• 15:31   Re: Vacuum settings Guillaume Cottenceau
• 16:29   Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Robert Treat
• 16:54   Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Alvaro Herrera
• 23:29   Re: Group by more efficient than distinct? PFC
• 23:50   Re: Group by more efficient than distinct? Mark Mielke

22 April 2008

• 01:39   Re: Group by more efficient than distinct? Mark Mielke
• 09:48   Re: Oddly slow queries Thomas Spreng
• 10:24   Re: Oddly slow queries PFC
• 10:34   Re: Group by more efficient than distinct? Matthew Wakeling
• 12:01   Re: Group by more efficient than distinct? Mark Mielke
• 12:22   Re: Group by more efficient than distinct? Matthew Wakeling
• 13:04   Re: Group by more efficient than distinct? Mark Mielke
• 13:42   Re: Oddly slow queries Thomas Spreng
• 15:25   Re: Oddly slow queries Scott Marlowe
• 15:38   CPU bound at 99% Bryan Buecking
• 15:41   Re: CPU bound at 99% Joshua D. Drake
• 15:56   Re: CPU bound at 99% Erik Jones
• 15:56   Re: CPU bound at 99% Bryan Buecking
• 16:10   Re: CPU bound at 99% Bryan Buecking
• 16:15   Re: CPU bound at 99% Harald Armin Massa
• 16:16   Re: CPU bound at 99% Bryan Buecking
• 16:21   Re: CPU bound at 99% Rodrigo Gonzalez
• 16:22   Re: CPU bound at 99% Bryan Buecking
• 16:24   Re: CPU bound at 99% Scott Marlowe
• 16:25   Re: CPU bound at 99% Tom Lane
• 16:36   Re: CPU bound at 99% Craig Ringer
• 16:40   Re: CPU bound at 99% PFC
• 17:37   Suspicious top output Rafael Barrera Oro
• 21:05   [PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536" Adonias Malosso
• 21:55   Re: [PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536" Tom Lane
• 23:50   Re: Suspicious top output Ivan Voras
• 23:59   Re: CPU bound at 99% Ivan Voras

23 April 2008

• 00:47   Re: connections slowing everything down? Merlin Moncure
• 03:31   Re: [PERFORMANCE] Error loading 37G CSV file "invalid string enlargement request size 65536" Shane Ambler
• 05:26   Re: Background writer underemphasized ... Greg Smith
• 05:43   Re: Suspicious top output Greg Smith
• 07:19   SELECT 'DBD::Pg ping test' sathiya psql
• 07:29   Re: SELECT 'DBD::Pg ping test' Craig Ringer
• 07:38   mysterious difference in speed when combining two queries with OR Hans Ekbrand
• 07:59   Re: mysterious difference in speed when combining two queries with OR A. Kretschmer
• 08:57   Re: mysterious difference in speed when combining two queries with OR A. Kretschmer
• 09:06   Re: mysterious difference in speed when combining two queries with OR hans
• 09:22   Re: mysterious difference in speed when combining two queries with OR Hans Ekbrand
• 11:32   Re: mysterious difference in speed when combining two queries with OR Theo Kramer
• 12:52   Re: mysterious difference in speed when combining two queries with OR PFC
• 13:31   Re: mysterious difference in speed when combining two queries with OR Gregory Stark
• 16:40   Re: SELECT 'DBD::Pg ping test' Jeffrey Baker

24 April 2008

• 01:15   Optimizer's issue Vlad Arkhipov
• 08:47   Re: Optimizer's issue Albe Laurenz
• 08:56   off-topic: SPAM Albe Laurenz
• 09:47   Re: Optimizer's issue Vlad Arkhipov
• 10:50   Re: Optimizer's issue Matthew Wakeling
• 11:31   Re: off-topic: SPAM Gregory Stark
• 13:59   Question about disk IO an index use and seeking advice Nikolas Everett
• 14:32   Re: Performance of the Materialize operator in a query plan Viktor Rosenfeld
• 15:27   Re: Question about disk IO an index use and seeking advice Matthew Wakeling
• 16:20   Re: Optimizer's issue PFC
• 16:51   Re: Question about disk IO an index use and seeking advice PFC
• 17:00   Re: Performance of the Materialize operator in a query plan PFC
• 18:19   Re: Question about disk IO an index use and seeking advice Nikolas Everett
• 19:57   Re: Question about disk IO an index use and seeking advice PFC

25 April 2008

• 00:06   Planner won't use composite index if there is an order by ???? Dave Cramer
• 00:23   Re: Planner won't use composite index if there is an order by ???? Tom Lane
• 21:25   Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Robert Treat
• 21:33   Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Tom Lane

26 April 2008

• 13:11   Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Robert Treat
• 13:25   Best practice to load a huge table from ORACLE to PG Adonias Malosso
• 14:12   Re: Oddly slow queries Thomas Spreng
• 15:10   Re: Best practice to load a huge table from ORACLE to PG Joshua D. Drake
• 15:17   Re: Best practice to load a huge table from ORACLE to PG Potluri Srikanth
• 15:33   Re: Best practice to load a huge table from ORACLE to PG Joshua D. Drake
• 16:14   Re: Best practice to load a huge table from ORACLE to PG Luke Lonergan
• 17:26   Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Tom Lane
• 18:21   Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Robert Treat
• 18:52   Re: Best practice to load a huge table from ORACLE to PG Craig Ringer
• 23:20   Re: Re: [HACKERS] [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search Tom Lane

27 April 2008

• 01:14   Re: Best practice to load a huge table from ORACLE to PG Jonah H. Harris
• 13:02   Re: Best practice to load a huge table from ORACLE to PG Greg Smith
• 17:54   Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL Josh Berkus
• 19:02   Re: Performance of the Materialize operator in a query plan Viktor Rosenfeld

28 April 2008

• 01:54   Re: Optimizer's issue Vlad Arkhipov
• 02:13   Simple JOIN problem Vlad Arkhipov
• 07:49   Re: Best practice to load a huge table from ORACLE to PG Dimitri Fontaine
• 09:17   Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL Gregory Stark
• 11:00   Re: [pgsql-advocacy] Benchmarks WAS: Sun Talks about MySQL Heikki Linnakangas
• 13:39   Replication Syatem Gauri Kanekar
• 13:58   Re: Replication Syatem Peter Childs
• 14:06   Re: Replication Syatem Gauri Kanekar
• 14:13   Re: Replication Syatem Brad Nicholson
• 14:16   Re: Replication Syatem salman
• 14:17   Re: Replication Syatem Gauri Kanekar
• 14:19   Re: Replication Syatem Gauri Kanekar
• 15:56   Where do a novice do to make it run faster? A B
• 16:07   Re: Benchmarks WAS: Sun Talks about MySQL Josh Berkus
• 16:19   shared_buffer/DRBD performances Gaetano Mendola
• 16:19   Re: Where do a novice do to make it run faster? Claus Guttesen
• 16:23   Re: Replication Syatem Andrew Sullivan
• 16:23   Re: Replication Syatem Andrew Sullivan
• 16:28   Re: Where do a novice do to make it run faster? Dennis Muhlestein
• 16:34   Re: Where do a novice do to make it run faster? Steve Crawford
• 17:28   Re: Where do a novice do to make it run faster? Chris Browne
• 17:31   Very poor performance loading 100M of sql data using copy John Rouillard
• 17:39   Re: Replication Syatem Greg Smith
• 17:53   Re: Very poor performance loading 100M of sql data using copy Heikki Linnakangas
• 18:00   Re: Very poor performance loading 100M of sql data using copy John Rouillard
• 18:16   Re: Very poor performance loading 100M of sql data using copy Greg Smith
• 18:18   Re: Where do a novice do to make it run faster? PFC
• 18:40   Re: Benchmarks WAS: Sun Talks about MySQL Gregory Stark
• 19:50   Re: Very poor performance loading 100M of sql data using copy Shane Ambler
• 19:59   Re: Best practice to load a huge table from ORACLE to PG Tino Wildenhain
• 20:56   Re: Benchmarks WAS: Sun Talks about MySQL Joshua D. Drake
• 20:59   Re: Replication Syatem Radhika S
• 21:33   Postgres Benchmark looking for maintainer PFC
• 21:37   Re: Best practice to load a huge table from ORACLE to PG Adonias Malosso
• 22:28   Re: Replication Syatem Chris Browne

29 April 2008

• 03:31   Re: Best practice to load a huge table from ORACLE to PG Jonah H. Harris
• 04:55   Re: Replication Syatem Gauri Kanekar
• 05:22   Re: Replication Syatem Greg Smith
• 05:22   Re: Replication Syatem Gauri Kanekar
• 05:23   Re: Replication Syatem Tom Lane
• 05:47   Re: Replication Syatem Gauri Kanekar
• 05:47   Re: Replication Syatem Pavan Deolasee
• 05:55   Re: Replication Syatem Pavan Deolasee
• 08:37   Re: Replication Syatem Greg Smith
• 09:09   Re: Where do a novice do to make it run faster? A B
• 11:05   Re: Replication Syatem Gauri Kanekar
• 11:19   Re: Replication Syatem Shane Ambler
• 11:31   Re: Replication Syatem Pavan Deolasee
• 12:14   Vacuum statistics Francisco Reyes
• 12:19   Re: corrupted shared memory message Pablo Alcaraz
• 13:00   Re: Replication Syatem Gauri Kanekar
• 13:03   Re: Replication Syatem Alvaro Herrera
• 13:03   Re: Replication Syatem Alvaro Herrera
• 13:09   Re: Replication Syatem Pavan Deolasee
• 13:12   Re: Replication Syatem Gauri Kanekar
• 13:16   Re: Replication Syatem Pavan Deolasee
• 13:48   Re: Replication Syatem Gregory Stark
• 14:16   Re: Replication Syatem Tom Lane
• 14:21   Re: Where do a novice do to make it run faster? Tom Lane
• 15:01   Re: Replication Syatem Vivek Khera
• 15:04   Re: Very poor performance loading 100M of sql data using copy John Rouillard
• 15:16   Re: Very poor performance loading 100M of sql data using copy John Rouillard
• 15:28   Re: Replication Syatem Chris Browne
• 15:58   Re: Very poor performance loading 100M of sql data using copy Greg Smith
• 16:48   Re: Replication Syatem Shane Ambler
• 18:55   SSD database benchmarks Greg Smith
• 21:00   Re: SSD database benchmarks Guido Neitzer
• 23:26   Re: SSD database benchmarks Greg Smith
• 23:27   Re: SSD database benchmarks Merlin Moncure

30 April 2008

• 05:03   Understanding histograms Len Shapiro
• 05:19   Re: Understanding histograms Tom Lane
• 05:30   Re: Replication Syatem Gauri Kanekar
• 05:37   Re: Replication Syatem Pavan Deolasee
• 05:40   Re: Replication Syatem Gauri Kanekar
• 06:32   Re: Understanding histograms Len Shapiro
• 06:43   Re: Replication Syatem Pavan Deolasee
• 06:49   Re: Replication Syatem Gauri Kanekar
• 07:25   Re: Replication Syatem Pavan Deolasee
• 10:26   Re: Replication Syatem Heikki Linnakangas
• 12:19   Re: Replication Syatem Craig Ringer
• 13:38   Re: Replication Syatem Heikki Linnakangas
• 14:40   Re: Replication Syatem Pavan Deolasee
• 14:43   Re: Understanding histograms Tom Lane
• 14:46   Re: Replication Syatem Tom Lane
• 15:03   Re: Replication Syatem Tom Lane
• 15:56   Postgres replication Gernot Schwed
• 16:15   Re: Replication Syatem Pavan Deolasee
• 16:47   Re: Replication Syatem Gauri Kanekar
• 20:45   Re: Postgres replication david@lang.hm
• 22:54   Re: Understanding histograms Jeff Davis
• 23:20   Re: Understanding histograms Tom Lane