Mailing lists [pgsql-performance]

1 August 2004

• 08:42   SSD Drives Greg Stark

2 August 2004

• 05:11   Page Miss Hits Ioannis Theoharis
• 09:08   No index usage with "left join" [email protected]
• 09:18   Re: No index usage with "left join" Leeuw van der, Tim
• 09:21   What kind of performace can I expect and how to measure? Joost Kraaijeveld
• 09:34   Re: What kind of performace can I expect and how to measure? Merlin Moncure
• 09:40   Re: No index usage with G u i d o B a r o s i o
• 09:45   Re: No index usage with "left join" Rod Taylor
• 09:47   Re: What kind of performace can I expect and how to measure? Joost Kraaijeveld
• 09:47   Re: No index usage with Bruce Momjian
• 11:04   Re: No index usage with "left join" Tom Lane
• 11:16   Re: What kind of performace can I expect and how to measure? Merlin Moncure
• 12:01   Re: SSD Drives 
• 13:07   Re: No index usage with "left join" Scott Marlowe
• 13:10   Re: What kind of performace can I expect and how to Scott Marlowe
• 13:19   Re: Page Miss Hits Scott Marlowe
• 13:48   Re: Page Miss Hits Gaetano Mendola
• 17:54   Re: Page Miss Hits Gaetano Mendola
• 18:18   Re: my boss want to migrate to ORACLE Stephane Tessier
• 18:26   Re: Page Miss Hits Rod Taylor
• 18:28   Re: my boss want to migrate to ORACLE James Thornton
• 18:31   Re: my boss want to migrate to ORACLE Stephane Tessier
• 19:18   Re: Page Miss Hits Gaetano Mendola
• 19:47   Re: my boss want to migrate to ORACLE [email protected]
• 21:16   Re: my boss want to migrate to ORACLE Scott Marlowe

3 August 2004

• 05:40   NOT IN query takes forever Marius Andreiana
• 06:07   pg_autovacuum parameters Lending, Rune
• 09:06   Re: NOT IN query takes forever Merlin Moncure
• 11:09   Re: NOT IN query takes forever Stephan Szabo
• 11:26   Re: pg_autovacuum parameters Matthew T. O'Connor
• 12:00   Re: NOT IN query takes forever Tom Lane
• 12:58   Re: NOT IN query takes forever Marius Andreiana
• 14:53   Re: NOT IN query takes forever Merlin Moncure
• 15:10   Re: pg_autovacuum parameters Gaetano Mendola
• 15:19   Performance Bottleneck Martin Foster
• 15:25   Re: NOT IN query takes forever Scott Marlowe
• 15:39   Re: Performance Bottleneck Dennis Bjorklund
• 16:11   Re: Performance Bottleneck Joshua D. Drake
• 19:21   Re: NOT IN query takes forever Gaetano Mendola
• 19:46   Re: Performance Bottleneck Gaetano Mendola
• 22:31   Re: NOT IN query takes forever Christopher Kings-Lynne

4 August 2004

• 01:26   Re: Performance Bottleneck Martin Foster
• 03:39   Re: Performance Bottleneck Pierre-Frédéric Caillaud
• 09:43   Tuning queries on large database Valerie Schneider DSI/DEV
• 09:46   The black art of postgresql.conf tweaking Paul Serby
• 10:01   Re: The black art of postgresql.conf tweaking Jeff
• 10:10   Re: The black art of postgresql.conf tweaking Michal Taborsky
• 10:22   Re: Tuning queries on large database Christopher Kings-Lynne
• 10:26   Re: Tuning queries on large database Rod Taylor
• 10:30   Re: The black art of postgresql.conf tweaking Janning Vygen
• 10:44   Re: The black art of postgresql.conf tweaking Paul Thomas
• 11:11   Re: Tuning queries on large database Valerie Schneider DSI/DEV
• 11:51   Re: The black art of postgresql.conf tweaking Thomas Swan
• 12:36   Re: Performance Bottleneck Michael Adler
• 12:51   Re: Tuning queries on large database Pierre-Frédéric Caillaud
• 12:53   Re: Tuning queries on large database Pierre-Frédéric Caillaud
• 12:56   FW: Tuning queries on large database Merlin Moncure
• 13:21   Re: Performance Bottleneck Martin Foster
• 13:37   Re: Performance Bottleneck Martin Foster

5 August 2004

• 03:40   Re: Performance Bottleneck Pierre-Frédéric Caillaud
• 05:16   Re: [GENERAL] Tuning queries on large database Valerie Schneider DSI/DEV
• 07:07   Re: [GENERAL] Tuning queries on large database Mark Kirkwood
• 10:08   Re: [GENERAL] Tuning queries on large database Gaetano Mendola
• 10:18   Re: [GENERAL] Tuning queries on large database Rod Taylor
• 10:21   Re: [GENERAL] Tuning queries on large database Merlin Moncure
• 10:26   Re: [GENERAL] Tuning queries on large database Merlin Moncure
• 11:33   Temporary tables G u i d o B a r o s i o
• 12:04   Re: Performance Bottleneck Steinar H. Gunderson
• 12:42   Re: Temporary tables Gaetano Mendola

6 August 2004

• 00:41   Re: my boss want to migrate to ORACLE Mischa Sandberg
• 00:58   pg_dump performance? Jesper Krogh
• 01:43   Re: pg_dump performance? Christopher Kings-Lynne
• 02:05   Re: pg_dump performance? Jesper Krogh
• 13:11   Re: Tuning queries on large database Gaetano Mendola
• 13:11   Re: [GENERAL] Tuning queries on large database Gaetano Mendola
• 13:11   Re: Temporary tables Gaetano Mendola
• 13:11   Re: Performance Bottleneck Gaetano Mendola
• 13:17   Re: The black art of postgresql.conf tweaking Gaetano Mendola
• 13:30   Re: The black art of postgresql.conf tweaking Josh Berkus
• 14:07   Re: Performance Bottleneck Mike Benoit
• 15:30   Re: The black art of postgresql.conf tweaking Gaetano Mendola
• 20:01   Re: Performance Bottleneck Martin Foster
• 20:19   Re: The black art of postgresql.conf tweaking Josh Berkus
• 20:30   Re: Performance Bottleneck Martin Foster
• 20:30   Re: Performance Bottleneck Gaetano Mendola
• 20:43   Re: The black art of postgresql.conf tweaking Gaetano Mendola
• 21:01   Re: Performance Bottleneck Tom Lane
• 21:30   Question about Generating Possible Plans by the planner/optimizer sandra ruiz
• 21:56   Re: Performance Bottleneck Scott Marlowe
• 22:13   Re: Question about Generating Possible Plans by the planner/optimizer Steinar H. Gunderson

7 August 2004

• 01:13   Re: Performance Bottleneck Martin Foster
• 01:38   Re: Performance Bottleneck Scott Marlowe
• 01:45   Re: Performance Bottleneck Martin Foster
• 07:04   Re: Performance Bottleneck Gaetano Mendola
• 07:12   Re: Performance Bottleneck Gaetano Mendola
• 07:50   Re: Performance Bottleneck Christopher Kings-Lynne
• 11:21   Re: Performance Bottleneck Jan Wieck

8 August 2004

• 02:29   Re: Performance Bottleneck Martin Foster
• 02:41   Re: Performance Bottleneck Martin Foster
• 05:21   Re: Performance Bottleneck Mike Benoit
• 09:10   Re: Performance Bottleneck Jeff
• 10:53   Re: Performance Bottleneck Jan Wieck
• 11:30   Re: Performance Bottleneck Matt Clark
• 12:49   Re: Performance Bottleneck Martin Foster
• 13:03   Re: Performance Bottleneck Arjen van der Meijden
• 15:40   Re: Performance Bottleneck Martin Foster
• 22:07   Re: Performance Bottleneck Tatsuo Ishii
• 22:09   Re: Performance Bottleneck Tatsuo Ishii

9 August 2004

• 00:06   performance with column orders Jim Thomason
• 11:28   Re: The black art of postgresql.conf tweaking Paul Serby
• 11:47   Re: The black art of postgresql.conf tweaking Shridhar Daithankar
• 12:30   tablespaces and ramdisks Merlin Moncure
• 13:35   Re: tablespaces and ramdisks Tom Lane
• 13:59   Help specifying new machine Rory Campbell-Lange
• 17:08   Re: Help specifying new machine Bill Montgomery
• 21:06   insert waits for delete with trigger Litao Wu
• 21:31   Re: insert waits for delete with trigger Tom Lane

10 August 2004

• 01:36   Re: insert waits for delete with trigger Litao Wu
• 01:41   Re: insert waits for delete with trigger Tom Lane
• 10:39   Column order performance Bill Montgomery
• 11:54   Re: insert waits for delete with trigger Litao Wu
• 12:45   Re: Performance Bottleneck Alex Hayward
• 13:31   Re: [HACKERS] fsync vs open_sync Merlin Moncure
• 14:33   Re: The black art of postgresql.conf tweaking CoL
• 14:43   Slow select, insert, update Paul Langard
• 14:46   Re: [HACKERS] fsync vs open_sync [email protected]
• 18:13   Re: Slow select, insert, update Doug McNaught
• 19:01   Re: Performance Bottleneck [email protected]
• 19:53   Hardware upgrade for a high-traffic database Jason Coene
• 20:12   Re: Slow select, insert, update Bill Montgomery
• 20:20   Re: Column order performance Bill Montgomery
• 20:54   Re: Slow select, insert, update Tom Lane
• 21:05   Re: Column order performance Josh Berkus
• 21:05   Re: [HACKERS] fsync vs open_sync Josh Berkus
• 21:38   Re: insert waits for delete with trigger Tom Lane
• 22:10   Re: Hardware upgrade for a high-traffic database Jason Coene
• 22:30   Re: Hardware upgrade for a high-traffic database Scott Marlowe
• 22:43   Re: Hardware upgrade for a high-traffic database Rod Taylor
• 22:46   Bulk Insert and Index use Rudi Starcevic
• 23:23   Re: Slow select, insert, update Litao Wu
• 23:54   Re: Bulk Insert and Index use Jim J
• 23:55   Re: Bulk Insert and Index use Gregory S. Williamson

11 August 2004

• 00:41   Re: Bulk Insert and Index use Rudi Starcevic
• 00:53   Re: Bulk Insert and Index use Christopher Browne
• 01:15   Re: Bulk Insert and Index use Gregory S. Williamson
• 01:25   Re: Bulk Insert and Index use Rudi Starcevic
• 02:41   NUMERIC x VARCHAR Er Galvão Abbott
• 03:20   Re: NUMERIC x VARCHAR Scott Marlowe
• 03:43   Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud
• 03:47   Re: NUMERIC x VARCHAR Pierre-Frédéric Caillaud
• 04:26   Re: NUMERIC x VARCHAR Er Galvão Abbott
• 04:42   Re: NUMERIC x VARCHAR Michael Glaesemann
• 09:22   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 11:49   Storing binary data. Jesper Krogh
• 12:33   Re: Storing binary data. Shridhar Daithankar
• 13:23   Re: Hardware upgrade for a high-traffic database Sanjay Arora
• 13:26   Re: [GENERAL] How to know which queries are to be optimised? Bruno Wolff III
• 13:47   Re: Storing binary data. Tom Lane
• 14:41   Re: NUMERIC x VARCHAR Er Galvão Abbott
• 14:43   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 15:02   Re: Storing binary data. Jesper Krogh
• 15:05   Re: fsync vs open_sync Merlin Moncure
• 16:17   Re: Hardware upgrade for a high-traffic database Jason Coene
• 16:33   Re: NUMERIC x VARCHAR Jan Wieck
• 16:42   Re: Hardware upgrade for a high-traffic database Brian Hirt
• 17:02   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 17:52   Re: [HACKERS] fsync vs open_sync Steve Bergman
• 18:18   Re: Hardware upgrade for a high-traffic database Jason Coene
• 18:31   Re: Hardware upgrade for a high-traffic database Brian Hirt
• 18:46   Re: Hardware upgrade for a high-traffic database Rod Taylor
• 18:52   Re: Hardware upgrade for a high-traffic database Rod Taylor
• 19:03   Re: Hardware upgrade for a high-traffic database Jason Coene
• 19:26   Re: Hardware upgrade for a high-traffic database Rod Taylor
• 19:57   Re: Hardware upgrade for a high-traffic database Jason Coene
• 20:20   Re: Hardware upgrade for a high-traffic database Tom Lane
• 20:56   Re: Hardware upgrade for a high-traffic database Russell Smith
• 20:58   Re: Storing binary data. Russell Smith
• 21:04   Buld Insert and Index use. Rudi Starcevic
• 21:12   Re: [HACKERS] fsync vs open_sync Gaetano Mendola
• 21:26   Re: Buld Insert and Index use. Josh Berkus
• 21:29   Re: Hardware upgrade for a high-traffic database Jason Coene
• 23:09   Re: Hardware upgrade for a high-traffic database Tom Lane

12 August 2004

• 03:49   Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud
• 07:38   Re: [GENERAL] How to know which queries are to be optimised? Ulrich Wisser
• 08:16   Re: [GENERAL] How to know which queries are to be optimised? Richard Huxton
• 10:39   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 11:08   Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne
• 11:09   Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne
• 14:50   Re: Hardware upgrade for a high-traffic database Tom Lane
• 15:10   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 15:58   Re: Hardware upgrade for a high-traffic database gnari
• 16:33   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 17:03   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 19:41   Re: Help specifying new machine William Yu
• 19:52   Re: [GENERAL] How to know which queries are to be optimised? Rudi Starcevic

13 August 2004

• 04:47   insert Ulrich Wisser
• 07:09   Re: insert G u i d o B a r o s i o
• 07:47   Re: insert gnari
• 08:16   Re: insert G u i d o B a r o s i o
• 08:45   Re: insert gnari
• 09:10   Re: insert Ulrich Wisser
• 09:41   Re: insert Paul Thomas
• 09:58   Re: insert Rod Taylor
• 11:44   Weird Database Performance problem! Arash Zaryoun
• 11:54   Re: insert Bruno Wolff III
• 12:08   Re: Help specifying new machine Raoul Buzziol
• 12:37   Re: [HACKERS] fsync vs open_sync [email protected]
• 12:42   Re: fsync vs open_sync [email protected]
• 12:44   Performance Problem With Postgresql! Arash Zaryoun
• 13:00   Re: Weird Database Performance problem! Richard Huxton
• 13:23   Re: insert Bruno Wolff III
• 14:14   Re: insert Matt Clark
• 14:43   Reiser4 Pierre-Frédéric Caillaud
• 15:10   Re: fsync vs open_sync Pierre-Frédéric Caillaud
• 15:44   Re: insert Tom Lane
• 15:46   Re: Reiser4 Josh Berkus
• 16:09   Re: Performance Problem With Postgresql! Josh Berkus
• 17:29   Re: fsync vs open_sync Merlin Moncure
• 18:05   Re: Weird Database Performance problem! Richard Huxton
• 18:58   REINDEX needed because of index corruption need help ASAP borajetta
• 19:38   Re: REINDEX needed because of index corruption need help ASAP Tom Lane
• 19:41   Re: REINDEX needed because of index corruption need help ASAP Josh Berkus
• 22:27   Replication: Slony-I vs. Mammoth Replicator vs. ? Chris Cheston
• 22:31   Re: Reiser4 Bruce Momjian
• 22:34   Re: Reiser4 Bruce Momjian
• 22:42   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake

14 August 2004

• 11:41   Re: insert Gaetano Mendola
• 12:33   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Jan Wieck
• 13:31   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake
• 14:56   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Jan Wieck
• 17:07   Re: [HACKERS] Reiser4 Peter Eisentraut
• 18:11   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Christopher Browne
• 21:58   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake

15 August 2004

• 00:11   Faster with a sub-query then without Martin Foster
• 00:55   Re: Faster with a sub-query then without Tom Lane
• 13:00   Slow joins against set-returning functions Michael Fuhr
• 13:01   Re: Faster with a sub-query then without Martin Foster
• 14:21   Re: Slow joins against set-returning functions Tom Lane
• 14:48   Help interpreting explain analyze output Ole Tange
• 15:21   Re: Help interpreting explain analyze output Tom Lane
• 15:33   Re: Help interpreting explain analyze output Richard Poole
• 16:08   Re: Help interpreting explain analyze output Ole Tange
• 16:40   Re: Help interpreting explain analyze output Tom Lane
• 17:12   Re: Help specifying new machine William Yu

16 August 2004

• 12:12   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Vivek Khera
• 12:22   Strange problems with more memory. Stef
• 12:41   Re: Strange problems with more memory. Tom Lane
• 13:23   Re: Strange problems with more memory. Stef
• 20:08   Re: Timestamp-based indexing Josh Berkus
• 20:15   Re: Index type Josh Berkus
• 20:25   Re: Timestamp-based indexing Tom Lane

17 August 2004

• 03:24   Re: Strange problems with more memory. Mark Kirkwood
• 10:30   General performance problem! olivier HARO
• 10:57   Re: General performance problem! Leeuw van der, Tim
• 11:12   Re: General performance problem! Gaetano Mendola
• 11:16   Re: General performance problem! Richard Huxton
• 12:35   Postgres does not utilize indexes. Why? Artimenko Igor
• 12:41   Re: General performance problem! olivier HARO
• 12:45   Re: Postgres does not utilize indexes. Why? Michal Taborsky
• 13:59   Re: General performance problem! Duane Lee - EGOVX
• 15:32   Re: Postgres does not utilize indexes. Why? Pierre-Frédéric Caillaud
• 17:03   Re: shared_buffers Question Joe Lester
• 18:30   Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)? Frank van Vugt
• 18:34   Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)? Frank van Vugt
• 20:03   Re: Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)? Josh Berkus
• 21:44   postgresql performance with multimedia my thi ho

18 August 2004

• 05:18   high load caused by I/O - a hint eleven
• 05:55   Re: high load caused by I/O - a hint Grega Bremec
• 06:25   Re: Why is the number of dead tuples causing the performance of deferred triggers to degrade so rapidly (exponentionally)? Frank van Vugt
• 08:12   Re: high load caused by I/O - a hint Gaetano Mendola
• 10:10   Re: high load caused by I/O - a hint Jeff
• 10:10   Re: postgresql performance with multimedia Jan Wieck
• 12:52   I could not get postgres to utilizy indexes Igor Artimenko
• 12:53   Re: Help specifying new machine Raoul Buzziol
• 13:13   Re: Help specifying new machine Rod Taylor
• 14:12   Re: I could not get postgres to utilizy indexes Thomas Swan
• 14:24   Re: I could not get postgres to utilizy indexes gnari
• 14:29   Re: I could not get postgres to utilizy indexes gnari
• 16:39   Array types and loading Aaron Birkland
• 18:39   Re: Array types and loading Tom Lane
• 18:47   Re: Array types and loading Aaron Birkland
• 20:03   Re: Why is the number of dead tuples causing the performance DeJuan Jackson
• 20:11   Re: Postgres does not utilyze indexes Artimenko Igor

19 August 2004

• 01:42   Re: Help specifying new machine William Yu
• 02:49   Re: Help specifying new machine Tom Lane
• 04:55   Re: I could not get postgres to utilizy indexes Leeuw van der, Tim
• 10:15   help with query Dave Cramer
• 10:36   Re: help with query Brad Bulger
• 10:49   Re: help with query Dave Cramer
• 11:16   Re: help with query Dave Cramer
• 11:21   Re: help with query Jean-Luc Lachance
• 13:20   Re: Help specifying new machine Josh Berkus
• 14:43   using an index worst performances Gaetano Mendola
• 15:10   Re: using an index worst performances Richard Huxton
• 17:13   Re: using an index worst performances Gaetano Mendola
• 22:37   Re: using an index worst performances Christopher Kings-Lynne

20 August 2004

• 06:37   Re: using an index worst performances Gaetano Mendola
• 09:55   Re: using an index worst performances Rod Taylor
• 09:56   pg_restore very slow in 8.0.0beta1 Bonnin S.
• 10:36   Re: I could not get postgres to utilizy indexes Manfred Koizar
• 10:45   Re: I could not get postgres to utilizy indexes Leeuw van der, Tim
• 13:13   Re: using an index worst performances Gaetano Mendola
• 13:19   Re: using an index worst performances Tom Lane
• 13:20   Query performance problem Danilo Mota
• 13:34   Re: Query performance problem Tom Lane
• 13:39   Re: Query performance problem Bruno Wolff III
• 13:50   Re: Query performance problem Tom Lane
• 16:43   Re: using an index worst performances Gaetano Mendola
• 17:04   Re: using an index worst performances Tom Lane
• 20:59   Query Performance Danilo Mota
• 21:59   Re: Query Performance Brad Bulger

22 August 2004

• 07:08   Re: using an index worst performances Gaetano Mendola

23 August 2004

• 11:33   postgresql 8.0 beta - fail to collect statsistic my thi ho
• 16:01   Re: postgresql 8.0 beta - fail to collect statsistic Tom Lane
• 18:52   Re: postgresql 8.0 beta - fail to collect statsistic Steve Bergman
• 19:30   Re: postgresql 8.0 beta - fail to collect statsistic Tom Lane
• 21:02   How do I see what triggers are called on cascade? [email protected]
• 23:50   Re: How do I see what triggers are called on cascade? Tom Lane

24 August 2004

• 02:15   Re: postgresql performance with multimedia my ho
• 05:33   Query kills machine. Stef
• 06:08   Re: Query kills machine. Christopher Kings-Lynne
• 08:59   Re: postgresql performance with multimedia Jan Wieck
• 10:30   Re: Query kills machine. Stef
• 11:15   Re: Query kills machine. Magnus Naeslund(pg)
• 12:23   Re: Query kills machine. Tom Lane
• 13:31   [FUN] Performance increase? Gaetano Mendola
• 15:48   Re: Query kills machine. Magnus Naeslund(t)
• 15:48   What is the best way to do attribute/values? Daniel Ceregatti
• 17:30   Re: What is the best way to do attribute/values? Josh Berkus
• 18:00   Re: What is the best way to do attribute/values? Richard Huxton

25 August 2004

• 03:54   Re: postgresql performance with multimedia my ho
• 04:14   Re: postgresql performance with multimedia Gregory S. Williamson
• 05:19   Re: What is the best way to do attribute/values? Mark Kirkwood
• 08:02   Re: postgresql performance with multimedia Jan Wieck
• 08:26   OT: Network config (WAS: RE: postgresql performance with multimedia) Leeuw van der, Tim
• 09:35   Re: What is the best way to do attribute/values? Jeff
• 10:06   Re: What is the best way to do attribute/values? Leeuw van der, Tim
• 11:31   Re: Query kills machine. Stef
• 12:06   Optimizer Selecting Incorrect Index David Price
• 12:47   Re: Optimizer Selecting Incorrect Index Richard Huxton
• 13:59   Re: What is the best way to do attribute/values? Josh Berkus
• 16:08   Re: Optimizer Selecting Incorrect Index Tom Lane
• 18:09   Anyone familiar with Apple Xserve RAID Robert Treat
• 18:22   Re: Anyone familiar with Apple Xserve RAID Josh Berkus
• 19:48   TSearch2 and optimisation ... Hervé Piedvache
• 19:52   Re: Anyone familiar with Apple Xserve RAID Doug McNaught
• 20:49   Re: Anyone familiar with Apple Xserve RAID Josh Berkus
• 20:51   Re: TSearch2 and optimisation ... Josh Berkus
• 21:22   Re: What is the best way to do attribute/values? Simon Riggs
• 21:50   Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
• 21:50   Re: Anyone familiar with Apple Xserve RAID Ralf Schramm
• 21:50   Re: Anyone familiar with Apple Xserve RAID Ralf Schramm
• 22:13   Re: Equivalent praxis to CLUSTERED INDEX? Christopher Kings-Lynne

26 August 2004

• 01:49   Re: What is the best way to do attribute/values? Mark Kirkwood
• 03:16   Re: Optimizer Selecting Incorrect Index Dennis Bjorklund
• 04:22   Re: TSearch2 and optimisation ... Hervé Piedvache
• 07:17   Re: Optimizer Selecting Incorrect Index Richard Huxton
• 08:04   Re: Optimizer Selecting Incorrect Index David Price
• 09:07   Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley
• 12:13   Re: Anyone familiar with Apple Xserve RAID Tore Halset
• 14:40   Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley
• 14:49   Re: TSearch2 and optimisation ... Josh Berkus
• 14:58   Re: TSearch2 and optimisation ... George Essig
• 15:03   Disabling transaction/outdated-tuple behaviour Neil Cooper
• 15:14   Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers
• 15:18   Re: Disabling transaction/outdated-tuple behaviour Matt Clark
• 15:19   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 15:20   Re: Disabling transaction/outdated-tuple behaviour Josh Berkus
• 15:33   Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
• 16:04   Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers
• 16:10   Re: Anyone familiar with Apple Xserve RAID Kevin Barnard
• 16:30   Re: Equivalent praxis to CLUSTERED INDEX? Magnus Hagander
• 16:30   Re: TSearch2 and optimisation ... Hervé Piedvache
• 16:48   Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
• 16:54   Re: Anyone familiar with Apple Xserve RAID Doug McNaught
• 17:01   Re: Anyone familiar with Apple Xserve RAID Alan Stange
• 17:12   Re: Anyone familiar with Apple Xserve RAID Andrew Rawnsley
• 17:44   Re: Equivalent praxis to CLUSTERED INDEX? J. Andrew Rogers
• 18:31   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 19:36   Re: Equivalent praxis to CLUSTERED INDEX? Gregory S. Williamson
• 22:45   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian

27 August 2004

• 00:39   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 01:35   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 03:27   Re: postgresql performance with multimedia my ho
• 03:54   Query performance issue with 8.0.0beta1 Stefano Bonnin
• 05:32   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 05:49   Re: Query performance issue with 8.0.0beta1 Russell Smith
• 13:24   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 13:31   Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
• 13:32   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 13:51   Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar
• 13:52   Re: Query performance issue with 8.0.0beta1 [email protected]
• 14:15   Re: Query performance issue with 8.0.0beta1 Josh Berkus
• 14:27   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 14:39   Re: Equivalent praxis to CLUSTERED INDEX? Jeremy Dunn
• 14:40   Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar
• 14:49   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 15:19   Re: Equivalent praxis to CLUSTERED INDEX? Tom Lane
• 16:29   Why those queries do not utilize indexes? Artimenko Igor
• 16:31   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 16:35   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 16:43   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 16:49   Re: Why those queries do not utilize indexes? Dennis Bjorklund
• 17:34   Re: Anyone familiar with Apple Xserve RAID Vivek Khera
• 18:09   Re: Why those queries do not utilize indexes? Artimenko Igor
• 22:32   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 23:08   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola

28 August 2004

• 00:55   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 05:15   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 05:51   Re: Why those queries do not utilize indexes? Christopher Kings-Lynne
• 08:15   ill-planned queries inside a stored procedure Gaetano Mendola
• 09:02   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 12:13   Re: ill-planned queries inside a stored procedure [email protected]
• 13:35   Re: ill-planned queries inside a stored procedure Gaetano Mendola
• 14:42   Performance hit on loading from HD Vitaly Belman
• 18:33   Re: Performance hit on loading from HD Josh Berkus

29 August 2004

• 12:15   Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
• 12:15   Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
• 12:15   Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
• 12:15   Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
• 12:16   Why does a simple query not use an obvious index? Jack Kerkhof
• 12:16   Re: Equivalent praxis to CLUSTERED INDEX? Mischa Sandberg
• 12:16   Query performance problem in 8.0.0beta1 Stefano Bonnin
• 15:05   Re: Why does a simple query not use an obvious index? Mr Pink
• 15:27   Re: Why does a simple query not use an obvious index? Scott Marlowe
• 15:57   Re: Why does a simple query not use an obvious index? Steinar H. Gunderson
• 15:58   Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
• 18:10   Re: Why does a simple query not use an obvious index? Greg Stark
• 18:12   Re: Why does a simple query not use an obvious index? Greg Stark
• 18:36   Re: Why does a simple query not use an obvious index? Scott Marlowe
• 18:42   Re: Why does a simple query not use an obvious index? Scott Marlowe
• 19:03   Re: Why does a simple query not use an obvious index? Tom Lane
• 19:04   Re: Why does a simple query not use an obvious index? Steinar H. Gunderson
• 19:10   Re: Why does a simple query not use an obvious index? Greg Stark
• 19:18   Re: Why does a simple query not use an obvious index? Rod Taylor
• 19:32   Re: Query performance problem in 8.0.0beta1 Russell Smith
• 23:10   Re: Why does a simple query not use an obvious index? Mr Pink
• 23:23   Re: Why does a simple query not use an obvious index? Tom Lane

30 August 2004

• 04:38   Re: Why does a simple query not use an obvious index? Mr Pink
• 05:20   Re: Why does a simple query not use an obvious index? Guy Thornley
• 12:41   Re: Why does a simple query not use an obvious index? Tom Lane
• 12:41   Re: Why does a simple query not use an obvious index? Greg Stark
• 13:02   Re: Why does a simple query not use an obvious index? Steinar H. Gunderson
• 13:47   Re: Why does a simple query not use an obvious index? Tom Lane
• 14:46   seqscan instead of index scan Martin Sarsale
• 14:53   Re: seqscan instead of index scan Bruno Wolff III
• 15:06   Re: seqscan instead of index scan Merlin Moncure
• 15:07   Re: seqscan instead of index scan Martin Sarsale
• 15:17   Re: seqscan instead of index scan Martin Sarsale
• 15:29   Re: seqscan instead of index scan Merlin Moncure
• 16:09   Re: seqscan instead of index scan Bruno Wolff III
• 16:15   Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud
• 16:19   Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud
• 16:30   Re: Why does a simple query not use an obvious index? Pierre-Frédéric Caillaud
• 16:32   Re: Why does a simple query not use an obvious index? Bruno Wolff III
• 16:37   Re: seqscan instead of index scan Pierre-Frédéric Caillaud
• 17:04   Re: seqscan instead of index scan Stephan Szabo
• 17:18   Re: Why does a simple query not use an obvious index? Greg Stark
• 17:36   Re: seqscan instead of index scan Greg Stark
• 17:48   Re: seqscan instead of index scan Tom Lane
• 18:00   Re: Why does a simple query not use an obvious index? Tom Lane

31 August 2004

• 03:00   Re: Why does a simple query not use an obvious index? Greg Stark
• 12:14   Re: seqscan instead of index scan Martin Sarsale
• 12:27   Performance with Intel Compiler Jean-Max Reymond
• 14:26   odbc/ado problems Kroh István
• 14:33   Re: odbc/ado problems Merlin Moncure
• 15:09   Table UPDATE is too slow Ron St-Pierre
• 15:16   Re: Table UPDATE is too slow Thomas F.O'Connell
• 15:18   Re: Table UPDATE is too slow Steinar H. Gunderson
• 15:22   Re: Table UPDATE is too slow Ron St-Pierre
• 15:34   Re: Table UPDATE is too slow Ron St-Pierre
• 15:46   Re: Table UPDATE is too slow Frank Wiles
• 15:48   Re: Table UPDATE is too slow Steinar H. Gunderson
• 15:59   Optimizing a request Jean-Max Reymond
• 16:00   Re: Table UPDATE is too slow Matt Clark
• 16:01   Re: odbc/ado problems Merlin Moncure
• 16:15   Re: Optimizing a request Josh Berkus
• 16:19   Re: Optimizing a request Jean-Max Reymond
• 16:21   Re: Optimizing a request Gary Doades
• 16:33   Re: Table UPDATE is too slow William Yu
• 16:43   Re: Optimizing a request Jean-Max Reymond
• 17:14   Re: Optimizing a request Tom Lane
• 17:16   Re: Optimizing a request Gary Doades
• 17:24   Re: Optimizing a request Jean-Max Reymond
• 17:26   Re: Optimizing a request Jean-Max Reymond
• 17:31   Re: Optimizing a request Gary Doades
• 17:41   Re: Optimizing a request Hervé Piedvache
• 18:20   Re: Context Switching issue: Spinlock doesn't fix. jelle
• 18:50   Re: Equivalent praxis to CLUSTERED INDEX? Jim C. Nasby
• 19:02   Re: Context Switching issue: Spinlock doesn't fix. Josh Berkus
• 19:05   Re: Equivalent praxis to CLUSTERED INDEX? Jim C. Nasby
• 21:16   Re: Table UPDATE is too slow Ron St-Pierre