Mailing lists [pgsql-performance]

1 August 2004

• 11:42   SSD Drives Greg Stark

2 August 2004

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

3 August 2004

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

4 August 2004

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

5 August 2004

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

6 August 2004

• 03:41   Re: my boss want to migrate to ORACLE Mischa Sandberg
• 03:58   pg_dump performance? Jesper Krogh
• 04:43   Re: pg_dump performance? Christopher Kings-Lynne
• 05:05   Re: pg_dump performance? Jesper Krogh
• 16:11   Re: Tuning queries on large database Gaetano Mendola
• 16:11   Re: [GENERAL] Tuning queries on large database Gaetano Mendola
• 16:11   Re: Temporary tables Gaetano Mendola
• 16:11   Re: Performance Bottleneck Gaetano Mendola
• 16:17   Re: The black art of postgresql.conf tweaking Gaetano Mendola
• 16:30   Re: The black art of postgresql.conf tweaking Josh Berkus
• 17:07   Re: Performance Bottleneck Mike Benoit
• 18:30   Re: The black art of postgresql.conf tweaking Gaetano Mendola
• 23:01   Re: Performance Bottleneck Martin Foster
• 23:19   Re: The black art of postgresql.conf tweaking Josh Berkus
• 23:30   Re: Performance Bottleneck Martin Foster
• 23:30   Re: Performance Bottleneck Gaetano Mendola
• 23:43   Re: The black art of postgresql.conf tweaking Gaetano Mendola

7 August 2004

• 00:01   Re: Performance Bottleneck Tom Lane
• 00:30   Question about Generating Possible Plans by the planner/optimizer sandra ruiz
• 00:56   Re: Performance Bottleneck Scott Marlowe
• 01:13   Re: Question about Generating Possible Plans by the planner/optimizer Steinar H. Gunderson
• 04:13   Re: Performance Bottleneck Martin Foster
• 04:38   Re: Performance Bottleneck Scott Marlowe
• 04:45   Re: Performance Bottleneck Martin Foster
• 10:04   Re: Performance Bottleneck Gaetano Mendola
• 10:12   Re: Performance Bottleneck Gaetano Mendola
• 10:50   Re: Performance Bottleneck Christopher Kings-Lynne
• 14:21   Re: Performance Bottleneck Jan Wieck

8 August 2004

• 05:29   Re: Performance Bottleneck Martin Foster
• 05:41   Re: Performance Bottleneck Martin Foster
• 08:21   Re: Performance Bottleneck Mike Benoit
• 12:10   Re: Performance Bottleneck Jeff
• 13:53   Re: Performance Bottleneck Jan Wieck
• 14:30   Re: Performance Bottleneck Matt Clark
• 15:49   Re: Performance Bottleneck Martin Foster
• 16:03   Re: Performance Bottleneck Arjen van der Meijden
• 18:40   Re: Performance Bottleneck Martin Foster

9 August 2004

• 01:07   Re: Performance Bottleneck Tatsuo Ishii
• 01:09   Re: Performance Bottleneck Tatsuo Ishii
• 03:06   performance with column orders Jim Thomason
• 14:28   Re: The black art of postgresql.conf tweaking Paul Serby
• 14:47   Re: The black art of postgresql.conf tweaking Shridhar Daithankar
• 15:30   tablespaces and ramdisks Merlin Moncure
• 16:35   Re: tablespaces and ramdisks Tom Lane
• 16:59   Help specifying new machine Rory Campbell-Lange
• 20:08   Re: Help specifying new machine Bill Montgomery

10 August 2004

• 00:06   insert waits for delete with trigger Litao Wu
• 00:31   Re: insert waits for delete with trigger Tom Lane
• 04:36   Re: insert waits for delete with trigger Litao Wu
• 04:41   Re: insert waits for delete with trigger Tom Lane
• 13:39   Column order performance Bill Montgomery
• 14:54   Re: insert waits for delete with trigger Litao Wu
• 15:45   Re: Performance Bottleneck Alex Hayward
• 16:31   Re: [HACKERS] fsync vs open_sync Merlin Moncure
• 17:33   Re: The black art of postgresql.conf tweaking CoL
• 17:43   Slow select, insert, update Paul Langard
• 17:46   Re: [HACKERS] fsync vs open_sync pgsql@mohawksoft.com
• 21:13   Re: Slow select, insert, update Doug McNaught
• 22:01   Re: Performance Bottleneck matt@ymogen.net
• 22:53   Hardware upgrade for a high-traffic database Jason Coene
• 23:12   Re: Slow select, insert, update Bill Montgomery
• 23:20   Re: Column order performance Bill Montgomery
• 23:54   Re: Slow select, insert, update Tom Lane

11 August 2004

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

12 August 2004

• 00:04   Buld Insert and Index use. Rudi Starcevic
• 00:12   Re: [HACKERS] fsync vs open_sync Gaetano Mendola
• 00:26   Re: Buld Insert and Index use. Josh Berkus
• 00:29   Re: Hardware upgrade for a high-traffic database Jason Coene
• 02:09   Re: Hardware upgrade for a high-traffic database Tom Lane
• 06:49   Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud
• 10:38   Re: [GENERAL] How to know which queries are to be optimised? Ulrich Wisser
• 11:16   Re: [GENERAL] How to know which queries are to be optimised? Richard Huxton
• 13:39   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 14:08   Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne
• 14:09   Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne
• 17:50   Re: Hardware upgrade for a high-traffic database Tom Lane
• 18:10   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 18:58   Re: Hardware upgrade for a high-traffic database gnari
• 19:33   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 20:03   Re: Hardware upgrade for a high-traffic database Merlin Moncure
• 22:41   Re: Help specifying new machine William Yu
• 22:52   Re: [GENERAL] How to know which queries are to be optimised? Rudi Starcevic

13 August 2004

• 07:47   insert Ulrich Wisser
• 10:09   Re: insert G u i d o B a r o s i o
• 10:47   Re: insert gnari
• 11:16   Re: insert G u i d o B a r o s i o
• 11:45   Re: insert gnari
• 12:10   Re: insert Ulrich Wisser
• 12:41   Re: insert Paul Thomas
• 12:58   Re: insert Rod Taylor
• 14:44   Weird Database Performance problem! Arash Zaryoun
• 14:54   Re: insert Bruno Wolff III
• 15:08   Re: Help specifying new machine Raoul Buzziol
• 15:37   Re: [HACKERS] fsync vs open_sync pgsql@mohawksoft.com
• 15:42   Re: fsync vs open_sync pgsql@mohawksoft.com
• 15:44   Performance Problem With Postgresql! Arash Zaryoun
• 16:00   Re: Weird Database Performance problem! Richard Huxton
• 16:23   Re: insert Bruno Wolff III
• 17:14   Re: insert Matt Clark
• 17:43   Reiser4 Pierre-Frédéric Caillaud
• 18:10   Re: fsync vs open_sync Pierre-Frédéric Caillaud
• 18:44   Re: insert Tom Lane
• 18:46   Re: Reiser4 Josh Berkus
• 19:09   Re: Performance Problem With Postgresql! Josh Berkus
• 20:29   Re: fsync vs open_sync Merlin Moncure
• 21:05   Re: Weird Database Performance problem! Richard Huxton
• 21:58   REINDEX needed because of index corruption need help ASAP borajetta
• 22:38   Re: REINDEX needed because of index corruption need help ASAP Tom Lane
• 22:41   Re: REINDEX needed because of index corruption need help ASAP Josh Berkus

14 August 2004

• 01:27   Replication: Slony-I vs. Mammoth Replicator vs. ? Chris Cheston
• 01:31   Re: Reiser4 Bruce Momjian
• 01:34   Re: Reiser4 Bruce Momjian
• 01:42   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake
• 14:41   Re: insert Gaetano Mendola
• 15:33   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Jan Wieck
• 16:31   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake
• 17:56   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Jan Wieck
• 20:07   Re: [HACKERS] Reiser4 Peter Eisentraut
• 21:11   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Christopher Browne

15 August 2004

• 00:58   Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake
• 03:11   Faster with a sub-query then without Martin Foster
• 03:55   Re: Faster with a sub-query then without Tom Lane
• 16:00   Slow joins against set-returning functions Michael Fuhr
• 16:01   Re: Faster with a sub-query then without Martin Foster
• 17:21   Re: Slow joins against set-returning functions Tom Lane
• 17:48   Help interpreting explain analyze output Ole Tange
• 18:21   Re: Help interpreting explain analyze output Tom Lane
• 18:33   Re: Help interpreting explain analyze output Richard Poole
• 19:08   Re: Help interpreting explain analyze output Ole Tange
• 19:40   Re: Help interpreting explain analyze output Tom Lane
• 20:12   Re: Help specifying new machine William Yu

16 August 2004

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

17 August 2004

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

18 August 2004

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

19 August 2004

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

20 August 2004

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

21 August 2004

• 00:59   Re: Query Performance Brad Bulger

22 August 2004

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

23 August 2004

• 14:33   postgresql 8.0 beta - fail to collect statsistic my thi ho
• 19:01   Re: postgresql 8.0 beta - fail to collect statsistic Tom Lane
• 21:52   Re: postgresql 8.0 beta - fail to collect statsistic Steve Bergman
• 22:30   Re: postgresql 8.0 beta - fail to collect statsistic Tom Lane

24 August 2004

• 00:02   How do I see what triggers are called on cascade? andrew@pillette.com
• 02:50   Re: How do I see what triggers are called on cascade? Tom Lane
• 05:15   Re: postgresql performance with multimedia my ho
• 08:33   Query kills machine. Stef
• 09:08   Re: Query kills machine. Christopher Kings-Lynne
• 11:59   Re: postgresql performance with multimedia Jan Wieck
• 13:30   Re: Query kills machine. Stef
• 14:15   Re: Query kills machine. Magnus Naeslund(pg)
• 15:23   Re: Query kills machine. Tom Lane
• 16:31   [FUN] Performance increase? Gaetano Mendola
• 18:48   Re: Query kills machine. Magnus Naeslund(t)
• 18:48   What is the best way to do attribute/values? Daniel Ceregatti
• 20:30   Re: What is the best way to do attribute/values? Josh Berkus
• 21:00   Re: What is the best way to do attribute/values? Richard Huxton

25 August 2004

• 06:54   Re: postgresql performance with multimedia my ho
• 07:14   Re: postgresql performance with multimedia Gregory S. Williamson
• 08:19   Re: What is the best way to do attribute/values? Mark Kirkwood
• 11:02   Re: postgresql performance with multimedia Jan Wieck
• 11:26   OT: Network config (WAS: RE: postgresql performance with multimedia) Leeuw van der, Tim
• 12:35   Re: What is the best way to do attribute/values? Jeff
• 13:06   Re: What is the best way to do attribute/values? Leeuw van der, Tim
• 14:31   Re: Query kills machine. Stef
• 15:06   Optimizer Selecting Incorrect Index David Price
• 15:47   Re: Optimizer Selecting Incorrect Index Richard Huxton
• 16:59   Re: What is the best way to do attribute/values? Josh Berkus
• 19:08   Re: Optimizer Selecting Incorrect Index Tom Lane
• 21:09   Anyone familiar with Apple Xserve RAID Robert Treat
• 21:22   Re: Anyone familiar with Apple Xserve RAID Josh Berkus
• 22:48   TSearch2 and optimisation ... Hervé Piedvache
• 22:52   Re: Anyone familiar with Apple Xserve RAID Doug McNaught
• 23:49   Re: Anyone familiar with Apple Xserve RAID Josh Berkus
• 23:51   Re: TSearch2 and optimisation ... Josh Berkus

26 August 2004

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

27 August 2004

• 01:45   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 03:39   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 04:35   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 06:27   Re: postgresql performance with multimedia my ho
• 06:54   Query performance issue with 8.0.0beta1 Stefano Bonnin
• 08:32   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 08:49   Re: Query performance issue with 8.0.0beta1 Russell Smith
• 16:24   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 16:31   Re: Equivalent praxis to CLUSTERED INDEX? Josh Berkus
• 16:32   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 16:51   Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar
• 16:52   Re: Query performance issue with 8.0.0beta1 andrew@pillette.com
• 17:15   Re: Query performance issue with 8.0.0beta1 Josh Berkus
• 17:27   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 17:39   Re: Equivalent praxis to CLUSTERED INDEX? Jeremy Dunn
• 17:40   Re: Equivalent praxis to CLUSTERED INDEX? Adi Alurkar
• 17:49   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 18:19   Re: Equivalent praxis to CLUSTERED INDEX? Tom Lane
• 19:29   Why those queries do not utilize indexes? Artimenko Igor
• 19:31   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 19:35   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 19:43   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 19:49   Re: Why those queries do not utilize indexes? Dennis Bjorklund
• 20:34   Re: Anyone familiar with Apple Xserve RAID Vivek Khera
• 21:09   Re: Why those queries do not utilize indexes? Artimenko Igor

28 August 2004

• 01:32   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 02:08   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 03:55   Re: Equivalent praxis to CLUSTERED INDEX? Bruce Momjian
• 08:15   Re: Equivalent praxis to CLUSTERED INDEX? Greg Stark
• 08:51   Re: Why those queries do not utilize indexes? Christopher Kings-Lynne
• 11:15   ill-planned queries inside a stored procedure Gaetano Mendola
• 12:02   Re: Equivalent praxis to CLUSTERED INDEX? Gaetano Mendola
• 15:13   Re: ill-planned queries inside a stored procedure andrew@pillette.com
• 16:35   Re: ill-planned queries inside a stored procedure Gaetano Mendola
• 17:42   Performance hit on loading from HD Vitaly Belman
• 21:33   Re: Performance hit on loading from HD Josh Berkus

29 August 2004

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

30 August 2004

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

31 August 2004

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