Mailing lists [pgsql-performance]

2 September 2010

• 05:54   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 13:14   Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane

3 September 2010

• 05:04   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 05:08   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 14:15   Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane
• 14:15   Odd estimation issue with user-defined type Florian Weimer
• 15:14   Re: Odd estimation issue with user-defined type Tom Lane
• 15:28   Re: Odd estimation issue with user-defined type Florian Weimer
• 16:40   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 16:45   Question about LEFT JOIN and query plan Kaloyan Iliev Iliev
• 16:47   Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane
• 16:57   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 17:15   Re: Question about LEFT JOIN and query plan Tom Lane
• 17:17   Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane
• 17:17   Re: Question about LEFT JOIN and query plan Kevin Grittner
• 17:57   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 18:09   Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane
• 18:27   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 18:44   Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane
• 19:35   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 21:11   Re: Major performance problem after upgrade from 8.3 to 8.4 Tom Lane

4 September 2010

• 06:59   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger

7 September 2010

• 07:19   Re: Question about LEFT JOIN and query plan Kaloyan Iliev Iliev
• 13:13   Re: Question about LEFT JOIN and query plan Kaloyan Iliev Iliev
• 13:28   Re: Question about LEFT JOIN and query plan Kaloyan Iliev Iliev
• 14:30   Re: Question about LEFT JOIN and query plan Kevin Grittner
• 16:55   Re: Question about LEFT JOIN and query plan Kevin Grittner

8 September 2010

• 17:46   pgbench could not send data to client: Broken pipe David Kerr
• 19:10   Re: pgbench could not send data to client: Broken pipe Tom Lane
• 19:27   Re: pgbench could not send data to client: Broken pipe Greg Smith
• 19:44   Re: pgbench could not send data to client: Broken pipe Tom Lane
• 19:57   Re: pgbench could not send data to client: Broken pipe David Kerr
• 19:58   Re: pgbench could not send data to client: Broken pipe David Kerr
• 20:35   Re: pgbench could not send data to client: Broken pipe Tom Lane
• 20:44   Re: pgbench could not send data to client: Broken pipe David Kerr
• 20:56   Re: pgbench could not send data to client: Broken pipe Kevin Grittner
• 21:21   Re: pgbench could not send data to client: Broken pipe David Kerr
• 21:51   Re: pgbench could not send data to client: Broken pipe Kevin Grittner
• 22:00   Re: pgbench could not send data to client: Broken pipe David Kerr
• 22:27   Re: pgbench could not send data to client: Broken pipe Kevin Grittner
• 22:30   Re: pgbench could not send data to client: Broken pipe David Kerr

9 September 2010

• 14:38   Re: pgbench could not send data to client: Broken pipe Alvaro Herrera
• 15:12   Re: pgbench could not send data to client: Broken pipe David Kerr
• 16:05   Re: pgbench could not send data to client: Broken pipe Greg Smith
• 17:24   Re: pgbench could not send data to client: Broken pipe Kevin Grittner
• 18:07   Re: pgbench could not send data to client: Broken pipe Greg Smith

11 September 2010

• 00:46   Slow SQL lookup due to every field being listed in SORT KEY Mason Harding
• 01:59   Re: Slow SQL lookup due to every field being listed in SORT KEY Stephen Frost
• 02:00   Re: Slow SQL lookup due to every field being listed in SORT KEY Tom Lane
• 02:03   Re: Slow SQL lookup due to every field being listed in SORT KEY Stephen Frost

13 September 2010

• 05:49   Problem with mergejoin performance 
• 06:40   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 09:54   Useless sort by Gaetano Mendola
• 14:26   Re: Problem with mergejoin performance Tom Lane
• 14:45   Re: Useless sort by Tom Lane
• 15:16   Re: Problem with mergejoin performance Tom Lane
• 16:24   Re: Useless sort by Gaetano Mendola
• 16:48   Re: Useless sort by Tom Lane
• 17:09   Re: Useless sort by Gaetano Mendola
• 18:34   Re: Major performance problem after upgrade from 8.3 to 8.4 Merlin Moncure
• 19:02   Re: Useless sort by Maciek Sakrejda
• 19:08   Re: Useless sort by Scott Marlowe
• 23:06   Where does data in pg_stat_user_tables come from? Josh Berkus
• 23:42   Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake
• 23:48   Re: Where does data in pg_stat_user_tables come from? Josh Berkus

14 September 2010

• 00:12   Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake
• 00:54   Re: Where does data in pg_stat_user_tables come from? Josh Berkus
• 01:41   Re: Where does data in pg_stat_user_tables come from? Tom Lane
• 03:57   Re: Where does data in pg_stat_user_tables come from? Alvaro Herrera
• 06:09   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 06:41   Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake
• 07:10   Re: Useless sort by Heikki Linnakangas
• 07:12   Re: Where does data in pg_stat_user_tables come from? Joshua D. Drake
• 12:02   Re: Major performance problem after upgrade from 8.3 to 8.4 Merlin Moncure
• 15:09   Re: Useless sort by Maciek Sakrejda
• 16:10   Held idle connections vs use of a Pooler mark
• 16:15   Re: Useless sort by Dave Crooke
• 17:03   Re: Held idle connections vs use of a Pooler Merlin Moncure
• 17:03   Re: Held idle connections vs use of a Pooler Joshua D. Drake
• 17:10   Re: Useless sort by Gaetano Mendola
• 17:14   Re: Held idle connections vs use of a Pooler Craig James
• 20:00   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 21:05   Re: Major performance problem after upgrade from 8.3 to 8.4 Merlin Moncure
• 23:58   Re: Held idle connections vs use of a Pooler Joshua D. Drake

15 September 2010

• 06:32   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 10:09   locking issue on simple selects? Tobias Brox
• 11:31   POSTGRES error 
• 11:53   Re: Major performance problem after upgrade from 8.3 to 8.4 Merlin Moncure
• 13:40   Re: POSTGRES error Kevin Grittner
• 13:43   Re: locking issue on simple selects? Tom Lane
• 18:43   Re: Major performance problem after upgrade from 8.3 to 8.4 Gerhard Wiesinger
• 18:48   Re: Slow SQL lookup due to every field being listed in SORT KEY Mason Harding
• 18:48   Performance problem with joined aggregate query Anssi Kääriäinen
• 19:09   Re: locking issue on simple selects? Tobias Brox
• 19:21   Re: locking issue on simple selects? Tom Lane
• 19:28   Re: locking issue on simple selects? Greg Smith
• 19:33   Re: locking issue on simple selects? Brad Nicholson
• 21:10   Re: turn off caching for performance test Merlin Moncure
• 21:33   Re: locking issue on simple selects? Tobias Brox
• 22:37   Re: Performance problem with joined aggregate query Merlin Moncure

16 September 2010

• 00:32   Re: locking issue on simple selects? Greg Smith
• 08:31   Is disableing nested_loops a bad idea ? Franck Routier
• 10:03   Re: Is disableing nested_loops a bad idea ? Samuel Gendler
• 13:50   Re: Is disableing nested_loops a bad idea ? Kevin Grittner
• 14:13   Re: Is disableing nested_loops a bad idea ? Franck Routier
• 14:24   Problem with mergejoin performance (some bug?) 
• 14:24   Re: Performance problem with joined aggregate query Anssi Kääriäinen
• 14:25   Re: Is disableing nested_loops a bad idea ? Kevin Grittner
• 14:53   Re: Performance problem with joined aggregate query Merlin Moncure
• 18:39   Re: Where does data in pg_stat_user_tables come from? Josh Berkus
• 19:02   Re: Where does data in pg_stat_user_tables come from? Guillaume Lelarge
• 19:15   Re: Where does data in pg_stat_user_tables come from? Tom Lane
• 19:34   Re: Where does data in pg_stat_user_tables come from? Josh Berkus

18 September 2010

• 07:50   3ware trivia overload Greg Smith

20 September 2010

• 11:59   Performance degradation, index bloat and planner estimates Daniele Varrazzo
• 17:25   cleanup on pg_ system tables? mark
• 18:48   Need PostgreSQL data warehousing user, on the record Josh Berkus
• 19:24   Re: cleanup on pg_ system tables? Josh Kupershmidt
• 22:03   Re: 3ware trivia overload George Sexton
• 22:10   Re: 3ware trivia overload David Rees
• 22:12   Auto ANALYZE criteria Joe Miller
• 22:29   Re: Auto ANALYZE criteria Kevin Grittner

21 September 2010

• 02:12   Re: Auto ANALYZE criteria Tom Lane
• 04:20   Memory speed testing Greg Smith
• 15:42   Re: Auto ANALYZE criteria Joe Miller
• 15:42   Re: Auto ANALYZE criteria Joe Miller
• 17:39   Query much faster with enable_seqscan=0 Ogden
• 18:15   Re: Query much faster with enable_seqscan=0 Kenneth Marshall
• 18:22   Re: Query much faster with enable_seqscan=0 Ogden
• 18:51   Re: Query much faster with enable_seqscan=0 Jesper Krogh
• 19:02   Re: Query much faster with enable_seqscan=0 Ogden
• 19:07   Re: Query much faster with enable_seqscan=0 Joshua D. Drake
• 19:17   Re: Query much faster with enable_seqscan=0 Greg Smith
• 19:28   Re: GPU Accelerated Sorting Robert Haas
• 19:34   Re: Query much faster with enable_seqscan=0 Ogden
• 19:35   Re: Using Between Robert Haas
• 19:39   Re: slow DDL creation Robert Haas
• 20:14   Re: Using Between Ozer, Pam
• 20:44   Re: Auto ANALYZE criteria Tom Lane
• 23:25   Re: Query much faster with enable_seqscan=0 Tom Lane
• 23:30   Re: Query much faster with enable_seqscan=0 Tom Lane

22 September 2010

• 02:07   Re: Query much faster with enable_seqscan=0 Joshua D. Drake
• 04:10   Re: Performance degradation, index bloat and planner estimates Craig Ringer
• 04:20   Re: Performance degradation, index bloat and planner estimates Tom Lane
• 10:52   Re: Using Between Robert Haas
• 13:36   Re: Query much faster with enable_seqscan=0 Ogden
• 15:19   Re: Using Between Ozer, Pam
• 16:27   Re: Using Between Robert Haas
• 16:28   Re: Using Between Ozer, Pam

23 September 2010

• 00:54   Re: Useless sort by Robert Haas
• 03:05   Re: Useless sort by 
• 04:01   Re: Useless sort by Greg Smith
• 04:18   Re: Useless sort by Scott Marlowe
• 04:46   Re: Useless sort by Robert Haas
• 12:29   Re: Using Between mark
• 13:51   Re: Useless sort by 
• 14:26   how to enforce index sub-select over filter+seqscan Dmitry Teslenko
• 15:43   Re: how to enforce index sub-select over filter+seqscan Kevin Grittner
• 17:11   Re: Useless sort by Scott Marlowe
• 19:41   Re: how to enforce index sub-select over filter+seqscan Merlin Moncure
• 20:47   Re: locking issue on simple selects? Tobias Brox
• 20:56   Re: locking issue on simple selects? Kevin Grittner
• 21:51   Memory usage - indexes Tobias Brox
• 22:13   Re: Memory usage - indexes Mark Kirkwood
• 22:26   Re: locking issue on simple selects? Tobias Brox
• 22:50   Re: locking issue on simple selects? Kevin Grittner

24 September 2010

• 06:50   postgresql-9.0 Windows service stops after database transaction adrian.kitchingman@dse.vic.gov.au
• 07:05   Re: postgresql-9.0 Windows service stops after database transaction Thom Brown
• 14:17   Re: Memory usage - indexes Kevin Grittner
• 16:23   Re: Memory usage - indexes Bob Lunney
• 16:46   Re: Memory usage - indexes Tobias Brox
• 16:53   Re: Memory usage - indexes Tobias Brox
• 17:16   Re: Memory usage - indexes Brad Nicholson
• 17:33   Re: Query much faster with enable_seqscan=0 Scott Carey
• 17:41   Re: Memory usage - indexes Tobias Brox
• 17:51   Re: Memory usage - indexes Kevin Grittner
• 18:01   Re: Memory usage - indexes Greg Smith
• 18:05   Re: Memory usage - indexes Greg Smith
• 18:34   Re: Memory usage - indexes Brad Nicholson
• 19:06   Re: Memory usage - indexes Bob Lunney
• 19:25   Re: Memory usage - indexes Brad Nicholson
• 19:59   Re: Memory usage - indexes Tobias Brox
• 20:00   Re: Memory usage - indexes Tobias Brox
• 20:08   Re: Memory usage - indexes Tobias Brox
• 20:50   Re: Memory usage - indexes Tobias Brox
• 22:00   Re: Memory usage - indexes Greg Smith

25 September 2010

• 10:30   Re: Memory usage - indexes Tobias Brox

26 September 2010

• 03:36   Re: turn off caching for performance test Robert Haas
• 04:02   Re: Is disableing nested_loops a bad idea ? Robert Haas

27 September 2010

• 07:23   Re: postgresql-9.0 Windows service stops after database transaction adrian.kitchingman@dse.vic.gov.au
• 07:23   Re: postgresql-9.0 Windows service stops after database transaction adrian.kitchingman@dse.vic.gov.au
• 16:53   Re: Memory speed testing Greg Smith
• 17:30   Re: how to enforce index sub-select over filter+seqscan Robert Haas
• 18:50   Odd behaviour with redundant CREATE statement Dave Crooke
• 19:28   Re: Odd behaviour with redundant CREATE statement Gurjeet Singh

28 September 2010

• 09:12   Re: postgresql-9.0 Windows service stops after database transaction Craig Ringer
• 10:01   Clean up of archived Xlogs in postgres-9. Nimesh Satam
• 12:29   Re: Clean up of archived Xlogs in postgres-9. Erik Rijkers
• 16:03   Re: Query much faster with enable_seqscan=0 Robert Haas
• 19:22   Running 9 in production? Sticking with 8.4.4 for a while? Tory M Blue
• 20:09   Re: Running 9 in production? Sticking with 8.4.4 for a while? Michael Gould
• 20:45   Re: Running 9 in production? Sticking with 8.4.4 for a while? Greg Smith
• 22:46   Re: Running 9 in production? Sticking with 8.4.4 for a while? Guy Rouillier
• 22:53   Re: Running 9 in production? Sticking with 8.4.4 for a while? Tory M Blue

29 September 2010

• 06:42   Re: Memory usage - indexes Tobias Brox
• 08:03   Re: Memory usage - indexes Mark Kirkwood
• 12:10   Re: Memory usage - indexes Tobias Brox
• 16:31   How does PG know if data is in memory? Fabrício dos Anjos Silva
• 16:37   Re: How does PG know if data is in memory? Kevin Grittner
• 16:55   Wrong index choice Fabrício dos Anjos Silva
• 17:08   Re: How does PG know if data is in memory? Samuel Gendler
• 21:00   Re: Wrong index choice Kevin Grittner

30 September 2010

• 00:02   Performance improvements/regressions from 8.4 to 9.0? Andy
• 05:15   Re: Performance improvements/regressions from 8.4 to 9.0? Greg Smith
• 07:28   Re: postgresql-9.0 Windows service stops after database transaction adrian.kitchingman@dse.vic.gov.au
• 16:42   Re: turn off caching for performance test Willy-Bas Loos
• 18:33   gist indexes for distance calculations Marcelo Zabani
• 19:16   Re: gist indexes for distance calculations Tom Lane
• 21:01   Re: Memory usage - indexes Mark Kirkwood