Mailing lists [pgsql-performance]

1 November 2005

• 01:00   Re: 8.1beta3 performance Steinar H. Gunderson
• 01:06   Re: 8.1beta3 performance Neil Conway
• 07:03   pgbench results interpretation? Joost Kraaijeveld
• 08:17   Re: pgbench results interpretation? Gavin Sherry
• 09:05   Re: pgbench results interpretation? Joost Kraaijeveld
• 12:33   Re: 8.x index insert performance Kelly Burkhart
• 12:45   Re: 8.x index insert performance Tom Lane
• 13:14   solutions for new Postgresql application testing Geoffrey
• 13:50   Re: 8.1beta3 performance Jon Brisbin
• 14:37   Re: 8.x index insert performance Ron Peacetree
• 14:49   Re: 8.1beta3 performance Dave Page
• 16:25   Re: 8.1beta3 performance Tom Lane
• 18:00   improvise callbacks in plpgsql Merlin Moncure
• 18:39   Re: solutions for new Postgresql application testing Merlin Moncure
• 20:29   Re: improvise callbacks in plpgsql Tom Lane
• 21:13   Re: improvise callbacks in plpgsql Merlin Moncure
• 22:04   Re: improvise callbacks in plpgsql Jim C. Nasby
• 22:12   Re: solutions for new Postgresql application testing Geoffrey
• 22:16   Joining views disables indexes? Mitch Pirtle
• 22:23   Re: Joining views disables indexes? Jim C. Nasby
• 22:28   Re: Joining views disables indexes? Steinar H. Gunderson
• 22:28   Re: Joining views disables indexes? Tom Lane

2 November 2005

• 00:19   Re: performance of implicit join vs. explicit conditions on inet queries? Qingqing Zhou
• 03:20   Re: performance of implicit join vs. explicit conditions on inet queries? Tom Lane
• 08:32   Re: 8.1beta3 performance PostgreSQL
• 09:16   Re: pgbench results interpretation? Gavin Sherry
• 12:36   Re: insert performance for win32 Merlin Moncure
• 12:45   Re: improvise callbacks in plpgsql Merlin Moncure
• 12:54   Re: insert performance for win32 Magnus Hagander
• 13:41   Re: 8.1beta3 performance Tom Lane
• 13:41   Re: pgbench results interpretation? Joost Kraaijeveld
• 13:47   Re: insert performance for win32 Marc Cousin
• 14:11   Re: insert performance for win32 Tom Lane
• 14:34   Performance difference between sql and pgsql function... Cristian Prieto
• 15:47   Re: improvise callbacks in plpgsql Merlin Moncure
• 16:04   Re: improvise callbacks in plpgsql Merlin Moncure
• 16:26   Re: 8.x index insert performance Greg Stark
• 22:34   Trigger Rowsets Ralph Mason
• 22:50   Re: Trigger Rowsets Jim C. Nasby

3 November 2005

• 04:13   Sorted union Scott Lamb
• 04:27   Re: Sorted union Scott Lamb
• 06:11   Re: insert performance for win32 Qingqing Zhou
• 12:53   Re: Sorted union Merlin Moncure
• 14:14   Function with table%ROWTYPE globbing Sven Willenberger
• 14:37   Re: Function with table%ROWTYPE globbing Merlin Moncure
• 14:41   Re: Sorted union Scott Lamb
• 15:21   Re: Sorted union Merlin Moncure
• 17:10   Re: insert performance for win32 Merlin Moncure
• 17:10   Re: Sorted union Scott Lamb
• 17:23   Re: Sorted union Merlin Moncure
• 17:33   Re: Sorted union Kevin Grittner
• 17:41   Re: Sorted union Merlin Moncure
• 17:49   Re: insert performance for win32 Merlin Moncure
• 17:55   Re: insert performance for win32 Merlin Moncure
• 18:11   Re: Sorted union Scott Lamb
• 18:22   Re: insert performance for win32 Magnus Hagander
• 18:32   Re: Sorted union Kevin Grittner
• 19:30   Re: insert performance for win32 Magnus Hagander
• 19:34   Re: insert performance for win32 Qingqing Zhou
• 19:39   Re: insert performance for win32 Magnus Hagander
• 20:06   Re: insert performance for win32 Qingqing Zhou
• 20:15   Re: insert performance for win32 Magnus Hagander
• 21:13   Re: insert performance for win32 Qingqing Zhou
• 21:41   Encoding on 8.0.4 Don Drake
• 22:30   Re: insert performance for win32 Qingqing Zhou

4 November 2005

• 01:32   Re: insert performance for win32 Qingqing Zhou
• 02:02   Re: insert performance for win32 Merlin Moncure
• 02:03   Re: insert performance for win32 Tom Lane
• 06:29   Re: insert performance for win32 Qingqing Zhou
• 12:49   Re: insert performance for win32 Merlin Moncure
• 13:07   Re: insert performance for win32 Merlin Moncure
• 13:45   Searching union views not using indices Michal Taborsky
• 13:59   Re: insert performance for win32 Tom Lane
• 14:05   Re: Searching union views not using indices Richard Huxton
• 14:08   Re: Searching union views not using indices Merlin Moncure
• 14:12   Re: insert performance for win32 Merlin Moncure
• 14:14   Re: Searching union views not using indices Michael Fuhr
• 14:21   Re: insert performance for win32 Tom Lane
• 14:31   Re: insert performance for win32 Merlin Moncure
• 14:31   Re: Searching union views not using indices Tom Lane
• 14:36   Re: insert performance for win32 Tom Lane
• 14:41   Re: insert performance for win32 Merlin Moncure
• 14:56   Re: Searching union views not using indices Michal Taborsky
• 15:16   Re: insert performance for win32 Merlin Moncure
• 15:33   Re: insert performance for win32 Tom Lane
• 16:53   Re: Searching union views not using indices Tom Lane
• 16:56   Re: insert performance for win32 Merlin Moncure
• 17:01   Re: insert performance for win32 Tom Lane
• 17:07   Re: insert performance for win32 Merlin Moncure
• 17:14   Re: insert performance for win32 Tom Lane
• 17:15   Re: insert performance for win32 Bruce Momjian
• 17:19   Re: [HACKERS] insert performance for win32 Tom Lane
• 17:21   Re: insert performance for win32 Magnus Hagander
• 17:21   Re: [HACKERS] insert performance for win32 Bruce Momjian
• 17:30   Re: insert performance for win32 Qingqing Zhou
• 17:30   Re: [HACKERS] insert performance for win32 Magnus Hagander
• 21:17   Re: insert performance for win32 Qingqing Zhou

6 November 2005

• 08:02   Re: [HACKERS] insert performance for win32 Simon Riggs
• 10:06   8.1 iss PostgreSQL
• 12:31   Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Joost Kraaijeveld
• 15:31   Re: 8.1 iss Tom Lane
• 16:17   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Tom Lane
• 17:09   Performance problem with pg8.0 Jeroen van Iddekinge
• 18:24   Re: 8.1 iss Greg Stark
• 18:33   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 19:26   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Tom Lane
• 22:25   Re: 8.1 iss Luke Lonergan

7 November 2005

• 03:26   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 03:37   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Christopher Kings-Lynne
• 04:05   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 04:47   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 04:58   Re: Used Memory Christian Paul B. Cosinas
• 05:05   Re: 8.1 iss Dennis Bjorklund
• 06:31   FW: Used Memory Christian Paul B. Cosinas
• 06:31   Temporary Table Christian Paul B. Cosinas
• 07:51   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Dave Page
• 08:03   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 08:17   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Dave Page
• 08:51   Re: Performance problem with pg8.0 Richard Huxton
• 10:07   Re: Temporary Table Alvaro Herrera
• 13:47   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Alex Turner
• 16:22   Re: 8.1 iss PostgreSQL
• 16:48   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Andreas Pflug
• 17:11   Index + mismatching datatypes [WAS: index on custom function; explain] Enrico Weigelt
• 19:42   Re: Index + mismatching datatypes [WAS: index on custom Neil Conway
• 20:35   Figuring out which command failed Ralph Mason
• 20:40   Re: Temporary Table Ralph Mason

8 November 2005

• 01:00   Re: Temporary Table Christian Paul B. Cosinas
• 01:04   Re: Temporary Table Christian Paul B. Cosinas
• 01:10   Re: Temporary Table Joshua D. Drake
• 01:13   Re: Temporary Table Christopher Kings-Lynne
• 01:14   Re: Temporary Table Christopher Kings-Lynne
• 01:17   Re: Temporary Table Christian Paul B. Cosinas
• 01:23   Re: Temporary Table Christopher Kings-Lynne
• 01:29   Re: Temporary Table Jeff Frost
• 02:01   Expensive function and the optimizer Craig A. James
• 02:02   Re: Temporary Table Andrew McMillan
• 03:12   Re: Expensive function and the optimizer Tom Lane
• 08:01   Sort performance on large tables Charlie Savage
• 10:15   Re: Sort performance on large tables Richard Huxton
• 12:45   Re: 8.1 iss Mario Weilguni
• 15:25   Re: Sort performance on large tables Luke Lonergan
• 15:32   Re: Sort performance on large tables Marc Morin
• 16:56   Re: Sort performance on large tables Stephan Szabo
• 18:10   Re: Sort performance on large tables Luke Lonergan
• 19:48   Re: Sort performance on large tables Stephan Szabo
• 21:06   Re: Sort performance on large tables Charlie Savage
• 21:26   Re: Sort performance on large tables Tom Lane
• 22:47   Re: Sort performance on large tables Charlie Savage

9 November 2005

• 00:47   Re: Sort performance on large tables Christopher Kings-Lynne
• 01:23    William Lai
• 01:31   Re: Figuring out which command failed Thomas F. O'Connell
• 04:49   Re: Sort performance on large tables Charlie Savage
• 08:38   Re: Sort performance on large tables Simon Riggs
• 11:08   Improving performance on multicolumn query Jan Kesten
• 11:55   Re: Improving performance on multicolumn query Richard Huxton
• 12:00   Re: Improving performance on multicolumn query Steinar H. Gunderson
• 12:19   Re: Improving performance on multicolumn query Christopher Kings-Lynne
• 14:51   Re: Improving performance on multicolumn query Steinar H. Gunderson
• 16:13   Re: Sort performance on large tables Charlie Savage
• 16:31   Re: Improving performance on multicolumn query Jan Kesten
• 18:59   Outer Join performance in PostgreSQL Ashok Agrawal
• 19:35   Some help on buffers and other performance tricks Yves Vindevogel
• 20:24   Re: Some help on buffers and other performance tricks Ron Peacetree
• 20:40   Re: Outer Join performance in PostgreSQL Michael Alan Dorman
• 20:41   Re: Sort performance on large tables Ron Peacetree
• 20:43   (View and SQL) VS plpgsql Eric Lauzon
• 21:47   Re: Outer Join performance in PostgreSQL Stephan Szabo
• 22:08   Re: Some help on buffers and other performance tricks Alvaro Herrera
• 23:44   Re: Some help on buffers and other performance tricks Alvaro Herrera
• 23:54   Re: Some help on buffers and other performance tricks Frank Wiles

10 November 2005

• 01:58   Re: Some help on buffers and other performance tricks Frank Wiles
• 03:20   Re: Some help on buffers and other performance tricks Ron Peacetree
• 07:50   Re: (View and SQL) VS plpgsql Nörder-Tuitje, Marcus
• 12:32   WAL sync behaviour Steinar H. Gunderson
• 13:17   Re: WAL sync behaviour Richard Huxton
• 13:25   Re: WAL sync behaviour Steinar H. Gunderson
• 14:16   Re: Some help on buffers and other performance tricks Scott Marlowe
• 14:24   Re: Some help on buffers and other performance tricks Frank Wiles
• 14:43   Re: WAL sync behaviour Michael Stone
• 14:43   Re: Some help on buffers and other performance tricks Merlin Moncure
• 14:51   Re: Some help on buffers and other performance tricks Scott Marlowe
• 14:52   Re: WAL sync behaviour Scott Marlowe
• 15:04   Re: WAL sync behaviour Michael Stone
• 15:23   Re: Sort performance on large tables Ron Peacetree
• 15:34   Re: Sort performance on large tables Alex Turner
• 15:39   Re: WAL sync behaviour Tom Lane
• 15:52   same plan, add 1 condition, 1900x slower Mitch Skinner
• 15:59   Index Scan Costs versus Sort Charlie Savage
• 16:00   Re: WAL sync behaviour Scott Marlowe
• 16:11   Re: WAL sync behaviour mark@mark.mielke.cc
• 16:24   Re: same plan, add 1 condition, 1900x slower Tom Lane
• 16:44   Re: WAL sync behaviour Tom Lane
• 16:58   Re: WAL sync behaviour Steinar H. Gunderson
• 17:04   Re: Index Scan Costs versus Sort Tom Lane
• 17:17   Re: Outer Join performance in PostgreSQL Ashok Agrawal
• 18:01   Re: Index Scan Costs versus Sort Charlie Savage
• 19:46   Re: 8.x index insert performance Kelly Burkhart
• 21:01   Re: 8.x index insert performance Kelly Burkhart
• 21:18   Re: 8.x index insert performance Tom Lane
• 22:01   Re: 8.x index insert performance Tom Lane
• 23:11   Re: Index Scan Costs versus Sort Charlie Savage
• 23:13   Re: 8.x index insert performance Tom Lane
• 23:32   Re: Index Scan Costs versus Sort Tom Lane

11 November 2005

• 08:17   Re: same plan, add 1 condition, 1900x slower Mitch Skinner
• 10:57   Re: same plan, add 1 condition, 1900x slower Richard Huxton
• 13:10   Re: same plan, add 1 condition, 1900x slower Tom Lane
• 13:18   Re: same plan, add 1 condition, 1900x slower Tom Lane
• 13:20   Re: same plan, add 1 condition, 1900x slower Mitch Skinner
• 14:24   Re: same plan, add 1 condition, 1900x slower Mitch Skinner
• 14:34   Re: same plan, add 1 condition, 1900x slower Tom Lane
• 14:54   Re: same plan, add 1 condition, 1900x slower Tom Lane
• 15:56   Re: same plan, add 1 condition, 1900x slower Mitchell Skinner
• 16:17   Re: same plan, add 1 condition, 1900x slower Tom Lane
• 18:21   slow queries after ANALYZE DW
• 18:32   Re: slow queries after ANALYZE Tom Lane
• 19:48   Re: slow queries after ANALYZE DW
• 20:25   Re: slow queries after ANALYZE Tom Lane
• 21:48   Re: 8.x index insert performance Kelly Burkhart
• 21:58   Re: 8.x index insert performance Kevin Grittner
• 22:02   Re: 8.x index insert performance Tom Lane

12 November 2005

• 08:14   Re: slow queries after ANALYZE hubert depesz lubaczewski
• 13:18   IO Error Yves Vindevogel
• 14:53   Re: IO Error Tom Lane

14 November 2005

• 13:43   Re: 8.x index insert performance Kelly Burkhart
• 14:57   Re: 8.x index insert performance Ron
• 17:53   Re: slow queries after ANALYZE DW
• 18:28   Postgres recovery time Piccarello, James (James)
• 22:07   Help speeding up delete Steve Wampler
• 22:20   Re: Help speeding up delete Scott Lamb
• 22:42   Re: Help speeding up delete Tom Lane
• 22:51   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Raid5 / Debian?? Dave Cramer
• 22:52   Re: Help speeding up delete Steve Wampler
• 22:54   Re: Postgres recovery time David Boreham
• 22:54   Hardware/OS recommendations for large databases (5TB) Adam Weisberg
• 23:02   Re: Help speeding up delete Steve Wampler
• 23:10   Re: Help speeding up delete Joshua Marsh
• 23:28   Re: Help speeding up delete Steve Wampler

15 November 2005

• 00:08   Re: Help speeding up delete Scott Lamb
• 03:04   Re: Help speeding up delete Steve Wampler
• 07:28   Re: Hardware/OS recommendations for large databases (5TB) Claus Guttesen
• 07:47   Re: Help speeding up delete Magnus Hagander
• 11:10   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 13:09   Re: Hardware/OS recommendations for large databases (5TB) Merlin Moncure
• 13:18   Re: Help speeding up delete Steve Wampler
• 13:18   Re: Hardware/OS recommendations for large databases ( Dave Cramer
• 13:34   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 13:37   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 13:50   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 13:55   Re: Hardware/OS recommendations for large databases ( Michael Stone
• 14:20   Re: Hardware/OS recommendations for large databases ( 5TB) Merlin Moncure
• 14:40   Re: Hardware/OS recommendations for large databases ( 5TB) Adam Weisberg
• 14:51   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 15:35   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 17:42   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Luke Lonergan
• 17:46   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 17:48   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:00   Re: Hardware/OS recommendations for large databases ( 5TB) William Yu
• 18:32   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 18:38   Too Many OR's? Bill McGonigle
• 18:41   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Steve Wampler
• 18:51   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 19:01   Re: Too Many OR's? Scott Marlowe
• 21:08   Re: Hardware/OS recommendations for large databases ( 5TB) James Mello

16 November 2005

• 04:15   Re: Hardware/OS recommendations for large databases ( Alex Turner
• 04:17   Re: Hardware/OS recommendations for large databases ( Alex Turner
• 05:08   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Luke Lonergan
• 05:12   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 05:57   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 09:17   Re: Performance PG 8.0 on dual opteron / 4GB / 3ware Joost Kraaijeveld
• 11:51   Re: Hardware/OS recommendations for large databases ( William Yu
• 12:09   Re: Hardware/OS recommendations for large databases ( 5TB) William Yu
• 12:57   Re: Hardware/OS recommendations for large databases ( Joshua D. Drake
• 12:59   Re: Hardware/OS recommendations for large databases Ron
• 13:13   Re: Hardware/OS recommendations for large databases ( Alex Stapleton
• 13:29   Re: Hardware/OS recommendations for large databases ( Steve Wampler
• 13:35   Re: Hardware/OS recommendations for large databases ( David Boreham
• 13:38   Re: Hardware/OS recommendations for large databases ( William Yu
• 13:40   Re: Hardware/OS recommendations for large databases ( Steve Wampler
• 13:51   Re: Hardware/OS recommendations for large databases ( David Boreham
• 14:33   Re: Hardware/OS recommendations for large databases ( William Yu
• 14:41   Re: Hardware/OS recommendations for large databases ( William Yu
• 14:46   Re: Hardware/OS recommendations for large databases ( Joshua D. Drake
• 15:00   Re: Hardware/OS recommendations for large databases ( David Boreham
• 15:02   Re: Hardware/OS recommendations for large databases ( Joshua D. Drake
• 16:06   Re: Hardware/OS recommendations for large databases ( Scott Marlowe
• 16:09   Re: Hardware/OS recommendations for large databases ( Scott Marlowe
• 16:12   Re: Hardware/OS recommendations for large databases Alex Turner
• 16:47   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 16:49   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 16:54   Re: Hardware/OS recommendations for large databases ( Scott Marlowe
• 17:51   Re: Hardware/OS recommendations for large databases ( Matthew Nuzum
• 17:52   Re: Hardware/OS recommendations for large databases ( Steinar H. Gunderson
• 18:03   Re: Hardware/OS recommendations for large databases ( Matthew Nuzum
• 18:15   OT Re: Hardware/OS recommendations for large databases ( Douglas J. Trainor
• 18:15   Re: Hardware/OS recommendations for large databases ( Welty, Richard
• 18:24   Re: Hardware/OS recommendations for large databases (5TB) Vivek Khera
• 19:00   Re: Help speeding up delete Simon Riggs
• 19:09   Re: Hardware/OS recommendations for large databases ( Scott Marlowe
• 19:29   Re: Help speeding up delete Steve Wampler
• 19:57   Re: Hardware/OS recommendations for large databases Ron
• 20:01   Perl DBD and an alarming problem Craig A. James
• 20:04   Re: Hardware/OS recommendations for large databases ( Ron Mayer
• 20:21   Re: Hardware/OS recommendations for large databases Ron
• 20:36   Re: Hardware/OS recommendations for large databases ( mudfoot@rawbw.com
• 20:50   Re: Hardware/OS recommendations for large databases (5TB) Claus Guttesen
• 21:59   PgPool and Postgresql sessions... Cristian Prieto
• 22:25   Re: Help speeding up delete Arjen van der Meijden
• 22:30   Re: Perl DBD and an alarming problem Greg Sabino Mullane
• 23:23   Re: Perl DBD and an alarming problem Michael Fuhr

17 November 2005

• 00:34   Re: Help speeding up delete Christopher Kings-Lynne
• 00:36   Re: Help speeding up delete Christopher Kings-Lynne
• 05:05   Strange query plan invloving a view Rich Doughty
• 08:19   Re: [pgsql-www] Help speeding up delete Magnus Hagander
• 10:20   Re: Help speeding up delete Steinar H. Gunderson
• 11:28   Re: Hardware/OS recommendations for large databases ( William Yu
• 13:34   Re: Hardware/OS recommendations for large databases (5TB) Vivek Khera
• 14:05   Re: [pgsql-www] Help speeding up delete Christopher Kings-Lynne
• 14:07   Re: Help speeding up delete Christopher Kings-Lynne
• 14:13   Re: [pgsql-www] Help speeding up delete Steve Wampler
• 14:39   Re: [pgsql-www] Help speeding up delete Magnus Hagander
• 14:56   Re: Help speeding up delete Scott Marlowe
• 16:25   Re: Help speeding up delete Steinar H. Gunderson
• 17:07   Re: Strange query plan invloving a view Tom Lane
• 18:48   Re: Hardware/OS recommendations for large databases ( Alex Turner
• 18:50   Re: Hardware/OS recommendations for large databases ( Alex Turner
• 18:54   Re: Hardware/OS recommendations for large databases ( Alex Turner
• 19:22   Re: Hardware/OS recommendations for large databases ( Merlin Moncure
• 19:29   Re: Hardware/OS recommendations for large databases ( David Boreham
• 19:34   unsubscribe Josel Malixi
• 19:38   Re: Hardware/OS recommendations for large databases ( William Yu
• 19:38   Re: Hardware/OS recommendations for large databases ( Joshua D. Drake
• 19:48   weird performances problem Guillaume Smet
• 19:58   Re: Hardware/OS recommendations for large databases ( Joshua Marsh
• 20:02   Re: Hardware/OS recommendations for large databases ( David Boreham
• 20:07   Re: Perl DBD and an alarming problem Craig A. James
• 20:23   Re: Hardware/OS recommendations for large databases ( William Yu
• 21:19   Re: weird performances problem Andrew Sullivan
• 22:29   Re: Perl DBD and an alarming problem Michael Fuhr
• 22:39   Re: weird performances problem Guillaume Smet
• 22:51   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 23:22   Re: weird performances problem Claus Guttesen

18 November 2005

• 00:35   Re: Help speeding up delete Ron Mayer
• 00:50   Re: Help speeding up delete Christopher Kings-Lynne
• 04:16   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 04:23   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 04:37   Re: Perl DBD and an alarming problem Michael Fuhr
• 05:08   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 11:58   Re: Hardware/OS recommendations for large databases ( Dave Cramer
• 12:00   Re: Hardware/OS recommendations for large databases ( Dave Cramer
• 12:22   Re: Hardware/OS recommendations for large databases ( Richard Huxton
• 13:56   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 14:24   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 14:36   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 14:41   Re: Hardware/OS recommendations for large databases Ron
• 15:00   Re: Hardware/OS recommendations for large databases ( Dave Cramer
• 15:09   Re: Hardware/OS recommendations for large databases ( Vivek Khera
• 15:12   Re: Hardware/OS recommendations for large databases ( Vivek Khera
• 15:15   Re: Hardware/OS recommendations for large databases ( Bill McGonigle
• 15:20   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 15:25   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 16:31   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 16:35   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 17:04   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 17:10   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 17:21   Re: Hardware/OS recommendations for large databases ( Alex Turner
• 17:41   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 18:30   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:30   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 18:31   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:40   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:42   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 18:42   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 18:43   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:43   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:43   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:43   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 18:43   Re: weird performances problem Andrew Sullivan
• 18:43   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:43   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 18:45   Re: Hardware/OS recommendations for large databases ( Dave Cramer
• 19:29   Re: Hardware/OS recommendations for large databases Ron
• 19:43   sort/limit across union all Marc Morin
• 19:43   Re: Help speeding up delete Leigh Dyer
• 19:43   ERROR: no value found for parameter 1 with JDBC and Explain Analyze Virag Saksena
• 22:46   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 23:04   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 23:06   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 23:06   Re: ERROR: no value found for parameter 1 with JDBC and Explain Analyze Tom Lane

19 November 2005

• 01:27   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 02:24   What is the max number of database I can create in an instance of pgsql? anon permutation
• 02:52   Re: What is the max number of database I can create in an instance of pgsql? Michael Glaesemann
• 03:55   Re: What is the max number of database I can create in an instance of pgsql? Jaime Casanova
• 09:51   VERY slow after many updates Alex Wang
• 10:12   Re: VERY slow after many updates Csaba Nagy
• 11:05   Re: VERY slow after many updates Alex Wang
• 11:12   Re: VERY slow after many updates Csaba Nagy
• 11:18   Re: VERY slow after many updates Guido Neitzer
• 11:30   Re: VERY slow after many updates Alex Wang
• 12:45   Re: What is the max number of database I can create in John McCawley
• 15:13   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 15:15   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 16:57   Storage/Performance and splitting a table Craig A. James
• 18:03   Re: Storage/Performance and splitting a table Michael Stone
• 19:45   Re: Perl DBD and an alarming problem Craig A. James
• 20:29   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood

20 November 2005

• 01:45   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 03:44   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 07:56   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 11:55   Re: Hardware/OS recommendations for large databases ( William Yu
• 12:25   Re: Hardware/OS recommendations for large databases ( Steinar H. Gunderson
• 12:43   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 13:22   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 13:30   Re: Hardware/OS recommendations for large databases ( Steinar H. Gunderson
• 17:10   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 20:48   Hyperthreading slows processes? Craig A. James
• 23:11   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood

21 November 2005

• 00:24   Re: Hyperthreading slows processes? Dave Cramer
• 00:41   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 07:13   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 13:57   Re: Hardware/OS recommendations for large databases ( Tom Lane
• 13:58   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 18:01   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 18:52   Re: Hardware/OS recommendations for large databases ( Alvaro Herrera
• 18:58   Re: Hardware/OS recommendations for large databases ( Bill McGonigle
• 18:59   Re: Hardware/OS recommendations for large databases ( Michael Stone
• 20:11   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 20:27   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 20:54   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 22:07   Re: VERY slow after many updates Scott Marlowe
• 22:44   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 22:54   Re: Hardware/OS recommendations for large databases ( Michael Stone

22 November 2005

• 03:36   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 04:10   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 06:20   Re: weird performances problem Qingqing Zhou
• 08:49   Re: weird performances problem Guillaume Smet
• 08:56   Re: weird performances problem Guillaume Smet
• 11:53   Re: weird performances problem Ron
• 12:29   Re: Strange query plan invloving a view Rich Doughty
• 13:26   Re: weird performances problem Guillaume Smet
• 13:27   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 13:29   System queue Marek Dabrowski
• 13:37   Re: weird performances problem Guillaume Smet
• 13:49   Re: weird performances problem Ron
• 14:26   Re: weird performances problem Guillaume Smet
• 15:50   Re: System queue Frank Wiles
• 16:00   High context switches occurring Anjan Dave
• 16:15   Re: High context switches occurring Vivek Khera
• 16:20   Re: weird performances problem Ron
• 16:34   Re: System queue Jeff Trout
• 16:35   Re: High context switches occurring Tom Lane
• 17:29   Stored Procedure Yves Vindevogel
• 17:43   Re: Stored Procedure Jim Buttafuoco
• 17:59   Re: Stored Procedure Michael Fuhr
• 18:23   Re: High context switches occurring Anjan Dave
• 18:41   Re: High context switches occurring Tom Lane
• 19:33   Re: High context switches occurring Anjan Dave
• 19:37   Re: High context switches occurring Scott Marlowe
• 19:38   Re: High context switches occurring Scott Marlowe
• 21:17   Re: Stored Procedure Yves Vindevogel
• 21:52   Re: Stored Procedure Yves Vindevogel
• 22:17   Re: High context switches occurring Anjan Dave
• 23:13   Re: Hardware/OS recommendations for large databases ( Bruce Momjian

23 November 2005

• 02:39   Binary Refcursor possible? Ralph Mason
• 02:58   Re: Hardware/OS recommendations for large databases ( Alan Stange
• 03:07   Re: Binary Refcursor possible? Tom Lane
• 03:14   Re: Binary Refcursor possible? Ralph Mason
• 03:21   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 03:53   Re: Hardware/OS recommendations for large databases ( Bruce Momjian
• 04:05   Re: Stored Procedure Michael Fuhr
• 04:13   Re: Stored Procedure Michael Fuhr
• 16:51   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 16:54   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 17:15   Re: High context switches occurring Simon Riggs
• 17:33   Re: High context switches occurring Anjan Dave
• 20:33   Re: High context switches occurring Anjan Dave
• 21:00   Re: Hardware/OS recommendations for large databases ( Alan Stange

24 November 2005

• 00:23   8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard
• 00:51   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 01:29   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 02:14   Re: 8.1 count(*) distinct: IndexScan/SeqScan Tom Lane
• 04:34   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 05:22   Re: 8.1 count(*) distinct: IndexScan/SeqScan andrew@pillette.com
• 07:18   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 07:53   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 08:11   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 08:23   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 08:24   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 08:26   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 10:54   Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard
• 10:54   Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard
• 11:41   xlog flush request error Vipul.Gupta@trilogy.com
• 12:06   Very slow queries - please help. Bealach-na Bo
• 12:23   Re: Very slow queries - please help. Claus Guttesen
• 12:53   Re: High context switches occurring Sven Geisler
• 13:36   Re: Very slow queries - please help. Bealach-na Bo
• 14:03   Re: Very slow queries - please help. Guillaume Smet
• 14:15   Re: Very slow queries - please help. Tom Lane
• 14:37   Re: xlog flush request error Tom Lane
• 15:00   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 15:25   Re: Hardware/OS recommendations for large databases ( Tom Lane
• 15:40   Re: Hardware/OS recommendations for large databases ( Greg Stark
• 16:08   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 17:14   Re: Very slow queries - please help Bealach-na Bo
• 17:51   Very slow queries - please help Bealach-na Bo
• 21:08   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 23:03   Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard

25 November 2005

• 01:37   Re: 8.1 count(*) distinct: IndexScan/SeqScan Tom Lane
• 03:21   Re: 8.1 count(*) distinct: IndexScan/SeqScan Kyle Cordes
• 03:50   Re: xlog flush request error Vipul.Gupta@trilogy.com
• 03:59   Re: xlog flush request error Tom Lane
• 10:40   Re: 8.1 count(*) distinct: IndexScan/SeqScan Steinar H. Gunderson
• 11:31   Re: 8.1 count(*) distinct: IndexScan/SeqScan Alvaro Herrera
• 13:47   Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard
• 18:36   Newbie question: ultra fast count(*) Rodrigo Madera
• 18:40   Re: Newbie question: ultra fast count(*) Jaime Casanova

26 November 2005

• 17:28   Open request for benchmarking input Jeff Frost
• 17:57   Re: Open request for benchmarking input Qingqing Zhou
• 19:17   Re: Open request for benchmarking input Luke Lonergan
• 19:31   Re: Open request for benchmarking input Ron
• 23:12   Re: Open request for benchmarking input Andreas Pflug

27 November 2005

• 03:40   Re: Open request for benchmarking input David Lang
• 03:40   Re: Open request for benchmarking input David Lang
• 04:47   Open request for benchmarking input David Lang
• 04:59   Re: Hardware/OS recommendations for large databases ( David Lang
• 05:28   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 05:42   Re: Hardware/OS recommendations for large databases ( David Lang
• 07:05   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 11:16   Re: Open request for benchmarking input Steinar H. Gunderson
• 11:21   Re: Open request for benchmarking input Andreas Pflug
• 14:48   Re: Hardware/OS recommendations for large databases ( Stephan Szabo
• 16:10   Re: Hardware/OS recommendations for large databases Ron
• 18:14   Re: Hardware/OS recommendations for large databases Luke Lonergan
• 18:38   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 19:25   Re: Hardware/OS recommendations for large databases Ron
• 21:16   Re: Open request for benchmarking input David Lang
• 23:07   Re: Hardware/OS recommendations for large databases ( Stephan Szabo

28 November 2005

• 12:31   Re: Newbie question: ultra fast count(*) Merlin Moncure
• 15:27   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 17:10   Re: Hardware/OS recommendations for large databases ( Merlin Moncure
• 20:45   Re: Hardware/OS recommendations for large databases ( Mark Kirkwood
• 21:07   Re: Hardware/OS recommendations for large databases ( Luke Lonergan
• 22:37   Please help with this explain analyse... David Gagnon
• 22:45   Re: Hardware/OS recommendations for large databases ( Brendan Duddridge
• 22:47   Re: Please help with this explain analyse... Bricklen Anderson
• 23:01   Re: Please help with this explain analyse... Tom Lane

29 November 2005

• 01:13   Re: Please help with this explain analyse... David Gagnon
• 02:19   Re: Hardware/OS recommendations for large databases ( Brendan Duddridge
• 02:30   Re: Hardware/OS recommendations for large databases ( David Boreham
• 04:48   Re: Hardware/OS recommendations for large databases ( David Lang
• 04:50   Re: Hardware/OS recommendations for large databases ( David Lang
• 06:34   index auto changes after copying data ? energumen@buaa.edu.cn
• 11:17   Re: index auto changes after copying data ? Richard Huxton
• 18:04   Re: index auto changes after copying data ? Chris Browne

30 November 2005

• 11:37   pg_dump slow Franklin Haut
• 12:56   Re: pg_dump slow Ron
• 14:23   RES: pg_dump slow Franklin Haut
• 16:22   Re: pg_dump slow Merlin Moncure
• 16:38   Re: RES: pg_dump slow Richard Huxton
• 18:22   Select with grouping plan question Brad Might
• 19:39   RES: pg_dump slow Franklin Haut
• 19:41   Re: Select with grouping plan question Tom Lane
• 20:05   Re: RES: pg_dump slow Ron
• 21:13   Re: RES: pg_dump slow Merlin Moncure