Mailing lists [pgsql-performance]

1 April 2007

• 10:22   Re: scalablility problem Ron Mayer
• 17:51   Re: scalablility problem Xiaoning Ding

2 April 2007

• 00:26   Re: scalablility problem Dave Cramer
• 08:17   How to determine which indexes are not using or using seldom in database Denis Lishtovny
• 08:42   Re: How to determine which indexes are not using or using seldom in database Thomas Pundt
• 08:44   Re: How to determine which indexes are not using or using seldom in database Andreas Kostyrka
• 10:34   Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller
• 10:42   Re: Wrong plan sequential scan instead of an index one [8.2 solved it] Gaetano Mendola
• 10:54   Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller
• 10:56   Providing user based previleges to Postgres DB 
• 14:42   Re: Providing user based previleges to Postgres DB Carlos Moreno
• 14:51   postgres 7.4 vs. 8.x redux Alex Deucher
• 17:01   Re: Scaling SELECT:s with the number of disks on a stripe Andrew - Supernews

3 April 2007

• 05:09   postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 05:28   Re: postgres 7.4 vs 8.x redux: query plans Tom Lane
• 14:26   Cache hit ratio Jean Arnaud
• 15:23   Re: Cache hit ratio Guillaume Cottenceau
• 16:25   Re: Shared buffers, db transactions commited, and write IO on Solaris Josh Berkus
• 16:37   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 16:52   Re: Shared buffers, db transactions commited, and write IO on Solaris Dimitri
• 16:53   Re: Cache hit ratio Luke Lonergan
• 18:03   Re: Cache hit ratio Ben
• 18:31   Re: Cache hit ratio Josh Berkus
• 18:59   Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau
• 19:06   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Josh Berkus
• 19:08   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Tom Lane
• 19:16   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" A.M.
• 19:24   Re: Shared buffers, db transactions commited, and write IO on Solaris Erik Jones
• 19:31   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 19:40   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" C. Bergström
• 19:47   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" A.M.
• 20:00   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Alan Hodgson
• 20:06   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" A.M.
• 20:13   Re: postgres 7.4 vs 8.x redux: query plans Merlin Moncure
• 20:18   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 20:34   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 20:45   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 21:21   Re: postgres 7.4 vs 8.x redux: query plans Tom Lane
• 21:38   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 21:40   Re: [HACKERS] EXISTS optimization Craig A. James
• 21:43   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 22:17   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 22:46   SCSI vs SATA jason@ohloh.net
• 23:08   Re: SCSI vs SATA Ron
• 23:13   Re: SCSI vs SATA Ron

4 April 2007

• 02:23   Re: SCSI vs SATA Geoff Tolley
• 03:36   Re: SCSI vs SATA Brian A. Seklecki
• 04:10   Re: SCSI vs SATA david@lang.hm
• 05:17   Re: compact flash disks? James Mansion
• 06:01   Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller
• 06:33   postgresql.conf file for PostgreSQL 8.2.3 Eugene Ogurtsov
• 08:37   Re: SCSI vs SATA Ron Mayer
• 08:51   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau
• 11:16   Re: SCSI vs SATA Peter Kovacs
• 11:33   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Ansgar -59cobalt- Wiechers
• 11:52   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau
• 11:52   Re: Scaling SELECT:s with the number of disks on a stripe Dave Cramer
• 12:03   Re: Scaling SELECT:s with the number of disks on a stripe Andrew - Supernews
• 12:36   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Arnau
• 12:47   Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Dimitri
• 12:47   Re: SCSI vs SATA Andreas Kostyrka
• 13:20   Re: SCSI vs SATA Alvaro Herrera
• 13:30   Re: SCSI vs SATA Peter Kovacs
• 13:36   Re: SCSI vs SATA Alvaro Herrera
• 13:39   Re: SCSI vs SATA Rod Taylor
• 13:48   Re: SCSI vs SATA Andreas Kostyrka
• 14:04   Large objetcs performance Alexandre Vasconcelos
• 14:11   Re: Large objetcs performance Guido Neitzer
• 14:12   Re: SCSI vs SATA jason@ohloh.net
• 14:58   Re: SCSI vs SATA Ron
• 15:17   Re: SCSI vs SATA Joshua D. Drake
• 15:33   Re: SCSI vs SATA Stefan Kaltenbrunner
• 15:40   Re: SCSI vs SATA Joshua D. Drake
• 15:43   Re: SCSI vs SATA Andreas Kostyrka
• 15:50   Re: SCSI vs SATA Joshua D. Drake
• 15:59   Re: SCSI vs SATA david@lang.hm
• 15:59   Re: SCSI vs SATA Stefan Kaltenbrunner
• 16:37   Can't drop tablespace or user after disk gone Craig A. James
• 16:57   Re: Can't drop tablespace or user after disk gone Tom Lane
• 16:59   Re: SCSI vs SATA mark@mark.mielke.cc
• 17:36   Re: SCSI vs SATA Geoff Tolley
• 17:44   Re: Scaling SELECT:s with the number of disks on a stripe Peter Schuller
• 18:09   Re: SCSI vs SATA Geoff Tolley
• 18:40   Re: SCSI vs SATA Geoff Tolley
• 18:44   Re: SCSI vs SATA James Mansion
• 19:09   Re: SCSI vs SATA Arjen van der Meijden
• 19:18   Re: SCSI vs SATA jason@ohloh.net
• 19:37   Re: SCSI vs SATA Arjen van der Meijden
• 20:27   Re: SCSI vs SATA Bruce Momjian
• 20:32   Re: SCSI vs SATA Joshua D. Drake
• 20:37   Re: SCSI vs SATA Bruce Momjian
• 20:48   Re: SCSI vs SATA Carlos Moreno
• 23:42   Re: SCSI vs SATA jason@ohloh.net

5 April 2007

• 05:24   Re: SCSI vs SATA James Mansion
• 05:34   Re: SCSI vs SATA Tom Lane
• 07:08   Re: SCSI vs SATA Arjen van der Meijden
• 09:28   Re: SCSI vs SATA Heikki Linnakangas
• 11:10   Re: SCSI vs SATA Ron
• 15:04   Re: SCSI vs SATA Scott Marlowe
• 15:19   Re: SCSI vs SATA Scott Marlowe
• 15:21   Re: SCSI vs SATA Jeff Frost
• 15:35   Re: postgres 7.4 vs 8.x redux: query plans Alex Deucher
• 15:39   Re: SCSI vs SATA jason@ohloh.net
• 15:59   Re: SCSI vs SATA jason@ohloh.net
• 16:02   Re: SCSI vs SATA Joshua D. Drake
• 16:10   Re: SCSI vs SATA Alex Deucher
• 16:25   Re: SCSI vs SATA Ron
• 16:28   Re: SCSI vs SATA Arjen van der Meijden
• 17:09   a question about Direct I/O and double buffering Xiaoning Ding
• 18:02   What do the adminpack functions do? (8.2.3) Michael Dengler
• 18:05   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Josh Berkus
• 18:06   Re: What do the adminpack functions do? (8.2.3) Joshua D. Drake
• 18:10   Re: a question about Direct I/O and double buffering Erik Jones
• 18:23   Re: a question about Direct I/O and double buffering Xiaoning Ding
• 18:29   Re: a question about Direct I/O and double buffering Mark Lewis
• 18:46   Premature view materialization in 8.2? Jonathan Ellis
• 18:48   Re: a question about Direct I/O and double buffering Erik Jones
• 18:56   Re: a question about Direct I/O and double buffering Alex Deucher
• 18:59   Re: a question about Direct I/O and double buffering Erik Jones
• 19:01   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Dimitri
• 19:11   High Load on Postgres 7.4.16 Server John Allgood
• 19:23   Re: High Load on Postgres 7.4.16 Server Jeff Frost
• 19:28   Re: High Load on Postgres 7.4.16 Server C. Bergström
• 19:29   Re: SCSI vs SATA James Mansion
• 19:33   Re: High Load on Postgres 7.4.16 Server John Allgood
• 19:47   Re: High Load on Postgres 7.4.16 Server Jeff Frost
• 19:56   Re: a question about Direct I/O and double buffering Mark Lewis
• 20:00   Re: High Load on Postgres 7.4.16 Server Dave Cramer
• 20:06   Re: SCSI vs SATA david@lang.hm
• 20:10   Re: SCSI vs SATA david@lang.hm
• 20:11   Re: a question about Direct I/O and double buffering Erik Jones
• 20:13   Re: High Load on Postgres 7.4.16 Server John Allgood
• 20:26   Re: High Load on Postgres 7.4.16 Server Dave Cramer
• 20:28   Re: a question about Direct I/O and double buffering david@lang.hm
• 20:58   Re: a question about Direct I/O and double buffering Xiaoning Ding
• 21:06   Re: a question about Direct I/O and double buffering Alex Deucher
• 21:13   Re: SCSI vs SATA Scott Marlowe
• 21:39   Re: a question about Direct I/O and double buffering Erik Jones
• 21:51   Re: Weird performance drop Vincenzo Romano

6 April 2007

• 01:42   Re: a question about Direct I/O and double buffering david@lang.hm
• 02:02   Re: SCSI vs SATA david@lang.hm
• 03:19   Re: SCSI vs SATA Ron
• 03:35   Re: SCSI vs SATA david@lang.hm
• 04:28   Re: a question about Direct I/O and double buffering david@lang.hm
• 04:30   Re: SCSI vs SATA Richard Troy
• 04:37   Re: SCSI vs SATA Greg Smith
• 05:27   Re: SCSI vs SATA Ron
• 05:43   Re: Premature view materialization in 8.2? Tom Lane
• 05:48   Re: SCSI vs SATA david@lang.hm
• 05:50   Re: High Load on Postgres 7.4.16 Server Tom Lane
• 05:51   Re: Premature view materialization in 8.2? Jonathan Ellis
• 06:00   Re: SCSI vs SATA Tom Lane
• 06:10   Re: SCSI vs SATA Greg Smith
• 06:24   Re: Premature view materialization in 8.2? Tom Lane
• 06:38   Re: SCSI vs SATA Tom Lane
• 11:38   Re: SCSI vs SATA Michael Stone
• 11:43   Re: SCSI vs SATA Michael Stone
• 12:32   Re: SCSI vs SATA Ron
• 12:43   Re: SCSI vs SATA Geoffrey
• 12:49   Re: SCSI vs SATA Ron
• 13:16   Re: SCSI vs SATA Geoffrey
• 13:24   Re: SCSI vs SATA Michael Stone
• 14:25   Re: Premature view materialization in 8.2? Jonathan Ellis
• 15:21   Re: SCSI vs SATA Scott Marlowe
• 15:21   Re: High Load on Postgres 7.4.16 Server John Allgood
• 15:41   more on high load on postgres 7.4.16 Geoffrey
• 15:59   Re: more on high load on postgres 7.4.16 Stefan Kaltenbrunner
• 16:42   Re: SCSI vs SATA Ron
• 17:05   Re: more on high load on postgres 7.4.16 Geoffrey
• 17:40   Re: Premature view materialization in 8.2? Tom Lane
• 17:57   Re: Premature view materialization in 8.2? Jonathan Ellis
• 18:00   Re: Premature view materialization in 8.2? Tom Lane
• 18:04   Re: Premature view materialization in 8.2? Jonathan Ellis
• 18:19   Re: SCSI vs SATA Michael Stone
• 18:34   Re: Premature view materialization in 8.2? Tom Lane
• 19:37   Re: SCSI vs SATA Ron
• 20:26   Re: Premature view materialization in 8.2? Jonathan Ellis
• 20:38   postgres 8.2 seems to prefer Seq Scan Alex Deucher
• 20:44   Re: SCSI vs SATA Greg Smith
• 21:03   Re: SCSI vs SATA Michael Stone
• 21:32   Re: postgres 8.2 seems to prefer Seq Scan Michael Fuhr
• 21:48   Re: postgres 8.2 seems to prefer Seq Scan Alex Deucher
• 21:58   Re: SCSI vs SATA david@lang.hm
• 22:47   Re: SCSI vs SATA Charles Sprickman
• 22:54   Re: SCSI vs SATA david@lang.hm
• 23:17   Re: SCSI vs SATA Andreas Kostyrka
• 23:25   Re: SCSI vs SATA Mark Kirkwood

7 April 2007

• 02:35   Re: SCSI vs SATA Bruce Momjian
• 11:13   fast DISTINCT or EXIST Tilo Buschmann
• 12:31   Re: fast DISTINCT or EXIST Arjen van der Meijden
• 13:05   Re: SCSI vs SATA Ron
• 15:54   Re: fast DISTINCT or EXIST Tom Lane
• 16:24   Re: fast DISTINCT or EXIST Tilo Buschmann
• 16:39   Re: fast DISTINCT or EXIST Tom Lane
• 17:27   Re: fast DISTINCT or EXIST Arjen van der Meijden
• 21:37   Re: SCSI vs SATA david@lang.hm

8 April 2007

• 00:47   Re: SCSI vs SATA Ron
• 03:08   Re: SCSI vs SATA david@lang.hm
• 03:20   Re: SCSI vs SATA Joshua D. Drake
• 07:50   Re: SCSI vs SATA mark@mark.mielke.cc
• 15:04   Re: SCSI vs SATA Ron
• 18:46   Re: SCSI vs SATA James Mansion

9 April 2007

• 09:09   Beginner Question s d
• 14:49   Re: Beginner Question Tom Lane
• 18:56   Re: postgres 8.2 seems to prefer Seq Scan Alex Deucher
• 19:23   join to view over custom aggregate seems like it should be faster Merlin Moncure
• 19:27   Re: postgres 8.2 seems to prefer Seq Scan Alex Deucher
• 20:02   DELETE with filter on ctid Spiegelberg, Greg
• 20:05   Please humor me ... Carlos Moreno
• 20:37   Re: postgres 8.2 seems to prefer Seq Scan Alex Deucher
• 20:47   how to efficiently update tuple in many-to-many relationship? Drew Wilson
• 20:55   Re: DELETE with filter on ctid Tom Lane
• 21:05   Re: Please humor me ... Jeff Davis
• 21:07   Re: join to view over custom aggregate seems like it should be faster Tom Lane
• 21:08   Re: how to efficiently update tuple in many-to-many relationship? Merlin Moncure
• 21:34   Re: join to view over custom aggregate seems like it should be faster Merlin Moncure
• 21:36   Re: join to view over custom aggregate seems like it should be faster Merlin Moncure
• 21:43   Re: how to efficiently update tuple in many-to-many relationship? Tom Lane
• 21:50   Re: DELETE with filter on ctid Craig A. James

10 April 2007

• 00:46   Re: Beginner Question s d
• 01:30   Re: how to efficiently update tuple in many-to-many relationship? Drew Wilson
• 02:13   Re: how to efficiently update tuple in many-to-many relationship? Tom Lane
• 05:46   Re: how to efficiently update tuple in many-to-many relationship? Drew Wilson
• 13:02   Re: join to view over custom aggregate seems like it should be faster Merlin Moncure
• 13:24   Re: Beginner Question Mike Gargano
• 13:35   Re: DELETE with filter on ctid Spiegelberg, Greg
• 13:37   Re: DELETE with filter on ctid Spiegelberg, Greg
• 13:54   Re: how to efficiently update tuple in many-to-many relationship? Tom Lane
• 14:12   Re: Beginner Question Dave Dutcher
• 15:37   Re: how to efficiently update tuple in many-to-many relationship? Drew Wilson
• 16:08   Re: how to efficiently update tuple in many-to-many relationship? Tom Lane
• 16:46   Re: DELETE with filter on ctid Tom Lane
• 17:03   Re: join to view over custom aggregate seems like it should be faster Tom Lane
• 17:53   Re: join to view over custom aggregate seems like it should be faster Merlin Moncure
• 18:21   Re: join to view over custom aggregate seems like it should be faster Tom Lane
• 19:45   Do I need to rebuild php-pgsql for 8.2.3 Michael Dengler
• 20:55   Re: Do I need to rebuild php-pgsql for 8.2.3 Guillaume Smet
• 21:01   Re: Do I need to rebuild php-pgsql for 8.2.3 Devrim GÜNDÜZ
• 22:50   Long running transactions again ... Tobias Brox

11 April 2007

• 17:25   Re: Do I need to rebuild php-pgsql for 8.2.3 Michael Dengler
• 17:53   Re: Do I need to rebuild php-pgsql for 8.2.3 Adam Rich
• 18:12   Re: Do I need to rebuild php-pgsql for 8.2.3 Devrim GÜNDÜZ
• 21:47   Re: Do I need to rebuild php-pgsql for 8.2.3 Michael Dengler

12 April 2007

• 04:16   Re: Beginner Question Jan de Visser
• 04:17   Question about memory allocations Steve
• 04:28   Slow Postgresql server Jason Lustig
• 04:52   Re: Question about memory allocations Tom Lane
• 05:17   Re: Slow Postgresql server Dennis Bjorklund
• 05:31   Re: Slow Postgresql server Jeff Frost
• 13:26   Re: Slow Postgresql server Ron
• 13:42   Re: Large objetcs performance Merlin Moncure
• 14:08   Re: Slow Postgresql server Guido Neitzer
• 14:59   Re: Slow Postgresql server Ron
• 15:20   Re: Slow Postgresql server Guido Neitzer
• 15:34   Re: Slow Postgresql server Jeff Frost
• 16:53   Re: Question about memory allocations Steve
• 16:56   Re: Slow Postgresql server Scott Marlowe
• 17:04   Re: Slow Postgresql server Jeff Frost
• 18:07   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Robert Treat
• 19:10   Re: Slow Postgresql server Carlos Moreno
• 21:11   Strangely Variable Query Performance Steve
• 21:24   Re: Strangely Variable Query Performance Tom Lane
• 21:48   Re: Strangely Variable Query Performance Steve
• 21:52   Re: Strangely Variable Query Performance Scott Marlowe
• 21:58   Re: Slow Postgresql server Jason Lustig
• 22:01   Re: Strangely Variable Query Performance Tom Lane
• 22:11   Re: Strangely Variable Query Performance Steve
• 22:12   Re: Strangely Variable Query Performance Steve
• 22:14   Re: Strangely Variable Query Performance Scott Marlowe
• 22:18   Re: Slow Postgresql server Guido Neitzer
• 22:22   Re: Strangely Variable Query Performance Tom Lane
• 22:32   Re: Strangely Variable Query Performance Steve
• 22:49   Re: Strangely Variable Query Performance Steve
• 23:00   Re: Strangely Variable Query Performance Tom Lane
• 23:04   Re: Strangely Variable Query Performance Steve
• 23:29   Re: Strangely Variable Query Performance Tom Lane
• 23:32   Re: Strangely Variable Query Performance Tom Lane
• 23:37   Re: Strangely Variable Query Performance Steve
• 23:48   Re: Strangely Variable Query Performance Steve
• 23:50   Re: Strangely Variable Query Performance Steve

13 April 2007

• 00:00   Re: Strangely Variable Query Performance Tom Lane
• 00:13   Re: Strangely Variable Query Performance Steve
• 00:20   Re: Strangely Variable Query Performance Tom Lane
• 00:42   Re: Strangely Variable Query Performance Steve
• 02:40   Re: Strangely Variable Query Performance Tom Lane
• 02:50   Re: Question about memory allocations Greg Smith
• 03:50   Re: Strangely Variable Query Performance Tom Lane
• 04:02   Re: Strangely Variable Query Performance Steve
• 04:05   Re: Question about memory allocations Steve
• 04:38   Re: Strangely Variable Query Performance Tom Lane
• 08:53   Re: Question about memory allocations Andrew McMillan
• 08:59   local selectivity estimation - computing frequency of predicates Avdhoot Kishore Saple
• 14:17   Re: local selectivity estimation - computing frequency of predicates Tom Lane
• 16:46   Re: Question about memory allocations Steve
• 18:23   Re: Question about memory allocations Ron
• 18:53   Re: Question about memory allocations Carlos Moreno
• 20:01   Finding bloated indexes? Dan Harris
• 20:25   Re: Question about memory allocations Jan de Visser
• 20:39   Re: Please humor me ... Simon Riggs
• 21:07   Re: Finding bloated indexes? Vivek Khera
• 22:48   choose_bitmap_and again (was Re: Strangely Variable Query Performance) Tom Lane
• 23:24   Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance) Alvaro Herrera

14 April 2007

• 08:31   Re: Finding bloated indexes? Simon Riggs
• 11:19   Basic Q on superfluous primary keys Kynn Jones
• 11:59   Re: Basic Q on superfluous primary keys Bill Moran
• 15:53   Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance) Tom Lane
• 16:37   Re: Question about memory allocations Tom Lane
• 17:20   Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance) Tom Lane
• 18:21   Re: [HACKERS] choose_bitmap_and again (was Re: Strangely Variable Query Performance) Tom Lane

15 April 2007

• 00:39   FK triggers misused? cluster
• 05:29   Re: FK triggers misused? Tom Lane
• 05:42   Re: FK triggers misused? Andrew - Supernews
• 15:22   Re: FK triggers misused? Tom Lane
• 22:07   Re: FK triggers misused? Andrew - Supernews

16 April 2007

• 13:04   Re: Basic Q on superfluous primary keys Merlin Moncure
• 14:55   Re: Basic Q on superfluous primary keys Craig A. James
• 15:55   Re: Basic Q on superfluous primary keys Merlin Moncure
• 18:24   Re: Basic Q on superfluous primary keys Ron Mayer
• 23:24   Re: FK triggers misused? cluster
• 23:50   Re: FK triggers misused? Tom Lane
• 23:55   Re: FK triggers misused? Tom Lane

17 April 2007

• 03:02   Re: Basic Q on superfluous primary keys Greg Smith
• 03:43   Fwd: Strangely Variable Query Performance Robins
• 04:44   Re: Fwd: Strangely Variable Query Performance Tom Lane
• 16:18   Re: Basic Q on superfluous primary keys Merlin Moncure
• 20:52   Re: FK triggers misused? cluster

18 April 2007

• 03:58   Re: Basic Q on superfluous primary keys Craig A. James
• 10:47   Re: Basic Q on superfluous primary keys Richard Huxton
• 12:20   Re: Basic Q on superfluous primary keys Greg Smith
• 14:44   Re: Basic Q on superfluous primary keys Merlin Moncure
• 15:07   Foreign Key Deadlocking Steven Flatt
• 15:37   Re: Foreign Key Deadlocking Csaba Nagy
• 16:03   Re: Basic Q on superfluous primary keys Craig A. James
• 17:20   Re: Shared buffers, db transactions commited, and write IO on Solaris Jim C. Nasby
• 17:47   Re: Foreign Key Deadlocking Tom Lane
• 18:08   Re: a question about Direct I/O and double buffering Jim C. Nasby
• 18:10   Re: Basic Q on superfluous primary keys Dave Dutcher
• 18:26   Re: Long running transactions again ... Jim C. Nasby
• 19:08   Re: Basic Q on superfluous primary keys Jeff Davis
• 20:03   Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000" Hannes Dorbath
• 20:59   Re: Foreign Key Deadlocking Steven Flatt

19 April 2007

• 00:16   Re: Basic Q on superfluous primary keys Merlin Moncure
• 14:00   Re: Foreign Key Deadlocking Dave Cramer
• 14:16   Re: Foreign Key Deadlocking Erik Jones
• 14:16   Re: Foreign Key Deadlocking Alvaro Herrera
• 14:29   Re: Foreign Key Deadlocking Csaba Nagy
• 17:06   how to output column names Michael Dengler
• 17:49   Re: how to output column names Jon Sime
• 19:26   Re: how to output column names Michael Dengler

20 April 2007

• 19:43   index structure for 114-dimension vector Andrew Lazarus
• 21:41   Re: index structure for 114-dimension vector Jeff Davis
• 23:42   Re: index structure for 114-dimension vector Mark Kirkwood

21 April 2007

• 00:05   Re: index structure for 114-dimension vector Andrew Lazarus
• 00:42   Re: index structure for 114-dimension vector Mark Kirkwood
• 00:44   Re: index structure for 114-dimension vector Tom Lane
• 10:42   Re: FK triggers misused? cluster
• 14:54   TPC-H Scaling Factors X PostgreSQL Cluster Command Nelson Kotowski
• 15:19   Odd problem with planner choosing seq scan Colin McGuigan
• 16:18   Re: FK triggers misused? Stephan Szabo
• 17:06   Re: Odd problem with planner choosing seq scan Tom Lane
• 20:46   not using indexes on large table Jeroen Kleijer
• 20:58   Re: not using indexes on large table Vincenzo Romano
• 21:16   Re: not using indexes on large table Andreas Kostyrka
• 23:24   Redundant sub query triggers slow nested loop left join henk de wit
• 23:48   Re: Redundant sub query triggers slow nested loop left join Tom Lane

22 April 2007

• 01:34   Re: Odd problem with planner choosing seq scan Colin McGuigan
• 02:45   Re: Odd problem with planner choosing seq scan Tom Lane
• 09:06   Re: Large objetcs performance Ulrich Cech
• 16:17   Re: Redundant sub query triggers slow nested loop left join henk de wit
• 17:53   Re: Redundant sub query triggers slow nested loop left join Tom Lane
• 20:22   Re: Redundant sub query triggers slow nested loop left join henk de wit
• 20:42   Re: Redundant sub query triggers slow nested loop left join Tom Lane
• 22:39   Re: Redundant sub query triggers slow nested loop left join henk de wit
• 22:58   Re: Redundant sub query triggers slow nested loop left join henk de wit

23 April 2007

• 02:14   Re: Redundant sub query triggers slow nested loop left join Tom Lane
• 04:09   Fwd: Strangely Variable Query Performance Robins Tharakan
• 04:15   Re: Basic Q on superfluous primary keys Craig A. James
• 04:15   Help with TOAST Compression David Hinkle
• 04:15   postgres: 100% CPU utilization Sergey Tsukinovsky
• 04:15   Odd problem with planner choosing seq scan Colin McGuigan
• 04:15   Re: Large objetcs performance Ulrich Cech
• 04:15   seeking advise on char vs text or varchar in search table chrisj
• 04:36   Re: postgres: 100% CPU utilization Tom Lane
• 05:16   Re: seeking advise on char vs text or varchar in search table Merlin Moncure
• 06:06   Re: postgres: 100% CPU utilization Andreas Tille
• 08:46   Re: Help with TOAST Compression Michael Fuhr
• 08:53   Re: postgres: 100% CPU utilization Mario Weilguni
• 09:47   Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Heikki Linnakangas
• 11:35   Re: Redundant sub query triggers slow nested loop left join henk de wit
• 14:56   Re: not using indexes on large table Dave Dutcher
• 15:06   Re: postgres: 100% CPU utilization Ron
• 15:52   Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Nelson Kotowski
• 16:09   Re: postgres: 100% CPU utilization Scott Marlowe
• 17:46   index usage Arkadiusz Raj
• 18:19   Re: index usage Steinar H. Gunderson
• 18:26   Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Kevin Grittner
• 20:00   Re: postgres: 100% CPU utilization Vivek Khera
• 20:21   Re: postgres: 100% CPU utilization Scott Marlowe
• 23:59   Re: postgres: 100% CPU utilization Mark Kirkwood

24 April 2007

• 03:39   Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Greg Smith
• 03:41   Re: postgres: 100% CPU utilization Greg Smith
• 07:12   Warm - standby system. Nimesh Satam
• 08:53   Re: TPC-H Scaling Factors X PostgreSQL Cluster Command Heikki Linnakangas
• 09:33   Re: Warm - standby system. Alexander Staubo
• 15:17   View is not using a table index Dan Shea
• 15:42   Re: View is not using a table index Richard Huxton
• 17:31   Re: View is not using a table index Dan Shea
• 18:03   Re: View is not using a table index Andreas Kostyrka
• 18:09   Re: View is not using a table index Tom Lane
• 21:13   Re: View is not using a table index Carlos Moreno

25 April 2007

• 07:16   What`s wrong with JFS configuration? Paweł Gruszczyński
• 08:54   Re: What`s wrong with JFS configuration? Heikki Linnakangas
• 11:21   Re: What`s wrong with JFS configuration? Dave Cramer
• 13:39   Re: What`s wrong with JFS configuration? Paweł Gruszczyński
• 15:04   Re: What`s wrong with JFS configuration? Chris Browne

26 April 2007

• 04:04   Re: What`s wrong with JFS configuration? Greg Smith
• 07:51   Fragmentation of WAL files Jim Nasby
• 07:51   Re: seeking advise on char vs text or varchar in search table Jim Nasby
• 07:51   Re: What`s wrong with JFS configuration? Jim Nasby
• 08:17   Re: What`s wrong with JFS configuration? Luke Lonergan
• 08:35   Re: seeking advise on char vs text or varchar in search table Gregory Stark
• 09:04   Re: What`s wrong with JFS configuration? Cosimo Streppone
• 11:44   Fw: PostgreSQL Performance Tuning Shohab Abdullah
• 11:53   Re: Fw: PostgreSQL Performance Tuning Richard Huxton
• 11:54   Re: [GENERAL] Fw: PostgreSQL Performance Tuning Richard Huxton
• 12:00   Re: Fragmentation of WAL files Bill Moran
• 12:10   Re: Fragmentation of WAL files Heikki Linnakangas
• 13:14   Filesystem fragmentation (Re: Fragmentation of WAL files) Bill Moran
• 15:37   Re: Fragmentation of WAL files Tom Lane
• 16:26   Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Craig A. James
• 16:47   Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Gregory Stark
• 17:03   Re: [GENERAL] Fw: PostgreSQL Performance Tuning Gerhard Wiesinger
• 17:49   Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Tom Lane
• 19:22   Re: not using indexes on large table Scott Marlowe
• 20:58   Re: index structure for 114-dimension vector C Storm
• 20:59   Re: postgres: 100% CPU utilization Sergey Tsukinovsky
• 20:59   Simple query, 10 million records...MySQL ten times faster zardozrocks
• 21:09   Re: Simple query, 10 million records...MySQL ten times faster Merlin Moncure
• 21:11   Re: Simple query, 10 million records...MySQL ten times faster Bill Moran
• 21:29   Re: [GENERAL] PostgreSQL Performance Tuning Steve Crawford
• 21:36   Re: Simple query, 10 million records...MySQL ten times faster Benjamin Minshall
• 21:40   Re: Simple query, 10 million records...MySQL ten times faster Luke Lonergan
• 22:34   Re: index structure for 114-dimension vector Alexander Staubo
• 22:42   Re: Simple query, 10 million records...MySQL ten times faster Scott Marlowe
• 22:45   Re: Simple query, 10 million records...MySQL ten times faster Jeff Hoffmann
• 22:50   Re: postgres: 100% CPU utilization Scott Marlowe
• 23:12   Re: Simple query, 10 million records...MySQL ten times faster Alexander Staubo
• 23:14   Re: Simple query, 10 million records...MySQL ten times faster Alexander Staubo

27 April 2007

• 01:27   Re: postgres: 100% CPU utilization Mark Kirkwood
• 01:48   Re: Simple query, 10 million records...MySQL ten times faster joe@omc-international.com.au
• 01:58   Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
• 02:49   Re: Feature Request --- was: PostgreSQL Performance Tuning Tom Lane
• 04:43   Usage up to 50% CPU Andres Retzlaff
• 04:43   Re: index structure for 114-dimension vector Oleg Bartunov
• 04:49   Re: Simple query, 10 million records...MySQL ten times faster Oleg Bartunov
• 04:51   Re: Fragmentation of WAL files Greg Smith
• 06:07   Re: index structure for 114-dimension vector Arjen van der Meijden
• 07:39   Re: Filesystem fragmentation (Re: Fragmentation of WAL files) Florian Weimer
• 08:07   Re: Usage up to 50% CPU Magnus Hagander
• 08:10   Re: Usage up to 50% CPU Andres Retzlaff
• 08:13   Re: Usage up to 50% CPU Magnus Hagander
• 09:53   Re: Usage up to 50% CPU Shane Ambler
• 12:53   Re: Usage up to 50% CPU Michael Stone
• 13:27   Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
• 14:09   Re: What`s wrong with JFS configuration? Jim Nasby
• 14:30   Re: Feature Request --- was: PostgreSQL Performance Tuning Michael Stone
• 14:36   Re: Feature Request --- was: PostgreSQL Performance Tuning Tom Lane
• 14:37   Re: Feature Request --- was: PostgreSQL Performance Tuning Mark Lewis
• 15:23   Re: Feature Request --- was: PostgreSQL Performance Tuning H.J. Sanders
• 15:32   Re: Feature Request --- was: PostgreSQL Performance Tuning Michael Stone
• 15:56   [Fwd: ] How Siddharth Anand
• 15:56   How can fixed and variable width columns perform similarly? Siddharth Anand
• 16:12   Re: Feature Request --- was: PostgreSQL Performance Tuning Jim Nasby
• 16:26   Re: How can fixed and variable width columns perform similarly? Tom Lane
• 16:35   Re: [Fwd: ] How Richard Huxton
• 16:39   Re: How can fixed and variable width columns perform similarly? Dave Dutcher
• 16:43   Re: How can fixed and variable width columns perform similarly? Siddharth Anand
• 17:12   Re: How can fixed and variable width columns perform similarly? Tom Lane
• 17:45   Very specific server situation Mauro N. Infantino
• 17:47   Re: Feature Request --- was: PostgreSQL Performance Tuning Dan Harris
• 17:59   Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus
• 18:11   Re: Feature Request --- was: PostgreSQL Performance Tuning Bill Moran
• 18:40   Re: Feature Request --- was: PostgreSQL Performance Tuning Kevin Hunter
• 18:52   Re: Feature Request --- was: PostgreSQL Performance Tuning Ray Stell
• 19:10   Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus
• 20:28   Re: Feature Request --- was: PostgreSQL Performance Tuning Dan Harris
• 22:52   Re: Very specific server situation Tom Lane

28 April 2007

• 00:46   Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus
• 01:39   Re: Feature Request --- was: PostgreSQL Performance Tuning david@lang.hm
• 08:31   Re: Feature Request --- was: PostgreSQL Performance Tuning Harald Armin Massa
• 09:56   Re: Redundant sub query triggers slow nested loop left join henk de wit
• 16:54   Re: Feature Request --- was: PostgreSQL Performance Tuning Jonah H. Harris
• 18:15   Re: Feature Request --- was: PostgreSQL Performance Tuning Harald Armin Massa
• 19:28   Re: Usage up to 50% CPU Andres Retzlaff
• 20:34   Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno
• 20:43   Re: Very specific server situation Mauro N. Infantino
• 22:51   Re: Redundant sub query triggers slow nested loop left join henk de wit

30 April 2007

• 11:48   Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith
• 12:16   Query performance problems with partitioned tables Andreas Haumer
• 13:05   Re: Query performance problems with partitioned tables Guillaume Cottenceau
• 13:29   Re: Query performance problems with partitioned tables Andreas Haumer
• 13:45   Re: Query performance problems with partitioned tables Richard Huxton
• 13:54   Re: Query performance problems with partitioned tables Guillaume Cottenceau
• 14:06   Re: Query performance problems with partitioned tables Neil Peter Braggio
• 14:13   sytem log audit/reporting and psql Fei Liu
• 15:06   Re: Query performance problems with partitioned tables Tom Lane
• 15:36   Re: Query performance problems with partitioned tables Gregory Stark
• 16:19   Re: Feature Request --- was: PostgreSQL Performance Tuning Craig A. James
• 16:58   Re: Query performance problems with partitioned tables Andreas Haumer
• 17:21   Re: Query performance problems with partitioned tables Andreas Haumer
• 17:23   Re: Query performance problems with partitioned tables Steinar H. Gunderson
• 17:30   Re: Feature Request --- was: PostgreSQL Performance Tuning Kevin Hunter
• 19:19   Re: Query performance problems with partitioned tables Gregory Stark