Mailing lists [pgsql-performance]

1 March 2008

• 00:39   Re: t1.col like '%t2.col%' Joshua D. Drake
• 01:10   Re: t1.col like '%t2.col%' Tom Lane
• 03:57   Re: 12 disks raid setup Greg Smith
• 09:28   Re: 12 disks raid setup Franck Routier
• 11:44   Re: 12 disks raid setup Scott Marlowe
• 17:11   Re: 12 disks raid setup Tom Lane
• 17:13   How to allocate 8 disks Craig James
• 17:17   Re: multi-threaded pgloader needs your tests Simon Riggs
• 17:48   Re: How to allocate 8 disks Scott Marlowe
• 20:03   Re: How to allocate 8 disks Joshua D. Drake
• 20:53   Re: How to allocate 8 disks Craig James
• 21:30   Re: How to allocate 8 disks Scott Marlowe

2 March 2008

• 03:17   Re: 12 disks raid setup Greg Smith
• 03:51   Re: How to allocate 8 disks Greg Smith
• 06:37   How to choose a disc array for Postgresql? Steve Poe
• 07:05   Re: How to choose a disc array for Postgresql? Joshua D. Drake
• 13:27   Re: How to choose a disc array for Postgresql? Luke Lonergan

3 March 2008

• 02:11   Re: How to choose a disc array for Postgresql? Vivek Khera
• 03:02   Re: How to choose a disc array for Postgresql? Steve Poe
• 03:14   Re: How to choose a disc array for Postgresql? Joshua D. Drake
• 03:23   Re: How to choose a disc array for Postgresql? Scott Marlowe
• 04:16   Re: How to choose a disc array for Postgresql? Greg Smith
• 11:11   Re: How to allocate 8 disks Matthew
• 13:25   which is more important? freq of checkpoints or the duration of them? Douglas J Hunley
• 13:33   Re: How to choose a disc array for Postgresql? Vivek Khera
• 13:34   Re: How to choose a disc array for Postgresql? Vivek Khera
• 13:50   Re: How to allocate 8 disks Mark Mielke
• 13:53   Re: How to allocate 8 disks Craig James
• 13:57   Re: How to allocate 8 disks Matthew
• 14:02   Re: How to choose a disc array for Postgresql? Vivek Khera
• 14:07   Re: How to allocate 8 disks Mark Mielke
• 14:16   Re: which is more important? freq of checkpoints or the duration of them? Scott Marlowe
• 14:18   Performance problems deleting data Rafael Martinez
• 14:22   Re: How to allocate 8 disks Scott Marlowe
• 15:14   Re: which is more important? freq of checkpoints or the duration of them? Chris Browne
• 15:40   Re: which is more important? freq of checkpoints or the duration of them? Greg Smith
• 16:06   Re: which is more important? freq of checkpoints or the duration of them? Greg Smith
• 16:25   Re: Performance problems deleting data Tom Lane
• 18:45   Re: How to choose a disc array for Postgresql? Ron Mayer
• 22:39   Performance tuning on FreeBSD alan bryan
• 23:26   Re: Performance tuning on FreeBSD Bill Moran
• 23:34   Re: Performance tuning on FreeBSD alan bryan

4 March 2008

• 00:11   Re: Performance tuning on FreeBSD Greg Smith
• 07:28   Re: Performance problems deleting data Rafael Martinez
• 08:16   Re: Performance tuning on FreeBSD alan bryan
• 09:22   Re: Performance tuning on FreeBSD Greg Smith
• 09:42   Re: How to allocate 8 disks Ivan Voras
• 09:50   Re: Performance tuning on FreeBSD Ivan Voras
• 10:57   Re: Performance problems deleting data Alvaro Herrera
• 13:04   Re: Performance tuning on FreeBSD Ivan Voras
• 13:13   Re: Performance tuning on FreeBSD Matthew
• 13:49   Ramifications of turning off Nested Loops for slow queries Chris Kratz
• 14:04   Re: How to allocate 8 disks Shane Ambler
• 15:12   PostgreSQL performance on a virtual host Theo Kramer
• 15:19   Re: Ramifications of turning off Nested Loops for slow queries Kevin Grittner
• 15:25   Re: Performance tuning on FreeBSD Greg Smith
• 16:19   Re: Ramifications of turning off Nested Loops for slow queries Tom Lane
• 17:20   Re: Ramifications of turning off Nested Loops for slow queries Chris Kratz
• 17:42   Re: Ramifications of turning off Nested Loops for slow queries Chris Kratz
• 19:55   Optimisation help dforums
• 20:03   Re: Optimisation help Alan Hodgson
• 21:44   Re: Optimisation help dforums
• 21:49   Re: Optimisation help dforums
• 21:59   Re: Optimisation help Greg Smith
• 22:12   Re: Optimisation help dforums
• 22:29   Re: Optimisation help dforums
• 22:34   Re: Optimisation help Steinar H. Gunderson
• 23:19   Re: Optimisation help Erik Jones

5 March 2008

• 07:25   Re: Optimisation help dforums
• 07:55   Re: PostgreSQL performance on a virtual host Moritz Onken
• 09:27   postgresql performance SPMLINGAM
• 09:40   Re: postgresql performance Steinar H. Gunderson
• 09:44   Confirmação de envio / Sending confirmation (captchaid:13266b111e1d) petchimuthu lingam
• 09:52   Re: postgresql performance Franck Routier
• 10:03   Re: postgresql performance Claus Guttesen
• 11:42   Re: PostgreSQL performance on a virtual host Dave Cramer
• 13:26   Re: PostgreSQL performance on a virtual host Ivan Zolotukhin
• 13:40   Re: PostgreSQL performance on a virtual host Bill Moran
• 14:03   Re: PostgreSQL performance on a virtual host Ivan Zolotukhin
• 14:09   Re: postgresql performance Dave Dutcher
• 14:46   Re: postgresql performance Kevin Grittner
• 15:02   Re: postgresql performance Bill Moran
• 23:27   Why the difference in plans ? Dave Cramer

6 March 2008

• 03:48   Confirmação de envio / Sending confirmation (captchaid:13266b1124bc) petchimuthu lingam
• 03:54   Confirmação de envio / Sending confirmation (captchaid:13266b203c28) petchimuthu lingam
• 04:09   Confirmação de envio / Sending confirmation (captchaid:13266b203e23) petchimuthu lingam
• 04:17   Confirmação de envio / Sending confirmation (captchaid:13266b20536d) petchimuthu lingam
• 04:43   count * performance issue sathiya psql
• 04:48   Re: Confirmação de envio / Sending confirmation (captchaid:13266b20536d) Chris
• 04:50   Re: count * performance issue Chris
• 04:57   Confirmação de envio / Sending confirmation (captchaid:13266b2056e4) petchimuthu lingam
• 05:08   Re: count * performance issue A. Kretschmer
• 05:10   postgresql Explain command output RaviRam Kolipaka
• 05:15   Re: count * performance issue Shoaib Mir
• 05:19   Re: count * performance issue sathiya psql
• 05:26   Re: count * performance issue Shoaib Mir
• 05:29   Re: count * performance issue Mark Mielke
• 05:31   Re: count * performance issue sathiya psql
• 05:32   Re: count * performance issue Shoaib Mir
• 05:36   Re: count * performance issue A. Kretschmer
• 05:43   Re: count * performance issue sathiya psql
• 05:48   Fwd: count * performance issue sathiya psql
• 05:54   Re: count * performance issue A. Kretschmer
• 05:58   Re: count * performance issue A. Kretschmer
• 06:02   oid...any optimizations sathiya psql
• 06:06   Re: count * performance issue sathiya psql
• 06:07   Re: oid...any optimizations Joshua D. Drake
• 06:14   Re: oid...any optimizations sathiya psql
• 06:18   Re: count * performance issue A. Kretschmer
• 06:22   Re: oid...any optimizations Theo Kramer
• 07:16   index usage makes problem sathiya psql
• 10:50   Re: count * performance issue Dave Cramer
• 11:14   Re: count * performance issue Dave Cramer
• 11:43   Re: count * performance issue sathiya psql
• 11:48   Re: count * performance issue Harald Armin Massa
• 11:49   Re: count * performance issue A. Kretschmer
• 11:50   Re: count * performance issue Alvaro Herrera
• 12:10   Re: postgresql Explain command output Greg Smith
• 12:14   Re: count * performance issue Mark Mielke
• 12:18   Re: count * performance issue Greg Smith
• 12:27   Re: count * performance issue Greg Smith
• 12:31   Re: postgresql Explain command output Tom Lane
• 12:43   Re: postgresql Explain command output Greg Smith
• 14:29   Re: count * performance issue Craig James
• 14:33   Re: count * performance issue Bruce Momjian
• 14:36   Re: count * performance issue Steinar H. Gunderson
• 14:41   Re: count * performance issue Bill Moran
• 14:49   Re: count * performance issue Greg Smith
• 15:06   Re: count * performance issue Dave Page
• 15:27   Re: count * performance issue Mark Lewis
• 15:29   Re: oid...any optimizations Joshua D. Drake
• 15:31   Re: count * performance issue D'Arcy J.M. Cain
• 16:23   Re: Performance of aggregates over set-returning functions Bruce Momjian
• 16:26   Re: Why the difference in plans ? Josh Berkus
• 16:29   Re: count * performance issue Tom Lane
• 16:53   Re: Performance of aggregates over set-returning functions Tom Lane
• 17:01   Re: Performance of aggregates over set-returning functions Bruce Momjian
• 17:56   Re: Why the difference in plans ? Dave Cramer
• 20:38   Re: More shared buffers causes lower performances Bruce Momjian
• 21:11   Re: Why the difference in plans ? Stephen Denne

7 March 2008

• 01:16   Re: Why the difference in plans ? Dave Cramer
• 01:30   Re: Why the difference in plans ? Stephen Denne
• 01:56   Re: count * performance issue Mark Kirkwood
• 02:00   Re: count * performance issue Craig James
• 03:31   Improve Full text rank in a query b wragg
• 04:18   database design for large data. 
• 04:38   Re: count * performance issue paul rivers
• 04:40   Re: Improve Full text rank in a query Tom Lane
• 04:52   Nested loop vs merge join: inconsistencies between estimated and actual time Vlad Arkhipov
• 05:35   Re: Nested loop vs merge join: inconsistencies between estimated and actual time Tom Lane
• 07:35   Toast space grows Pavel Rotek
• 07:44   Re: Improve Full text rank in a query Oleg Bartunov
• 08:13   Re: Toast space grows Richard Huxton
• 08:29   Re: Toast space grows Pavel Rotek
• 10:21   Re: Why the difference in plans ? Dave Cramer
• 10:22   Re: Why the difference in plans ? Dave Cramer
• 10:53   Re: Toast space grows Bill Moran
• 11:59   Re: postgresql Explain command output RaviRam Kolipaka
• 12:00   Re: Toast space grows Pavel Rotek
• 12:19   Re: Toast space grows Alvaro Herrera
• 12:33   Re: Toast space grows Tom Lane
• 12:55   Re: Toast space grows Matthew
• 13:12   Re: Toast space grows Pavel Rotek
• 13:18   Re: Toast space grows Matthew
• 13:22   Re: Toast space grows Pavel Rotek
• 13:28   Re: Toast space grows Pavel Rotek
• 13:31   Re: Toast space grows Tom Lane
• 13:35   Re: Toast space grows Bill Moran
• 14:03   Re: Toast space grows Pavel Rotek
• 18:21   Re: Effects of cascading references in foreign keys Bruce Momjian
• 22:51   Re: count * performance issue Mark Kirkwood

8 March 2008

• 00:20   Re: Why the difference in plans ? Josh Berkus
• 00:24   Re: count * performance issue Josh Berkus
• 00:42   Re: count * performance issue Tom Lane
• 03:07   join query performance petchimuthu lingam
• 03:16   Confirmação de envio / Sending confirmation (captchaid:13266b402bd3) petchimuthu lingam
• 03:33   Re: Confirmação de envio / Sending confirmation (captchaid:13266b402f09) petchimuthu lingam
• 04:08   Re: count * performance issue Greg Smith
• 04:31   Re: count * performance issue Mark Mielke
• 05:13   Re: count * performance issue Tom Lane
• 06:11   Re: count * performance issue paul rivers
• 07:10   Re: count * performance issue Arjen van der Meijden
• 13:18   Re: Re: Confirmaçã de envio / Sending confirmation(captchaid:13266b402f09) Alvaro Herrera
• 16:31   Joins and DELETE FROM Kynn Jones
• 17:02   Re: Joins and DELETE FROM Heikki Linnakangas
• 18:02   Re: Joins and DELETE FROM Kynn Jones
• 19:08   Re: Joins and DELETE FROM Tom Lane
• 19:26   Re: Joins and DELETE FROM Heikki Linnakangas

10 March 2008

• 02:28   UPDATE 66k rows too slow Miguel Arroz
• 04:15   Re: UPDATE 66k rows too slow andrew@pillette.com
• 04:49   Re: UPDATE 66k rows too slow Tom Lane
• 05:10   Re: UPDATE 66k rows too slow Greg Smith
• 09:31   Utility functions for enabling/disabling fkey triggers Craig Ringer
• 09:56   Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Craig Ringer
• 11:01   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Heikki Linnakangas
• 11:29   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Craig Ringer
• 12:16   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Craig Ringer
• 14:34   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Tom Lane
• 14:49   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Craig Ringer
• 14:53   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Heikki Linnakangas
• 15:03   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Tom Lane
• 15:03   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Heikki Linnakangas
• 15:10   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Craig Ringer
• 15:16   Re: count * performance issue Gregory Stark
• 15:20   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Tom Lane
• 16:08   Re: multi-threaded pgloader needs your tests Dimitri Fontaine
• 17:16   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Rainer Pruy
• 20:54   Re: count * performance issue Joe Mirabal
• 21:28   Re: count * performance issue Bill Moran
• 21:52   Re: count * performance issue Greg Smith
• 21:59   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Simon Riggs
• 22:28   Re: count * performance issue Scott Marlowe
• 23:01   Re: count * performance issue Greg Smith
• 23:18   Re: UPDATE 66k rows too slow Miguel Arroz
• 23:22   Re: UPDATE 66k rows too slow Joshua D. Drake
• 23:46   Re: UPDATE 66k rows too slow Miguel Arroz
• 23:56   Re: UPDATE 66k rows too slow Joshua D. Drake

11 March 2008

• 00:34   Re: UPDATE 66k rows too slow Miguel Arroz
• 01:52   Re: Nested loop vs merge join: inconsistencies between estimated and actual time Vlad Arkhipov
• 02:57   Re: count * performance issue Robins Tharakan
• 03:02   Re: count * performance issue Mark Mielke
• 03:08   Re: count * performance issue Joshua D. Drake
• 03:11   Re: count * performance issue Scott Marlowe
• 04:14   Re: UPDATE 66k rows too slow Greg Smith
• 06:24   Re: Very slow (2 tuples/second) sequential scan after bulk insert; speed returns to ~500 tuples/second after commit Pavan Deolasee
• 08:41   Re: count * performance issue Albert Cervera Areny
• 09:58   Re: Very slow (2 tuples/second) sequential scan afterbulk insert; speed returns to ~500 tuples/second after commit Heikki Linnakangas
• 12:28   how many index can have???? petchimuthu lingam
• 13:36   Re: count * performance issue Bill Moran
• 13:38   list user created triggers sathiya psql
• 13:47   Re: how many index can have???? Dave Cramer
• 13:55   Re: count * performance issue Matthew
• 14:02   Re: count * performance issue Tino Wildenhain
• 14:18   Re: count * performance issue Matthew
• 14:31   Re: count * performance issue Heikki Linnakangas
• 14:35   Re: count * performance issue Andrew Sullivan
• 15:57   Re: Joins and DELETE FROM Kynn Jones
• 16:05   Re: how many index can have???? Craig Ringer

12 March 2008

• 04:08   Re: list user created triggers sathiya psql
• 05:17   Re: list user created triggers sathiya psql
• 05:27   migration of 7.4 to 8.1 sathiya psql
• 05:33   Re: migration of 7.4 to 8.1 Craig Ringer
• 06:24   Re: migration of 7.4 to 8.1 sathiya psql
• 06:29   Re: migration of 7.4 to 8.1 sathiya psql
• 06:31   Re: migration of 7.4 to 8.1 Chris
• 06:33   Re: migration of 7.4 to 8.1 Craig Ringer
• 06:36   Re: migration of 7.4 to 8.1 sathiya psql
• 06:37   Re: migration of 7.4 to 8.1 Craig Ringer
• 06:43   Re: migration of 7.4 to 8.1 sathiya psql
• 06:48   Re: migration of 7.4 to 8.1 david@lang.hm
• 06:49   Re: migration of 7.4 to 8.1 Craig Ringer
• 06:50   Re: migration of 7.4 to 8.1 david@lang.hm
• 06:57   Re: migration of 7.4 to 8.1 david@lang.hm
• 07:08   Re: migration of 7.4 to 8.1 Chris
• 07:22   Re: migration of 7.4 to 8.1 sathiya psql
• 09:19   Re: migration of 7.4 to 8.1 Steinar H. Gunderson
• 14:46   Re: migration of 7.4 to 8.1 Vivek Khera
• 15:25   8.3 write performance Enrico Sirola
• 18:58   Hardware question for a DB server Pascal Cohen
• 19:16   Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 Bruce Momjian
• 19:26   Re: Hardware question for a DB server Mark Lewis
• 19:49   Re: Hardware question for a DB server Pascal Cohen
• 20:08   Re: Hardware question for a DB server Greg Smith
• 20:38   Are piped columns indexable Mark Steben
• 20:55   Re: Are piped columns indexable Merlin Moncure

13 March 2008

• 03:38   Repeated execution of identical subqueries Craig Ringer
• 04:55   Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig James
• 05:13   Re: Repeated execution of identical subqueries Tom Lane
• 05:31   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Scott Marlowe
• 05:55   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Joshua D. Drake
• 06:35   Re: Repeated execution of identical subqueries Craig Ringer
• 07:21   partial index + select query performance petchimuthu lingam
• 07:34   Re: partial index + select query performance A. Kretschmer
• 08:12   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin Graf
• 12:35   Recomendations on raid controllers raid 1+0 Glyn Astill
• 12:39   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Doug Knight
• 13:24   ER diagram tool sathiya psql
• 13:33   Re: ER diagram tool A. Kretschmer
• 13:38   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Will Weaver
• 13:56   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin Graf
• 14:06   Re: Repeated execution of identical subqueries Craig James
• 14:29   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig James
• 14:37   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig James
• 14:54   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig James
• 15:58   Re: Recomendations on raid controllers raid 1+0 Guillaume Smet
• 16:02   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Greg Smith
• 16:11   Re: Recomendations on raid controllers raid 1+0 Glyn Astill
• 19:43   Re: ER diagram tool Andrej Ricnik-Bay
• 20:10   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 justin
• 21:06   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Joshua D. Drake
• 21:27   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Greg Smith
• 21:54   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 justin
• 22:17   temp tables James Mansion
• 23:42   Re: Recomendations on raid controllers raid 1+0 Leigh Dyer

14 March 2008

• 00:02   Re: temp tables Tom Lane
• 05:53   Re: Recomendations on raid controllers raid 1+0 Scott Marlowe
• 06:09   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Scott Marlowe
• 06:12   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Scott Marlowe
• 06:19   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Scott Marlowe
• 06:23   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Scott Marlowe
• 06:29   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Jesper Krogh
• 06:35   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Jesper Krogh
• 07:32   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 08:19   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Greg Smith
• 09:51   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 10:17   Re: 8.3 write performance Enrico Sirola
• 10:26   Re: ER diagram tool Jurgen Haan
• 11:35   Re: ER diagram tool sathiya psql
• 13:50   Lots of "semop" calls under load Albe Laurenz
• 16:17   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Michael Stone
• 16:34   Re: Lots of "semop" calls under load Tom Lane
• 17:20   Adaptec 5805 SAS Raid Glyn Astill
• 18:05   The "many nulls" problem Kynn Jones
• 18:59   Re: The "many nulls" problem Oleg Bartunov
• 19:24   Re: Hardware question for a DB server Pascal Cohen
• 19:43   Re: Hardware question for a DB server Scott Marlowe
• 19:46   Re: The "many nulls" problem Heikki Linnakangas
• 20:05   Re: The "many nulls" problem Kynn Jones
• 20:06   Re: The "many nulls" problem Kynn Jones
• 20:31   Re: The "many nulls" problem Oleg Bartunov
• 21:09   Re: Anyone using a SAN? Peter Koczan
• 22:39   Re: Adaptec 5805 SAS Raid Leigh Dyer

15 March 2008

• 00:25   best way to run maintenance script Vinubalaji Gopal
• 00:32   Re: best way to run maintenance script Joshua D. Drake
• 00:52   Re: best way to run maintenance script Vinubalaji Gopal
• 01:37   Re: best way to run maintenance script Tom Lane
• 02:17   Re: best way to run maintenance script Joshua D. Drake
• 03:28   Re: best way to run maintenance script Vinubalaji Gopal
• 04:08   Re: best way to run maintenance script Vinubalaji Gopal
• 12:46   Re: best way to run maintenance script Gregory Stark

16 March 2008

• 05:20   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 06:12   What is the best way to storage music files in Postgresql Rich
• 06:20   Re: What is the best way to storage music files in Postgresql Craig James
• 06:25   Re: What is the best way to storage music files in Postgresql Craig Ringer
• 11:25   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Dave Cramer
• 18:12   Re: best way to run maintenance script Peter Eisentraut
• 19:05   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig James
• 19:08   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig James
• 20:19   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Dave Cramer
• 20:56   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Scott Marlowe

17 March 2008

• 06:41   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 10:37   Re: Lots of "semop" calls under load Albe Laurenz
• 10:37   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Tino Wildenhain
• 10:42   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Andrej Ricnik-Bay
• 10:47   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig Ringer
• 12:08   performance tools sathiya psql
• 15:38   Re: performance tools Mark Steben
• 15:45   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 15:59   Re: performance tools sathiya psql
• 16:25   Re: performance tools Ben Chobot
• 18:28   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Dave Cramer
• 18:29   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 18:29   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 18:29   Re: What is the best way to storage music files in Postgresql Peter Koczan
• 18:44   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Craig James
• 18:50   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Justin
• 18:50   Re: What is the best way to storage music files in Postgresql Rich
• 18:52   Re: What is the best way to storage music files in Postgresql Rich
• 21:44   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Enrico Sirola
• 22:27   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Scott Marlowe
• 22:31   Re: performance tools Andrej Ricnik-Bay
• 23:47   Re: TB-sized databases Bruce Momjian

18 March 2008

• 00:29   Re: TB-sized databases Tom Lane
• 00:43   Re: TB-sized databases Bruce Momjian
• 01:30   Re: TB-sized databases Pablo Alcaraz
• 02:56   Re: performance tools Franck Routier
• 03:26   Re: What is the best way to storage music files in Postgresql Peter Koczan
• 05:48   Re: TB-sized databases Ron Mayer
• 07:05   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 James Mansion
• 09:14   Re: What is the best way to storage music files in Postgresql Andrej Ricnik-Bay
• 09:59   Re: What is the best way to storage music files in Postgresql Craig Ringer
• 14:49   Re: TB-sized databases Tom Lane
• 15:42   Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Michael Stone
• 15:42   Planner mis-estimation using nested loops followup Chris Kratz
• 15:50   Re: Planner mis-estimation using nested loops followup Joshua D. Drake
• 15:58   Re: Planner mis-estimation using nested loops followup Chris Kratz
• 16:22   Re: Planner mis-estimation using nested loops followup Matthew
• 17:33   Re: TB-sized databases Ron Mayer
• 17:45   Re: What is the best way to storage music files in Postgresql Andrej Ricnik-Bay
• 18:01   Re: What is the best way to storage music files in Postgresql david@lang.hm
• 19:46   Re: Planner mis-estimation using nested loops followup Scott Marlowe
• 19:57   Re: What is the best way to storage music files in Postgresql david@lang.hm
• 20:03   Re: What is the best way to storage music files in Postgresql Gregory Stark
• 21:07   question on TRUNCATE vs VACUUM FULL Mark Steben
• 21:27   Re: Planner mis-estimation using nested loops followup Stephen Denne
• 22:45   Re: What is the best way to storage music files in Postgresql Craig Ringer
• 22:52   Re: What is the best way to storage music files in Postgresql Craig Ringer
• 23:06   Re: What is the best way to storage music files in Postgresql david@lang.hm

19 March 2008

• 00:01   Re: Planner mis-estimation using nested loops followup KC ESL
• 00:30   Re: What is the best way to storage music files in Postgresql Gregory Stark
• 00:32   Re: What is the best way to storage music files in Postgresql Craig Ringer
• 01:13   Re: question on TRUNCATE vs VACUUM FULL Chris
• 01:14   Re: What is the best way to storage music files in Postgresql Craig Ringer
• 01:17   Re: TB-sized databases Ron Mayer
• 05:53   Re: What is the best way to storage music files in Postgresql Gregory Youngblood
• 11:18   PG writes a lot to the disk Laurent Raufaste
• 13:23   Re: question on TRUNCATE vs VACUUM FULL Mark Steben
• 13:34   Re: question on TRUNCATE vs VACUUM FULL Bill Moran
• 13:37   Re: question on TRUNCATE vs VACUUM FULL Alvaro Herrera
• 13:41   Re: What is the best way to storage music files in Postgresql Gregory Youngblood
• 13:43   Re: question on TRUNCATE vs VACUUM FULL Mark Steben
• 13:49   Re: PG writes a lot to the disk Bill Moran
• 13:56   Re: question on TRUNCATE vs VACUUM FULL Bill Moran
• 14:16   Re: PG writes a lot to the disk Greg Smith
• 15:20   Re: PG writes a lot to the disk Albe Laurenz
• 19:01   Windows XP 64 bit Campbell, Lance

20 March 2008

• 03:16   Re: Anyone using a SAN? Peter Koczan
• 10:48   Re: PG writes a lot to the disk Laurent Raufaste
• 14:38   Re: PG writes a lot to the disk Albe Laurenz
• 14:58   Re: PG writes a lot to the disk Bill Moran
• 15:21   Re: PG writes a lot to the disk Tom Lane
• 19:39   PostgreSQL NetApp and NFS Chris Hoover
• 20:34   Re: PG writes a lot to the disk Kris Jurka
• 20:46   Re: PostgreSQL NetApp and NFS Bruce Momjian
• 20:48   Re: PostgreSQL NetApp and NFS Woody Woodring
• 21:24   Re: PostgreSQL NetApp and NFS Frits Hoogland
• 21:52   Re: PostgreSQL NetApp and NFS Tom Lane

21 March 2008

• 03:30   Re: PostgreSQL NetApp and NFS Bruce Momjian
• 03:41   Re: PostgreSQL NetApp and NFS Tom Lane
• 09:34   Re: PostgreSQL NetApp and NFS Dawid Kuroczko
• 10:49   Re: PG writes a lot to the disk Laurent Raufaste
• 13:22   Re: PostgreSQL NetApp and NFS Gregory Stark
• 13:25   Re: PG writes a lot to the disk Gregory Stark
• 13:45   Re: PG writes a lot to the disk Laurent Raufaste
• 13:54   Re: PG writes a lot to the disk Bill Moran
• 14:23   Re: PostgreSQL NetApp and NFS Bruce Momjian

22 March 2008

• 01:44   Re: Linux/PostgreSQL scalability issue - problem with 8 cores Bruce Momjian
• 04:10   Having MANY MANY empty columns in database sathiya psql
• 08:24   Re: Having MANY MANY empty columns in database Craig Ringer
• 09:08   Re: Having MANY MANY empty columns in database sathiya psql
• 14:02   Views and functions returning sets of records Giorgio Valoti
• 16:31   Re: Views and functions returning sets of records Andreas Kretschmer
• 16:34   Re: Views and functions returning sets of records Tom Lane
• 16:51   Re: Views and functions returning sets of records Andreas Kretschmer

23 March 2008

• 09:37   Re: Views and functions returning sets of records Giorgio Valoti
• 15:29   Re: Views and functions returning sets of records Tom Lane

24 March 2008

• 07:40   slow pg_connect() 
• 07:41   Turn correlated in subquery into join Dennis Bjorklund
• 07:58   Re: slow pg_connect() Craig Ringer
• 08:04   Re: slow pg_connect() Craig Ringer
• 08:42   Re: slow pg_connect() vincent
• 09:28   increasing shared buffer slow downs query performance. petchimuthu lingam
• 10:03   Re: increasing shared buffer slow downs query performance. Andreas Kretschmer
• 10:53   Re: slow pg_connect() Tommy Gildseth
• 12:39   Re: slow pg_connect() Thomas Pundt
• 13:06   waiting for harddisk petchimuthu lingam
• 13:17   Re: waiting for harddisk PFC
• 16:30   Re: Turn correlated in subquery into join Tom Lane
• 20:23   Planning hot/live backups? Steve Poe
• 20:40   Re: Planning hot/live backups? Campbell, Lance
• 20:57   Re: Planning hot/live backups? Matthew T. O'Connor
• 21:21   Re: Planning hot/live backups? paul rivers
• 22:23   Re: Planning hot/live backups? Tom Lane
• 22:28   Re: Planning hot/live backups? Matthew T. O'Connor
• 22:49   Re: Planning hot/live backups? Steve Poe
• 23:45   Re: Planning hot/live backups? Miguel Arroz

25 March 2008

• 01:13   Re: waiting for harddisk Scott Marlowe
• 04:20   Re: slow pg_connect() Chris
• 04:50   Re: Planning hot/live backups? Matthew T. O'Connor
• 08:35   postgresql is slow with larger table even it is in RAM sathiya psql
• 08:43   Re: postgresql is slow with larger table even it is in RAM sathiya psql
• 09:08   Re: postgresql is slow with larger table even it is in RAM hubert depesz lubaczewski
• 09:35   Re: postgresql is slow with larger table even it is in RAM Craig Ringer
• 11:42   what is the maximum number of rows in a table in postgresql 8.1 sathiya psql
• 11:48   Re: what is the maximum number of rows in a table in postgresql 8.1 Harald Armin Massa
• 11:54   Re: what is the maximum number of rows in a table in postgresql 8.1 sathiya psql
• 11:59   Re: postgresql is slow with larger table even it is in RAM Alvaro Herrera
• 12:01   Re: what is the maximum number of rows in a table in postgresql 8.1 Alvaro Herrera
• 12:09   Re: what is the maximum number of rows in a table in postgresql 8.1 sathiya psql
• 12:24   Re: increasing shared buffer slow downs query performance. Pavan Deolasee
• 12:24   Re: what is the maximum number of rows in a table in postgresql 8.1 Craig Ringer
• 12:50   Re: what is the maximum number of rows in a table in postgresql 8.1 sathiya psql
• 13:09   Re: what is the maximum number of rows in a table in postgresql 8.1 Craig Ringer
• 13:10   Re: postgresql is slow with larger table even it is in RAM Bill Moran
• 13:17   Re: what is the maximum number of rows in a table in postgresql 8.1 Ivan Voras
• 13:27   Re: postgresql is slow with larger table even it is in RAM sathiya psql
• 13:33   Re: PostgreSQL NetApp and NFS Jurgen Haan
• 13:34   Re: what is the maximum number of rows in a table in postgresql 8.1 Bill Moran
• 14:03   Re: postgresql is slow with larger table even it is in RAM Bill Moran
• 14:47   Re: postgresql is slow with larger table even it is in RAM Luke Lonergan
• 15:11   Re: postgresql is slow with larger table even it is in RAM sathiya psql
• 15:21   Re: postgresql is slow with larger table even it is in RAM Chris Browne
• 18:06   Preparing statements on connection startup PFC

26 March 2008

• 12:21   Re: what is the maximum number of rows in a table in postgresql 8.1 Matthew
• 14:51   1-/2-dimensional indexes for common columns, rationale? Marinos Yannikos
• 15:02   Re: 1-/2-dimensional indexes for common columns, rationale? A. Kretschmer
• 15:14   Re: 1-/2-dimensional indexes for common columns, rationale? Matthew
• 15:15   Re: 1-/2-dimensional indexes for common columns, rationale? Marinos Yannikos
• 15:25   Re: 1-/2-dimensional indexes for common columns, rationale? A. Kretschmer
• 15:27   Re: 1-/2-dimensional indexes for common columns, rationale? Craig Ringer
• 16:21   Re: 1-/2-dimensional indexes for common columns, rationale? PFC
• 18:37   Query Optimization Gopinath Narasimhan
• 19:48   how can a couple of expensive queries drag my system down? p prince
• 19:50   vacuum in Postgresql 8.0.x slowing down the database Vinubalaji Gopal
• 20:02   Re: vacuum in Postgresql 8.0.x slowing down the database Joshua D. Drake
• 20:17   Re: how can a couple of expensive queries drag my system down? Alan Hodgson
• 20:31   Re: how can a couple of expensive queries drag my system down? Scott Marlowe
• 21:55   Re: how can a couple of expensive queries drag my system down? PFC
• 23:49   Re: postgresql is slow with larger table even it is in RAM Peter Koczan

27 March 2008

• 04:09   Re: how can a couple of expensive queries drag my system down? Shane Ambler
• 04:57   Re: how can a couple of expensive queries drag my system down? Scott Marlowe
• 15:13   Re: how can a couple of expensive queries drag my system down? Erik Jones
• 15:35   "Slow" query or just "Bad hardware"? Jesper Krogh
• 16:03   Re: "Slow" query or just "Bad hardware"? Matthew
• 16:42   Re: "Slow" query or just "Bad hardware"? PFC
• 16:54   Re: "Slow" query or just "Bad hardware"? PFC
• 17:08   Re: "Slow" query or just "Bad hardware"? Bill Moran
• 17:33   Re: postgresql is slow with larger table even it is in RAM Luke Lonergan
• 17:37   Re: "Slow" query or just "Bad hardware"? Luke Lonergan
• 17:54   Re: "Slow" query or just "Bad hardware"? Alvaro Herrera
• 19:14   using like in a prepare doesnt' use the right index Dave Cramer

28 March 2008

• 06:29   Re: vacuum in Postgresql 8.0.x slowing down the database Vinubalaji Gopal
• 09:22   Planning a new server - help needed Laszlo Nagy
• 10:04   Re: Planning a new server - help needed Claus Guttesen
• 10:06   Re: Planning a new server - help needed Reko Turja
• 10:47   Re: Planning a new server - help needed Laszlo Nagy
• 14:54   Re: using like in a prepare doesnt' use the right index Gavin Sherry
• 17:42   Re: Planning a new server - help needed Greg Smith
• 18:58   Re: Planning a new server - help needed Dan Harris

29 March 2008

• 00:46   Re: Planning a new server - help needed Weinzierl Stefan
• 10:30   Re: Planning a new server - help needed James Mansion
• 13:54   Re: Planning a new server - help needed PFC
• 16:44   Re: Planning a new server - help needed James Mansion
• 23:49   Re: Planning a new server - help needed Peter Eisentraut

30 March 2008

• 04:45   Re: Planning a new server - help needed Greg Smith
• 05:40   Re: Planning a new server - help needed Craig Ringer

31 March 2008

• 03:15   Re: Planning a new server - help needed Guy Rouillier
• 11:17   Bad prepare performance Martin Kjeldsen
• 11:59   Re: Bad prepare performance Cédric Villemain
• 12:04   optimizing query performance Frits Hoogland
• 19:49   POSIX file updates James Mansion
• 20:03   Re: POSIX file updates Mark Mielke
• 20:38   Re: POSIX file updates James Mansion
• 20:57   Re: POSIX file updates James Mansion
• 21:24   Re: POSIX file updates James Mansion
• 22:46   Re: POSIX file updates Greg Smith