Mailing lists [pgsql-performance]

1 May 2011

• 00:13   Re: stored proc and inserting hundreds of thousands of rows Jeff Janes
• 00:58   Re: stored proc and inserting hundreds of thousands of rows Joel Reymont
• 01:06   Re: stored proc and inserting hundreds of thousands of rows Samuel Gendler
• 01:14   Re: stored proc and inserting hundreds of thousands of rows Joel Reymont
• 06:48   The right SHMMAX and FILE_MAX Phoenix Kiula
• 16:18   Re: {Spam} Will shared_buffers crash a server Marti Raudsepp
• 17:19   Re: The right SHMMAX and FILE_MAX Kevin Grittner
• 19:37   Re: The right SHMMAX and FILE_MAX Greg Smith
• 23:30   Re: stored proc and inserting hundreds of thousands of rows Greg Smith

2 May 2011

• 04:53   Re: The right SHMMAX and FILE_MAX Adarsh Sharma
• 07:36   Re: pgpoolAdmin handling several pgpool-II clusters Tatsuo Ishii
• 07:36   Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? Hsien-Wen Chu
• 07:36   Re: FUSION-IO io cards Justin Pitts
• 07:36   Query improvement Mark
• 07:58   Re: Query improvement Claudio Freire
• 09:07   Re: The right SHMMAX and FILE_MAX Mark Kirkwood
• 10:50   Re: The right SHMMAX and FILE_MAX Tomas Vondra
• 11:01   Re: The right SHMMAX and FILE_MAX Adarsh Sharma
• 13:46   Re: 8.4.7, incorrect estimate Wayne Conrad
• 15:15   Re: 8.4.7, incorrect estimate Tom Lane
• 15:18   Re: The right SHMMAX and FILE_MAX Greg Smith
• 16:26   Re: 8.4.7, incorrect estimate Kevin Grittner
• 16:31   Re: 8.4.7, incorrect estimate Wayne Conrad

3 May 2011

• 06:44   Re: Query improvement Mark
• 06:44   Re: pgpoolAdmin handling several pgpool-II clusters Jorgen
• 07:22   Re: Query improvement Claudio Freire
• 07:29   Re: pgpoolAdmin handling several pgpool-II clusters Magnus Hagander
• 09:03   Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Sethu Prasad
• 09:14   Re: Query improvement Marc Mamin
• 15:17   Re: pgpoolAdmin handling several pgpool-II clusters Jorgen
• 15:53   [PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos
• 18:48   amazon ec2 Joel Reymont
• 19:41   Re: amazon ec2 Alan Hodgson
• 19:43   Re: amazon ec2 Joel Reymont
• 20:10   Re: amazon ec2 Alan Hodgson
• 20:52   Re: amazon ec2 Greg Spiegelberg
• 20:56   Re: amazon ec2 Mark Rostron
• 20:58   Re: amazon ec2 david@lang.hm
• 21:39   Re: amazon ec2 Josh Berkus
• 22:57   Re: amazon ec2 Greg Smith
• 22:57   Re: amazon ec2 Greg Smith

4 May 2011

• 04:43   Re: [PERFORMANCE] expanding to SAN: which portion best to move Jesper Krogh
• 05:23   Re: Order of tables Rishabh Kumar Jain
• 05:25   Re: [PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos
• 05:26   Re: Order of tables Rishabh Kumar Jain
• 05:29   Re: Order of tables Rishabh Kumar Jain
• 05:31   Re: Order of tables Rishabh Kumar Jain
• 05:33   Re: [PERFORMANCE] expanding to SAN: which portion best to move Jesper Krogh
• 10:31   Re: [PERFORMANCE] expanding to SAN: which portion best to move Willy-Bas Loos
• 13:05   Re: amazon ec2 Jim Nasby
• 13:28   Re: REINDEX takes half a day (and still not complete!) Jim Nasby
• 13:41   row estimate very wrong for array type Denis de Bernardy
• 14:04   Re: amazon ec2 Shaun Thomas
• 14:13   Re: row estimate very wrong for array type Tom Lane
• 14:43   Re: row estimate very wrong for array type Denis de Bernardy
• 14:57   Re: row estimate very wrong for array type Denis de Bernardy
• 15:40   Re: Shouldn't we have a way to avoid "risky" plans? Jim Nasby
• 18:44   Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Josh Berkus

5 May 2011

• 00:03   Re: amazon ec2 Josh Berkus
• 00:12   Re: amazon ec2 david@lang.hm
• 00:23   Re: amazon ec2 Denis de Bernardy
• 01:24   ask the database engine tuning on the server Didik Prasetyo
• 06:04   Explicit joins Rishabh Kumar Jain
• 07:48   Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Sethu Prasad
• 07:49   Re: amazon ec2 Dave Page
• 17:17   Re: Explicit joins Kevin Grittner
• 17:43   Poor query plan chosen in 9.0.3 vs 8.3.7 Brian Connolly
• 17:53   Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? Robert Haas
• 18:08   Re: ask the database engine tuning on the server Kevin Grittner
• 19:55   Re: Poor query plan chosen in 9.0.3 vs 8.3.7 Brian Connolly
• 20:01   Re: Poor query plan chosen in 9.0.3 vs 8.3.7 Bosco Rama
• 20:27   Re: Poor query plan chosen in 9.0.3 vs 8.3.7 Tom Lane

6 May 2011

• 10:53   Re: VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql? Dimitri
• 15:15   Re: REINDEX takes half a day (and still not complete!) Merlin Moncure

8 May 2011

• 09:10   Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Simon Riggs

9 May 2011

• 06:09   Re: Query improvement Mark
• 06:09   indexes ignored when querying the master table Thomas Hägi
• 06:10   Re: Query improvement Mark
• 06:10   Re: Query improvement Mark
• 07:58   Re: indexes ignored when querying the master table Florian Weimer
• 11:43   Re: indexes ignored when querying the master table Greg Smith
• 18:45   wildcard makes seq scan on prod db but not in test Marcus Engene
• 19:08   Re: wildcard makes seq scan on prod db but not in test Tom Lane
• 19:10   Re: wildcard makes seq scan on prod db but not in test Kevin Grittner
• 19:19   Re: wildcard makes seq scan on prod db but not in test Marcus Engene
• 20:20   Re: wildcard makes seq scan on prod db but not in test Kevin Grittner
• 20:34   Benchmarking a large server Chris Hoover
• 20:41   good performance benchmark Merlin Moncure
• 20:51   Re: Benchmarking a large server Merlin Moncure
• 20:59   Re: Benchmarking a large server David Boreham
• 21:00   Re: Benchmarking a large server Ben Chobot
• 21:01   Re: Benchmarking a large server Shaun Thomas
• 21:12   Re: Benchmarking a large server Merlin Moncure
• 21:14   Re: Benchmarking a large server David Boreham
• 21:28   Postgres refusing to use >1 core Aren Cambre
• 21:29   Re: wildcard makes seq scan on prod db but not in test Marcus Engene
• 21:35   Re: Postgres refusing to use >1 core Merlin Moncure
• 21:46   Re: Postgres refusing to use >1 core Kevin Grittner
• 21:51   Re: Postgres refusing to use >1 core Aren Cambre
• 21:53   Re: Postgres refusing to use >1 core Aren Cambre
• 21:56   Re: Postgres refusing to use >1 core Merlin Moncure
• 21:59   Re: Postgres refusing to use >1 core Kevin Grittner
• 22:29   Re: Benchmarking a large server Greg Smith
• 22:44   Re: Postgres refusing to use >1 core Greg Smith
• 23:23   Re: good performance benchmark Josh Berkus
• 23:30   Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Josh Berkus
• 23:52   Re: Benchmarking a large server Cédric Villemain

10 May 2011

• 00:32   Re: Benchmarking a large server Craig James
• 00:39   Re: Benchmarking a large server David Boreham
• 00:46   Re: Benchmarking a large server Greg Smith
• 00:46   Re: Benchmarking a large server david@lang.hm
• 02:13   Re: Postgres refusing to use >1 core Aren Cambre
• 02:15   Re: Postgres refusing to use >1 core Aren Cambre
• 02:36   Re: Postgres refusing to use >1 core Scott Marlowe
• 02:39   Re: Postgres refusing to use >1 core Merlin Moncure
• 02:42   Re: Postgres refusing to use >1 core Aren Cambre
• 03:14   Re: Benchmarking a large server Shaun Thomas
• 04:02   Re: Postgres refusing to use >1 core Craig Ringer
• 04:32   partition query on multiple cores Didik Prasetyo
• 04:44   Re: Benchmarking a large server Greg Smith
• 06:59   Re: Benchmarking a large server Yeb Havinga
• 07:01   8.2.13 commit is taking too much time AI Rumman
• 07:23   Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Sethu Prasad
• 07:24   Re: Benchmarking a large server Claudio Freire
• 09:20   Re: indexes ignored when querying the master table Thomas Hägi
• 09:45   Re: 8.2.13 commit is taking too much time tv@fuzzy.cz
• 14:06   Re: Postgres refusing to use >1 core Merlin Moncure
• 14:25   Re: Benchmarking a large server Jeff
• 15:20   Re: Benchmarking a large server Cédric Villemain
• 15:56   Re: 8.2.13 commit is taking too much time Greg Smith
• 16:13   Re: partition query on multiple cores Maciek Sakrejda
• 16:22   Re: partition query on multiple cores Shaun Thomas
• 17:29   Question processor speed differences. Tory M Blue
• 17:38   Re: help speeding up a query in postgres 8.4.5 Robert Haas
• 17:51   Re: Benchmarking a large server Greg Smith
• 17:59   Re: help speeding up a query in postgres 8.4.5 Robert Haas
• 18:58   Re: partition query on multiple cores Tomas Vondra
• 20:42   Postgres NoSQL emulation Pierre C
• 20:53   Re: Question processor speed differences. Greg Smith
• 21:32   Re: Postgres NoSQL emulation Merlin Moncure

11 May 2011

• 01:32   Re: Postgres refusing to use >1 core Craig Ringer
• 01:35   Re: Postgres refusing to use >1 core Craig Ringer
• 03:13   Re: Postgres NoSQL emulation Scott Marlowe
• 04:27   Re: Postgres refusing to use >1 core Scott Marlowe
• 05:56   Re: help speeding up a query in postgres 8.4.5 Maria L. Wilson
• 05:56   Re: help speeding up a query in postgres 8.4.5 Maria L. Wilson
• 07:09   Re: help speeding up a query in postgres 8.4.5 Scott Marlowe
• 11:07   Re: Postgres refusing to use >1 core Pierre C
• 11:18   'Interesting' prepared statement slowdown on large table join Prodan, Andrei
• 11:41   Re: Postgres NoSQL emulation Pierre C
• 11:57   Re: partition query on multiple cores Mason S
• 12:01   Re: help speeding up a query in postgres 8.4.5 Robert Haas
• 12:05   Re: partition query on multiple cores Mason S
• 14:31   Re: help speeding up a query in postgres 8.4.5 Tom Lane
• 15:55   Re: 'Interesting' prepared statement slowdown on large table join Shaun Thomas
• 16:04   Re: Postgres refusing to use >1 core Shaun Thomas
• 16:38   Re: 'Interesting' prepared statement slowdown on large table join Tom Lane
• 16:39   Re: Poor performance when joining against inherited tables Robert Haas
• 17:00   Re: Poor performance when joining against inherited tables Tom Lane
• 18:12   Re: Postgres refusing to use >1 core Pierre C
• 19:07   Re: 'Interesting' prepared statement slowdown on large table join Jeff Janes
• 19:53   Re: Postgres refusing to use >1 core 
• 21:44   Re: Postgres refusing to use >1 core Scott Marlowe
• 22:05   Re: Postgres refusing to use >1 core Shaun Thomas
• 23:08   Re: Postgres refusing to use >1 core 

12 May 2011

• 01:14   Re: Postgres refusing to use >1 core Josh Berkus
• 03:17   Re: Postgres refusing to use >1 core Aren Cambre
• 03:18   Re: Postgres refusing to use >1 core Aren Cambre
• 03:21   Re: Postgres refusing to use >1 core Aren Cambre
• 03:21   Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Robert Haas
• 03:22   Re: DBT-5 & Postgres 9.0.3 Robert Haas
• 03:35   Re: Postgres refusing to use >1 core Scott Marlowe
• 03:36   Re: Checkpoint execution overrun impact? Robert Haas
• 03:38   Re: tuning on ec2 Robert Haas
• 04:26   Re: Postgres refusing to use >1 core David Boreham
• 07:18   Re: DBT-5 & Postgres 9.0.3 Sethu Prasad
• 07:28   Re: Postgres refusing to use >1 core Vitalii Tymchyshyn
• 08:31   Re: Postgres refusing to use >1 core Michael Graham
• 13:06   Re: Postgres refusing to use >1 core Shaun Thomas
• 14:51   Re: Postgres refusing to use >1 core Tom Lane
• 15:39   since when has pg_stat_user_indexes.idx_scan been counting? Willy-Bas Loos
• 15:49   Re: Postgres refusing to use >1 core Shaun Thomas
• 18:15   Re: Postgres refusing to use >1 core Eric McKeeth
• 18:18   Re: since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra
• 18:19   Re: since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra
• 18:26   Re: Postgres refusing to use >1 core Aren Cambre
• 18:28   Re: Postgres refusing to use >1 core Aren Cambre
• 19:11   Re: Postgres refusing to use >1 core Tom Lane
• 19:20   Re: Postgres refusing to use >1 core Shaun Thomas
• 19:21   Re: 'Interesting' prepared statement slowdown on large table join Prodan, Andrei
• 20:03   Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? Willy-Bas Loos
• 20:07   Re: since when has pg_stat_user_indexes.idx_scan been counting? Greg Smith
• 20:16   Re: since when has pg_stat_user_indexes.idx_scan been counting? Tom Lane
• 20:34   Re: Poor performance when joining against inherited tables Lucas Madar
• 20:34   Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? raghu ram
• 20:46   Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? Tomas Vondra
• 21:31   Re: Poor performance when joining against inherited tables Maciek Sakrejda
• 23:10   setting configuration values inside a stored proc Samuel Gendler
• 23:28   Re: 'Interesting' prepared statement slowdown on large table join Jeff Janes

13 May 2011

• 00:10   Re: tuning on ec2 Josh Berkus
• 02:10   Re: Checkpoint execution overrun impact? Greg Smith
• 02:26   Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? Greg Smith
• 08:28   Re: setting configuration values inside a stored proc Andres Freund
• 08:44   Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting? tv@fuzzy.cz
• 09:42   Re: setting configuration values inside a stored proc Samuel Gendler
• 12:02   How to avoid seq scans for joins between union-all views (test case included) Fredrik Widlert
• 14:23   Re: How to avoid seq scans for joins between union-all views (test case included) Denis de Bernardy
• 14:49   Re: How to avoid seq scans for joins between union-all views (test case included) Cédric Villemain
• 15:09   Re: How to avoid seq scans for joins between union-all views (test case included) Fredrik Widlert
• 15:54   Link error when use Pgtypes function in windows Fanbin Meng
• 16:22   Re: Link error when use Pgtypes function in windows Maciek Sakrejda
• 17:44   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 17:55   Re: reducing random_page_cost from 4 to 2 to force index scan Kevin Grittner
• 19:15   Re: [PERFORMANCE] expanding to SAN: which portion best to move Robert Haas
• 19:20   Re: reducing random_page_cost from 4 to 2 to force index scan Tom Lane
• 20:04   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 20:13   Re: reducing random_page_cost from 4 to 2 to force index scan Josh Berkus
• 20:51   Re: reducing random_page_cost from 4 to 2 to force index scan Cédric Villemain
• 21:09   Using pgiosim realistically John Rouillard

14 May 2011

• 02:20   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 02:28   Re: Query improvement Robert Haas
• 10:10   KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Stefan Keller
• 17:16   Re: Using pgiosim realistically ktm@rice.edu

15 May 2011

• 04:20   Re: reducing random_page_cost from 4 to 2 to force index scan Stuart Bishop
• 18:08   Re: reducing random_page_cost from 4 to 2 to force index scan Josh Berkus
• 18:20   Re: reducing random_page_cost from 4 to 2 to force index scan Josh Berkus
• 20:32   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 20:34   Re: Postgres 9.0.4 + Hot Standby + FusionIO Drive + Performance => Query failed ERROR: catalog is missing 1 attribute(s) for relid 172226 Robert Haas
• 21:14   Re: DBT-5 & Postgres 9.0.3 Robert Haas
• 21:46   Re: reducing random_page_cost from 4 to 2 to force index scan Cédric Villemain
• 22:02   slow loop inserts? Ezequiel Lovelle
• 22:27   Re: slow loop inserts? Dan Birken

16 May 2011

• 00:25   Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Craig Ringer
• 01:05   Re: reducing random_page_cost from 4 to 2 to force index scan Craig Ringer
• 01:18   Re: reducing random_page_cost from 4 to 2 to force index scan Greg Smith
• 04:42   Re: reducing random_page_cost from 4 to 2 to force index scan Jesper Krogh
• 04:49   Re: reducing random_page_cost from 4 to 2 to force index scan Jesper Krogh
• 05:39   Why query takes soo much time Adarsh Sharma
• 08:19   Re: [PERFORMANCE] expanding to SAN: which portion best to move Robert Klemme
• 10:00   Re: Why query takes soo much time Craig Ringer
• 11:16   Re: Why query takes soo much time Denis de Bernardy
• 13:17   Re: Using pgiosim realistically John Rouillard
• 13:47   Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Merlin Moncure
• 14:16   Re: Why query takes soo much time Tom Lane
• 14:32   Re: [PERFORMANCE] expanding to SAN: which portion best to move Robert Haas
• 14:34   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 15:46   Re: reducing random_page_cost from 4 to 2 to force index scan Tom Lane
• 16:23   Re: Using pgiosim realistically Jeff
• 16:45   Re: reducing random_page_cost from 4 to 2 to force index scan Jeff Janes
• 17:06   Re: Using pgiosim realistically John Rouillard
• 17:25   Re: reducing random_page_cost from 4 to 2 to force index scan Tom Lane
• 17:54   Re: Using pgiosim realistically Jeff
• 19:11   Re: reducing random_page_cost from 4 to 2 to force index scan Nathan Boley
• 19:41   Re: reducing random_page_cost from 4 to 2 to force index scan Tom Lane
• 22:30   hash semi join caused by "IN (select ...)" Clemens Eisserer
• 23:22   Re: hash semi join caused by "IN (select ...)" Tom Lane

17 May 2011

• 02:44   Re: hash semi join caused by "IN (select ...)" Dave Johansen
• 07:00   Re: [PERFORMANCE] expanding to SAN: which portion best to move Robert Klemme
• 07:39   Re: hash semi join caused by "IN (select ...)" Clemens Eisserer
• 09:47   Re: [PERFORMANCE] expanding to SAN: which portion best to move Craig Ringer
• 10:13   Re: [PERFORMANCE] expanding to SAN: which portion best to move Cédric Villemain
• 13:00   Fill Factor Anibal David Acosta
• 13:23   Re: Fill Factor Scott Marlowe
• 13:29   Re: [PERFORMANCE] expanding to SAN: which portion best to move Robert Klemme
• 13:53   Re: Fill Factor Cédric Villemain
• 17:35   Re: Using pgiosim realistically John Rouillard
• 19:19   Re: reducing random_page_cost from 4 to 2 to force index scan Jim Nasby
• 19:31   Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Jim Nasby
• 22:07   Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Stefan Keller

18 May 2011

• 08:46   Re: hash semi join caused by "IN (select ...)" Clemens Eisserer
• 14:01   Re: hash semi join caused by "IN (select ...)" Dave Johansen
• 15:26   LIMIT and UNION ALL Dave Johansen
• 16:00   Re: LIMIT and UNION ALL Robert Klemme
• 16:00   Re: LIMIT and UNION ALL Pavel Stehule
• 17:51   Re: hash semi join caused by "IN (select ...)" Scott Carey

19 May 2011

• 03:00   Re: reducing random_page_cost from 4 to 2 to force index scan Greg Smith
• 14:53   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 18:40   Re: reducing random_page_cost from 4 to 2 to force index scan Jim Nasby
• 20:07   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 20:10   Re: Link error when use Pgtypes function in windows Robert Haas
• 21:26   SORT performance - slow? Strange, John W
• 21:41   Re: SORT performance - slow? Samuel Gendler
• 22:28   Re: reducing random_page_cost from 4 to 2 to force index scan Cédric Villemain

20 May 2011

• 03:52   Re: SORT performance - slow? Kevin Grittner

21 May 2011

• 22:23   Pushing LIMIT into sub-queries of a UNION ALL Dave Johansen
• 22:23   Performance degradation of inserts when database size grows Andrey Vorobiev
• 22:23   Pushing LIMIT into sub-queries of a UNION ALL? Dave Johansen
• 22:23   Re: Modifying shared_buffers causes despite plenty of ram STA
• 22:23   Modifying shared_buffers causes despite plenty of ram STA
• 22:23   Re: Modifying shared_buffers causes despite plenty of ram STA
• 22:23   FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) 
• 22:23   [OT]: Confidentiality disclosures in list posts (Was: SORT performance - slow?) Lew

22 May 2011

• 03:32   Re: Postgres refusing to use >1 core Aren Cambre
• 06:38   Re: Performance degradation of inserts when database size grows Leonardo Francalanci
• 14:08   Re: Postgres refusing to use >1 core Aren Cambre
• 17:34   Re: Pushing LIMIT into sub-queries of a UNION ALL? Robert Klemme
• 23:11   Re: SORT performance - slow? Tomas Vondra

23 May 2011

• 04:10   Re: Postgres refusing to use >1 core Aren Cambre
• 05:23   Re: Postgres refusing to use >1 core Craig Ringer
• 11:00   Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Pierre C
• 13:26   Re: [OT]: Confidentiality disclosures in list posts (Was: SORT performance - slow?) Shaun Thomas
• 13:30   Re: Performance degradation of inserts when database size grows Shaun Thomas
• 14:07   Re: Postgres refusing to use >1 core Aren Cambre
• 15:55   Re: Pushing LIMIT into sub-queries of a UNION ALL? Dave Johansen
• 17:08   Re: SORT performance - slow? Maciek Sakrejda
• 17:19   Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Robert Haas
• 17:21   Re: Pushing LIMIT into sub-queries of a UNION ALL Robert Haas
• 17:27   Re: SORT performance - slow? Robert Haas
• 17:57   Re: SORT performance - slow? Tomas Vondra
• 18:36   Logfile Nick Raj
• 18:49   Re: Performance degradation of inserts when database size grows Tomas Vondra
• 19:05   Re: Performance degradation of inserts when database size grows Robert Haas
• 19:08   Re: reducing random_page_cost from 4 to 2 to force index scan Josh Berkus
• 19:08   Re: Performance degradation of inserts when database size grows Robert Haas
• 19:21   Re: Performance degradation of inserts when database size grows Tomas Vondra
• 19:47   Re: Pushing LIMIT into sub-queries of a UNION ALL? Robert Klemme
• 21:31   Re: Pushing LIMIT into sub-queries of a UNION ALL? Josh Berkus
• 21:38   postgres not use index, IN statement Anibal David Acosta
• 22:16   "error with invalid page header" while vacuuming pgbench data John Rouillard
• 22:21   Re: "error with invalid page header" while vacuuming pgbench data Kevin Grittner
• 23:27   Re: postgres not use index, IN statement Craig Ringer

24 May 2011

• 02:44   Re: reducing random_page_cost from 4 to 2 to force index scan Robert Haas
• 04:14   Hash Anti Join performance degradation panam
• 05:24   Re: Performance degradation of inserts when database size grows Terry Schmitt
• 05:53   Re: Hash Anti Join performance degradation Craig Ringer
• 09:12   Re: reducing random_page_cost from 4 to 2 to force index scan Vitalii Tymchyshyn
• 11:17   Re: Hash Anti Join performance degradation Cédric Villemain
• 14:35   Re: Hash Anti Join performance degradation panam
• 18:49   Re: [PERFORMANCE] expanding to SAN: which portion best to move Greg Smith
• 19:21   Re: Performance degradation of inserts when database size grows Tomas Vondra
• 20:38   Re: Hash Anti Join performance degradation Tom Lane
• 21:46   Re: Performance degradation of inserts when database size grows Greg Smith
• 23:45   Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Stefan Keller

25 May 2011

• 01:53   Re: Hash Anti Join performance degradation Craig Ringer
• 02:01   Re: Performance degradation of inserts when database size grows Santhakumaran
• 07:34   serveRAID M5014 SAS Grzegorz Jaśkiewicz
• 08:52   Re: [PERFORMANCE] expanding to SAN: which portion best to move Vitalii Tymchyshyn
• 14:00   Re: serveRAID M5014 SAS Greg Smith
• 15:52   Re: serveRAID M5014 SAS Kevin Grittner
• 17:00   Re: Hash Anti Join performance degradation panam
• 17:05   Speeding up loops in pl/pgsql function Reuven M. Lerner
• 17:41   Re: Hash Anti Join performance degradation Kevin Grittner
• 17:41   Re: "error with invalid page header" while vacuuming pgbench data John Rouillard
• 18:00   Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Pierre C
• 18:55   Re: Speeding up loops in pl/pgsql function Reuven M. Lerner
• 18:56   Re: Speeding up loops in pl/pgsql function Alex Hunsaker
• 19:30   Re: Speeding up loops in pl/pgsql function Pavel Stehule
• 19:42   Re: Speeding up loops in pl/pgsql function Alex Hunsaker
• 20:20   Re: "error with invalid page header" while vacuuming pgbench data Kevin Grittner
• 20:46   Re: "error with invalid page header" while vacuuming pgbench data Greg Smith
• 21:09   Re: Speeding up loops in pl/pgsql function Merlin Moncure
• 22:07   Re: "error with invalid page header" while vacuuming pgbench data John Rouillard
• 22:09   Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Merlin Moncure
• 22:25   Re: "error with invalid page header" while vacuuming pgbench data Scott Marlowe
• 22:26   Re: Speeding up loops in pl/pgsql function Reuven M. Lerner
• 22:33   Re: serveRAID M5014 SAS Mark Kirkwood
• 22:42   Re: serveRAID M5014 SAS Mark Kirkwood
• 23:03   Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Stefan Keller

26 May 2011

• 00:03   Re: Speeding up loops in pl/pgsql function Steve Crawford
• 01:20   Re: Speeding up loops in pl/pgsql function Merlin Moncure
• 02:48   Re: Hash Anti Join performance degradation Craig Ringer
• 03:18   Re: "error with invalid page header" while vacuuming pgbench data Craig Ringer
• 04:01   Re: Speeding up loops in pl/pgsql function Santhakumaran
• 08:17   Re: serveRAID M5014 SAS Grzegorz Jaśkiewicz
• 08:25   Re: serveRAID M5014 SAS Mark Kirkwood
• 08:38   Re: serveRAID M5014 SAS Grzegorz Jaśkiewicz
• 09:07   Re: Speeding up loops in pl/pgsql function Jochen Erwied
• 09:31   Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation) Pierre C
• 12:11   Re: Speeding up loops in pl/pgsql function Merlin Moncure
• 12:33   Re: Hash Anti Join performance degradation panam
• 12:36   Re: Speeding up loops in pl/pgsql function Merlin Moncure
• 12:49   Re: Speeding up loops in pl/pgsql function Reuven M. Lerner
• 14:21   Re: Hash Anti Join performance degradation Cédric Villemain
• 14:32   The shared buffers challenge Merlin Moncure
• 14:48   Re: Hash Anti Join performance degradation Kevin Grittner
• 15:10   Re: The shared buffers challenge Kevin Grittner
• 15:25   Re: Speeding up loops in pl/pgsql function Steve Crawford
• 15:36   Re: The shared buffers challenge Merlin Moncure
• 15:45   Re: The shared buffers challenge Claudio Freire
• 16:02   Re: The shared buffers challenge Merlin Moncure
• 16:08   Re: Hash Anti Join performance degradation panam
• 16:38   Re: The shared buffers challenge Claudio Freire
• 16:46   Re: The shared buffers challenge Merlin Moncure
• 16:46   Re: LIMIT and UNION ALL Dave Johansen
• 17:00   Re: LIMIT and UNION ALL Tom Lane
• 17:08   Re: Hash Anti Join performance degradation Kevin Grittner
• 17:45   Re: The shared buffers challenge Kevin Grittner
• 18:04   Re: Hash Anti Join performance degradation panam
• 18:13   Re: Hash Anti Join performance degradation Cédric Villemain
• 22:35   Performance block size. Tory M Blue
• 22:43   Re: serveRAID M5014 SAS Mark Kirkwood
• 23:10   Re: The shared buffers challenge Greg Smith
• 23:19   Re: serveRAID M5014 SAS Greg Smith
• 23:23   Re: serveRAID M5014 SAS Mark Kirkwood
• 23:43   Re: serveRAID M5014 SAS Mark Kirkwood
• 23:47   Re: The shared buffers challenge Samuel Gendler

27 May 2011

• 00:01   Re: Hash Anti Join performance degradation Craig Ringer
• 01:58   Is any effect other process performance after vaccumdb finished ? Junghwe Kim
• 03:32   Re: Is any effect other process performance after vaccumdb finished ? Craig Ringer
• 11:09   Re: Performance block size. Ivan Voras
• 14:38   Re: serveRAID M5014 SAS Kevin Grittner
• 15:23   Re: The shared buffers challenge Merlin Moncure
• 16:54   Re: The shared buffers challenge Scott Carey
• 17:07   Re: The shared buffers challenge Kevin Grittner
• 18:26   Re: The shared buffers challenge Greg Smith
• 18:48   Re: The shared buffers challenge Greg Smith
• 18:57   Re: The shared buffers challenge Merlin Moncure
• 19:04   Re: The shared buffers challenge Robert Haas
• 19:31   Re: The shared buffers challenge Maciek Sakrejda
• 22:12   Re: The shared buffers challenge Claudio Freire
• 23:24   Re: serveRAID M5014 SAS Mark Kirkwood
• 23:30   Re: The shared buffers challenge Mark Kirkwood

28 May 2011

• 00:26   Re: The shared buffers challenge Jeff Davis
• 09:43   Re: serveRAID M5014 SAS Grzegorz Jaśkiewicz
• 10:15   Re: serveRAID M5014 SAS Mark Kirkwood
• 21:47   Re: The shared buffers challenge Greg Smith

31 May 2011

• 00:08   Delete performance Jarrod Chesney
• 09:27   Re: Delete performance Grzegorz Jaśkiewicz
• 14:34   Re: The shared buffers challenge Merlin Moncure
• 15:33   Strange behavior of child table. Jenish
• 15:52   picking a filesystem Robert Haas
• 17:55   Re: picking a filesystem Shaun Thomas
• 18:11   Re: picking a filesystem Samuel Gendler
• 22:15   Re: Hash Anti Join performance degradation Robert Haas
• 23:12   Re: Delete performance Pierre C