Mailing lists [pgsql-performance]

1 December 2008

• 12:30   Re: Query optimization PFC

2 December 2008

• 05:59   Sort causes system to freeze Craig James
• 07:27   Re: Sort causes system to freeze Craig James
• 07:51   Context switch storms Omar Kilani
• 08:22   Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 09:04   Re: Sort causes system to freeze Richard Huxton
• 09:34   Re: Sort causes system to freeze Tom Lane
• 11:00   Re: Sort causes system to freeze PFC
• 11:12   analyzing intermediate query Andrus
• 12:47   Re: analyzing intermediate query PFC
• 13:01   Re: analyzing intermediate query Andrus
• 13:12   Re: analyzing intermediate query PFC
• 13:37   Re: analyzing intermediate query Andrus
• 14:14   Re: analyzing intermediate query PFC
• 14:51   Re: analyzing intermediate query Andrus
• 15:02   Fwd: Not so simple query and a half million loop Daniel Cristian Cruz
• 16:50   Re: analyzing intermediate query Scott Carey
• 17:59   Re: analyzing intermediate query Andrus
• 20:22   Re: analyzing intermediate query Scott Carey

3 December 2008

• 15:01   Postgres using more memory than it should Matthew Wakeling
• 15:14   Re: Postgres using more memory than it should Bill Moran
• 15:24   Re: Postgres using more memory than it should tv@fuzzy.cz
• 15:34   Re: Postgres using more memory than it should Matthew Wakeling
• 15:48   Re: Postgres using more memory than it should Scott Marlowe
• 15:59   Re: Postgres using more memory than it should Matthew Wakeling
• 16:53   Re: Postgres using more memory than it should hubert depesz lubaczewski
• 18:14   Re: Postgres using more memory than it should Scott Marlowe
• 18:31   How to profile an "SQL script"? Kynn Jones
• 18:40   Re: How to profile an "SQL script"? Andreas Kretschmer
• 19:47   Re: How to profile an "SQL script"? Heikki Linnakangas
• 23:03   Re: How to profile an "SQL script"? Kynn Jones

4 December 2008

• 10:35   Re: Postgres using more memory than it should Matthew Wakeling
• 12:06   Re: Postgres using more memory than it should Matthew Wakeling
• 12:40   Trigger function, bad performance Rogatzki Rainer
• 13:20   pg_restore : out of memory Franck Routier

5 December 2008

• 07:24   Re: Trigger function, bad performance Albe Laurenz
• 09:41   Re: Trigger function, bad performance Rogatzki Rainer
• 10:08   Re: Trigger function, bad performance A. Kretschmer
• 12:23   Re: Trigger function, bad performance Rogatzki Rainer
• 12:37   Re: Trigger function, bad performance A. Kretschmer
• 14:16   Re: Trigger function, bad performance Albe Laurenz
• 14:41   Re: Trigger function, bad performance Rogatzki Rainer
• 21:42   Re: Context switch storms Kevin Grittner
• 21:48   Re: Experience with HP Smart Array P400 and SATA drives? Kevin Grittner
• 22:00   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 22:30   Re: Experience with HP Smart Array P400 and SATA drives? Alan Hodgson
• 23:29   Re: Experience with HP Smart Array P400 and SATA drives? Greg Smith

6 December 2008

• 00:39   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 20:35   Re: file system and raid performance Bruce Momjian

7 December 2008

• 18:38   Need help with 8.4 Performance Testing Josh Berkus

8 December 2008

• 01:09   Re: Need help with 8.4 Performance Testing Kenneth Marshall
• 04:40   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 04:58   Re: file system and raid performance M. Edward (Ed) Borasky
• 05:45   Re: Need help with 8.4 Performance Testing Derek Lewis
• 11:15   Re: file system and raid performance Jean-David Beyer
• 15:12   Re: file system and raid performance Scott Marlowe
• 19:05   Re: file system and raid performance david@lang.hm
• 19:15   Re: Need help with 8.4 Performance Testing Greg Smith
• 19:37   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 21:52   Re: Need help with 8.4 Performance Testing Greg Smith

9 December 2008

• 00:23   Re: Need help with 8.4 Performance Testing Merlin Moncure
• 03:00   Re: Need help with 8.4 Performance Testing Greg Smith
• 11:10   Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 11:15   Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 11:17   Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 12:08   Re: Need help with 8.4 Performance Testing Gregory Stark
• 12:09   Re: Need help with 8.4 Performance Testing Jean-David Beyer
• 12:58   Re: Need help with 8.4 Performance Testing Simon Waters
• 13:35   Re: file system and raid performance M. Edward (Ed) Borasky
• 13:56   Re: Need help with 8.4 Performance Testing Greg Stark
• 14:30   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 14:58   Re: Experience with HP Smart Array P400 and SATA drives? Joshua D. Drake
• 15:11   Re: Experience with HP Smart Array P400 and SATA drives? Gabriele Turchi
• 15:16   Re: Experience with HP Smart Array P400 and SATA drives? Aidan Van Dyk
• 15:25   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 15:27   Re: Experience with HP Smart Array P400 and SATA drives? Peter Eisentraut
• 15:34   Re: Experience with HP Smart Array P400 and SATA drives? Aidan Van Dyk
• 15:37   Re: Need help with 8.4 Performance Testing Scott Carey
• 15:43   Re: Experience with HP Smart Array P400 and SATA drives? Joshua D. Drake
• 15:44   Re: Experience with HP Smart Array P400 and SATA drives? Joshua D. Drake
• 16:21   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 16:26   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 16:30   Re: Need help with 8.4 Performance Testing Scott Carey
• 16:35   Re: Need help with 8.4 Performance Testing Matthew Wakeling
• 16:46   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 17:01   Re: Need help with 8.4 Performance Testing Scott Carey
• 17:08   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 17:11   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 19:12   Re: Need help with 8.4 Performance Testing Merlin Moncure
• 19:20   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 21:05   Re: Need help with 8.4 Performance Testing Scott Carey
• 21:33   query plan with index having a btrim is different for strings of different length Richard Yen
• 21:38   Re: Need help with 8.4 Performance Testing Tom Lane
• 21:41   Re: query plan with index having a btrim is different for strings of different length David Wilson
• 21:58   Re: Need help with 8.4 Performance Testing Robert Haas
• 22:05   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 22:13   Re: Need help with 8.4 Performance Testing Ben Chobot
• 22:29   Re: Need help with 8.4 Performance Testing justin
• 22:36   Re: query plan with index having a btrim is different for strings of different length Tom Lane
• 22:39   Re: Need help with 8.4 Performance Testing Scott Carey
• 23:45   Re: Need help with 8.4 Performance Testing Gregory Stark
• 23:54   Re: Need help with 8.4 Performance Testing Gregory Stark

10 December 2008

• 00:37   Re: Need help with 8.4 Performance Testing Ron Mayer
• 00:57   Re: Need help with 8.4 Performance Testing Craig James
• 02:06   Re: Need help with 8.4 Performance Testing Robert Haas
• 02:33   Degenerate Performance Problem Vincent Predoehl
• 02:47   Re: Degenerate Performance Problem Scott Marlowe
• 04:48   Re: Need help with 8.4 Performance Testing Scott Carey
• 06:45   Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 06:59   Re: Experience with HP Smart Array P400 and SATA drives? Scott Carey
• 07:20   Re: Need help with 8.4 Performance Testing Scott Carey
• 11:29   Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 12:34   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 12:41   Re: Need help with 8.4 Performance Testing Matthew Wakeling
• 13:18   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 13:30   Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 14:23   Re: Experience with HP Smart Array P400 and SATA drives? Gregory Williamson
• 14:50   Re: Experience with HP Smart Array P400 and SATA drives? Aidan Van Dyk
• 15:05   Re: Experience with HP Smart Array P400 and SATA drives? Mario Weilguni
• 15:17   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 17:08   Re: Experience with HP Smart Array P400 and SATA drives? Matthew Wakeling
• 18:16   Re: Experience with HP Smart Array P400 and SATA drives? Greg Smith
• 18:28   Re: query plan with index having a btrim is different for strings of different length Richard Yen
• 18:34   Re: query plan with index having a btrim is different for strings of different length Tom Lane
• 18:39   Re: query plan with index having a btrim is different for strings of different length Robert Haas
• 18:41   Re: Experience with HP Smart Array P400 and SATA drives? Scott Marlowe
• 19:05   Re: query plan with index having a btrim is different for strings of different length Tom Lane
• 20:37   Re: Experience with HP Smart Array P400 and SATA drives? David Wilson
• 20:55   Re: query plan with index having a btrim is different for strings of different length Richard Yen
• 21:05   Re: query plan with index having a btrim is different for strings of different length Richard Yen
• 21:37   Re: query plan with index having a btrim is different for strings of different length Vladimir Sitnikov
• 23:08   Re: query plan with index having a btrim is different for strings of different length Tom Lane

11 December 2008

• 00:44   Re: query plan with index having a btrim is different for strings of different length Richard Yen
• 12:47   Re: Experience with HP Smart Array P400 and SATA drives? Matthew Wakeling
• 19:05   Re: Need help with 8.4 Performance Testing Josh Berkus
• 19:07   Re: Need help with 8.4 Performance Testing Josh Berkus
• 19:15   Re: Need help with 8.4 Performance Testing Josh Berkus
• 22:08   Re: Need help with 8.4 Performance Testing James Mansion

12 December 2008

• 06:55   Re: Need help with 8.4 Performance Testing Greg Smith
• 09:07   db server load Stefano Nichele
• 20:44   Re: db server load Scott Marlowe

13 December 2008

• 12:23   Re: Need help with 8.4 Performance Testing Robert Haas
• 13:43   Re: Need help with 8.4 Performance Testing david@lang.hm
• 14:15   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 17:38   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 18:45   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 18:47   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 18:57   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 19:04   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 20:00   Re: Need help with 8.4 Performance Testing Angel Alvarez

14 December 2008

• 01:16   Re: Need help with 8.4 Performance Testing Scott Marlowe
• 02:09   Re: Need help with 8.4 Performance Testing Joshua D. Drake
• 04:49   Re: Need help with 8.4 Performance Testing Tom Lane

15 December 2008

• 05:56   filesystems benchmark Adrian Moisey
• 11:02   Re: filesystems benchmark Vladimir Sitnikov
• 17:09   Re: filesystems benchmark Greg Smith

16 December 2008

• 18:34   measure database contention Jaime Casanova

17 December 2008

• 03:03   insert and Update slow after implementing slony. Nimesh Satam
• 06:34   Re: measure database contention Albe Laurenz
• 13:20   Re: measure database contention Robert Haas
• 13:50   Re: measure database contention Merlin Moncure
• 14:22   Re: measure database contention Jaime Casanova
• 14:38   Re: measure database contention Jaime Casanova
• 15:57   Re: measure database contention Robert Haas
• 17:19   Re: measure database contention Jaime Casanova
• 17:57   Re: measure database contention Scott Marlowe
• 19:01   Re: insert and Update slow after implementing slony. David Rees
• 20:15   Re: measure database contention Robert Haas

19 December 2008

• 00:25   Re: Fwd: Not so simple query and a half million loop Craig Ringer
• 00:50   Re: pg_restore : out of memory Craig Ringer
• 07:00   Re: pg_restore : out of memory sathiya psql

20 December 2008

• 23:54   dbt-2 tuning results with postgresql-8.3.5 Mark Wong

21 December 2008

• 00:33   Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark
• 07:17   PostgreSQL vs Oracle Victor Nawothnig
• 07:51   Re: PostgreSQL vs Oracle Scott Marlowe
• 08:29   Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
• 09:15   Re: PostgreSQL vs Oracle Stefano Dal Pra
• 19:08   Query planner plus partitions equals very bad plans, again Scott Carey

22 December 2008

• 02:31   Re: PostgreSQL vs Oracle Guy Rouillier
• 05:56   Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark
• 07:50   Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
• 07:59   Re: dbt-2 tuning results with postgresql-8.3.5 Greg Smith
• 09:35   Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark
• 09:56   Re: dbt-2 tuning results with postgresql-8.3.5 Gregory Stark
• 10:06   Slow table update Laszlo Nagy
• 10:34   Re: Slow table update Laszlo Nagy
• 10:48   Re: Slow table update Gregory Williamson
• 11:54   Re: Slow table update Laszlo Nagy
• 12:28   Re: Slow table update Laszlo Nagy
• 12:30   Re: Slow table update Tom Lane
• 12:57   Re: [ADMIN] rebellious pg stats collector (reopened case) Laszlo Nagy
• 12:59   Re: [ADMIN] rebellious pg stats collector (reopened case) Laszlo Nagy
• 13:00   Re: [ADMIN] rebellious pg stats collector (reopened case) Alvaro Herrera
• 14:12   temp_tablespaces and RAID Marc Mamin
• 14:27   Re: dbt-2 tuning results with postgresql-8.3.5 Kevin Grittner
• 17:07   Re: temp_tablespaces and RAID Scott Marlowe

23 December 2008

• 02:30   Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
• 02:36   Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
• 02:49   Re: dbt-2 tuning results with postgresql-8.3.5 Mark Wong
• 02:51   Re: dbt-2 tuning results with postgresql-8.3.5 Greg Smith
• 11:01   Re: dbt-2 tuning results with postgresql-8.3.5 Alvaro Herrera
• 16:25   How to "unique-ify" HUGE table? Kynn Jones
• 16:34   Re: How to "unique-ify" HUGE table? Scott Marlowe
• 16:45   Re: How to "unique-ify" HUGE table? D'Arcy J.M. Cain
• 17:15   Re: How to "unique-ify" HUGE table? George Pavlov
• 17:37   Re: How to "unique-ify" HUGE table? Scott Marlowe
• 18:47   Re: How to "unique-ify" HUGE table? Stefan Kaltenbrunner

24 December 2008

• 13:13   Re: dbt-2 tuning results with postgresql-8.3.5 Simon Riggs
• 16:36   Troubles dumping a very large table. Ted Allen
• 16:50   Re: Troubles dumping a very large table. Tom Lane
• 17:56   Re: How to "unique-ify" HUGE table? Kynn Jones

25 December 2008

• 22:08   Bgwriter and pg_stat_bgwriter.buffers_clean aspects Dmitry Koterov

26 December 2008

• 13:34   Re: Slow table update Nikolas Everett
• 15:07   Re: Troubles dumping a very large table. Ted Allen
• 16:38   Re: Troubles dumping a very large table. Tom Lane
• 18:50   Re: Troubles dumping a very large table. Merlin Moncure
• 19:18   Re: Troubles dumping a very large table. Tom Lane

28 December 2008

• 21:05   Re: Bgwriter and pg_stat_bgwriter.buffers_clean aspects Greg Smith

29 December 2008

• 02:11   Re: Troubles dumping a very large table. Ted Allen
• 08:43   Re: Slow table update Laszlo Nagy
• 10:00   Re: Slow table update Gregory Williamson
• 11:48   Re: Troubles dumping a very large table. Dimitri Fontaine
• 12:30   Re: Slow table update - SOLVED! Laszlo Nagy

30 December 2008

• 08:06   Big index sizes Laszlo Nagy
• 08:21   Re: Big index sizes Guillaume Lelarge
• 09:55   perform 1 check vs exception when unique_violation Anton Bogdanovitch
• 13:43   Re: Big index sizes Robert Haas
• 13:51   Re: perform 1 check vs exception when unique_violation Robert Haas
• 14:39   Re: Big index sizes Tom Lane
• 17:59   Poor plan choice in prepared statement bricklen
• 18:42   Re: Poor plan choice in prepared statement Merlin Moncure
• 18:55   Re: Poor plan choice in prepared statement bricklen
• 19:10   Re: Poor plan choice in prepared statement Scott Marlowe
• 19:14   Re: Poor plan choice in prepared statement bricklen
• 20:09   Re: Poor plan choice in prepared statement Scott Carey
• 20:40   Re: Poor plan choice in prepared statement bricklen
• 22:02   Re: Poor plan choice in prepared statement Tom Lane
• 22:11   Re: Poor plan choice in prepared statement bricklen
• 22:17   Re: Poor plan choice in prepared statement david@lang.hm

31 December 2008

• 03:23   Re: Poor plan choice in prepared statement Gregory Stark
• 08:12   Re: Poor plan choice in prepared statement Guillaume Smet
• 14:11   Re: Poor plan choice in prepared statement bricklen
• 15:01   Re: Poor plan choice in prepared statement Alvaro Herrera