Mailing lists [pgsql-performance]

1 April 2003

• 10:23   Re: 30-70 seconds query... alexandre :: aldeia digital
• 15:25   Re: ext3 filesystem / linux 7.3 Jeffrey D. Brower
• 15:39   Re: ext3 filesystem / linux 7.3 Shankar K
• 15:53   Re: ext3 filesystem / linux 7.3 eric soroos
• 15:54   Re: ext3 filesystem / linux 7.3 Bruce Momjian
• 15:55   Re: ext3 filesystem / linux 7.3 Andrew Sullivan
• 16:26   Re: ext3 filesystem / linux 7.3 Bruce Momjian
• 17:27   Postgresql performance on Solaris Scott Buchan
• 18:21   Re: Postgresql performance on Solaris Tom Lane
• 18:36   Re: ext3 filesystem / linux 7.3 Jeffrey D. Brower
• 18:43   Re: ext3 filesystem / linux 7.3 Keith Bottner
• 19:48   Re: Postgresql performance on Solaris scott.marlowe
• 23:34   Re: ext3 filesystem / linux 7.3 Christopher Kings-Lynne
• 23:49   Re: ext3 filesystem / linux 7.3 Sean Chittenden

2 April 2003

• 02:11   Re: ext3 filesystem / linux 7.3 Shridhar Daithankar
• 13:13   Re: ext3 filesystem / linux 7.3 Andreas Kostyrka
• 13:18   Re: ext3 filesystem / linux 7.3 Andreas Kostyrka
• 13:31   Re: ext3 filesystem / linux 7.3 Jeffrey D. Brower
• 13:48   Re: ext3 filesystem / linux 7.3 Andreas Kostyrka
• 13:57   Re: ext3 filesystem / linux 7.3 Andrew Sullivan
• 14:45   Re: ext3 filesystem / linux 7.3 Andreas Pflug
• 15:01   Re: ext3 filesystem / linux 7.3 Jeffrey D. Brower
• 18:05   Re: ext3 filesystem / linux 7.3 Josh Berkus
• 22:23   Re: ext3 filesystem / linux 7.3 Jeffrey D. Brower
• 22:47   Re: ext3 filesystem / linux 7.3 Josh Berkus

3 April 2003

• 00:44   Re: ext3 filesystem / linux 7.3 Chris Hedemark
• 00:58   Re: ext3 filesystem / linux 7.3 Andrew Sullivan
• 03:34   Re: ext3 filesystem / linux 7.3 Josh Berkus
• 03:46   Re: ext3 filesystem / linux 7.3 Seth Robertson
• 08:58   Re: ext3 filesystem / linux 7.3 Chris Hedemark
• 14:08   Re: ext3 filesystem / linux 7.3 Chris Sutton
• 14:52   Re: ext3 filesystem / linux 7.3 Josh Berkus
• 14:59   Re: ext3 filesystem / linux 7.3 Chris Hedemark
• 15:04   Re: ext3 filesystem / linux 7.3 Jeffrey D. Brower
• 15:59   OSS database needed for testing Josh Berkus
• 15:59   Re: ext3 filesystem / linux 7.3 scott.marlowe
• 16:00   Re: ext3 filesystem / linux 7.3 Josh Berkus
• 16:09   Re: [HACKERS] OSS database needed for testing Merlin Moncure
• 16:15   Re: [HACKERS] OSS database needed for testing pgsql@mohawksoft.com
• 17:45   Re: ext3 filesystem / linux 7.3 Shankar K
• 18:23   Re: ext3 filesystem / linux 7.3 scott.marlowe
• 19:01   Re: [HACKERS] OSS database needed for testing Bruno Wolff III
• 20:05   Re: ext3 filesystem / linux 7.3 Will LaShell
• 20:08   Re: [HACKERS] OSS database needed for testing mlw
• 20:20   Re: [HACKERS] OSS database needed for testing Bruno Wolff III
• 21:12   Re: ext3 filesystem / linux 7.3 Josh Berkus

4 April 2003

• 00:36   Re: [HACKERS] OSS database needed for testing Jeffrey D. Brower
• 02:29   Re: [HACKERS] OSS database needed for testing Josh Berkus
• 02:54   Re: [HACKERS] OSS database needed for testing Tom Lane
• 09:01   [OT][ANNOUNCEMENT]Announcing first public release of Open Application Server Shridhar Daithankar
• 09:28   Re: ext3 filesystem / linux 7.3 Andreas Kostyrka
• 10:11   Re: [HACKERS] OSS database needed for testing mlw
• 10:38   Re: [HACKERS] OSS database needed for testing Jeffrey D. Brower
• 12:50   Re: [BUGS] Rapid deteriation of performance (might be caused by Stephan Szabo
• 13:19   Re: [BUGS] Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2 Robert John Shepherd
• 13:29   Re: [BUGS] Rapid deteriation of performance (might be Stephan Szabo
• 14:09   Re: [HACKERS] OSS database needed for testing Josh Berkus
• 14:35   Re: OSS database needed for testing Jeffrey D. Brower
• 15:37   Re: [HACKERS] OSS database needed for testing Josh Berkus
• 15:57   Re: [HACKERS] OSS database needed for testing Merlin Moncure
• 16:08   Re: OSS database needed for testing Josh Berkus
• 17:03   Re: [SQL] can i make this sql query more efficiant? Manfred Koizar
• 17:26   Re: [SQL] can i make this sql query more efficiant? Josh Berkus
• 20:57   Re: ext3 filesystem / linux 7.3 Will LaShell

5 April 2003

• 00:08   Re: [SQL] can i make this sql query more efficiant? Manfred Koizar

7 April 2003

• 13:25   Re: [BUGS] Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2 Robert John Shepherd
• 13:28   Load times on RAID0 compared to RAID5 Howard Oblowitz
• 13:36   Re: Load times on RAID0 compared to RAID5 Andrew Sullivan
• 14:31   Re: Load times on RAID0 compared to RAID5 Josh Berkus
• 14:35   Re: Load times on RAID0 compared to RAID5 scott.marlowe
• 16:17   Re: ext3 filesystem / linux 7.3 Robert Treat

8 April 2003

• 19:23   Re: [GENERAL] Yet Another (Simple) Case of Index not used Dennis Gearon
• 19:26   Re: [GENERAL] Yet Another (Simple) Case of Index not used Dann Corbit
• 19:42   Re: [GENERAL] Yet Another (Simple) Case of Index not used Dennis Gearon
• 20:52   Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus
• 22:22   Re: ext3 filesystem / linux 7.3 Kevin Brown
• 22:46   Re: [GENERAL] Yet Another (Simple) Case of Index not used Martijn van Oosterhout
• 23:12   Re: [GENERAL] Yet Another (Simple) Case of Index not used Denis @ Next2Me
• 23:23   Re: [SQL] Yet Another (Simple) Case of Index not used Denis @ Next2Me

9 April 2003

• 01:00   Re: [SQL] Yet Another (Simple) Case of Index not used Stephan Szabo
• 01:35   Re: [SQL] Yet Another (Simple) Case of Index not used Christopher Kings-Lynne
• 02:18   Re: [GENERAL] Yet Another (Simple) Case of Index not used Martijn van Oosterhout
• 02:38   choosing the right platform Matthew Nuzum
• 04:57   Re: [GENERAL] Yet Another (Simple) Case of Index not used Denis @ Next2Me
• 14:43   [OT][Announce] Availability of OAS Server pakcages Shridhar Daithankar
• 15:11   Re: ext3 filesystem / linux 7.3 Josh Berkus
• 15:19   Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus
• 15:28   Re: choosing the right platform Josh Berkus
• 15:57   Re: choosing the right platform scott.marlowe
• 16:14   Re: choosing the right platform Matthew Nuzum
• 16:20   Re: choosing the right platform eric soroos
• 17:01   Re: choosing the right platform scott.marlowe
• 17:04   Re: choosing the right platform Josh Berkus
• 22:45   Re: choosing the right platform Jim C. Nasby
• 22:47   Re: choosing the right platform Jim C. Nasby
• 22:58   Re: choosing the right platform Jim C. Nasby
• 23:15   Help analyzing 7.2.4 EXPLAIN Josh Berkus
• 23:21   Caching (was Re: choosing the right platform) Tom Lane
• 23:51   Re: Help analyzing 7.2.4 EXPLAIN Tom Lane

10 April 2003

• 00:15   Re: Caching (was Re: choosing the right platform) Matthew Nuzum
• 00:16   Caching (was Re: choosing the right platform) Matthew Nuzum
• 02:39   Re: Help analyzing 7.2.4 EXPLAIN Josh Berkus
• 02:46   Re: Caching (was Re: choosing the right platform) Josh Berkus
• 07:18   Re: Caching (was Re: choosing the right platform) Ron Johnson
• 08:34   Re: Caching (was Re: choosing the right platform) David McKain
• 08:58   Re: Caching (was Re: choosing the right platform) Shridhar Daithankar
• 13:26   Re: Caching (was Re: choosing the right platform) Jean-Luc Lachance
• 13:40   Re: Caching (was Re: choosing the right platform) Tom Lane
• 15:49   Re: choosing the right platform scott.marlowe
• 15:58   Re: choosing the right platform scott.marlowe
• 16:17   Re: choosing the right platform Tom Lane
• 16:21   Reference data for performance testing? Boris Popov
• 16:23   Re: Reference data for performance testing? Josh Berkus
• 16:24   Re: Reference data for performance testing? Boris Popov
• 16:35   Slow Visual Basic application Cecilia Alvarez
• 16:47   Re: Reference data for performance testing? Chris Hedemark
• 17:58   Re: Slow Visual Basic application Patrick Hatcher
• 17:59   Re: Caching (was Re: choosing the right platform) Jean-Luc Lachance
• 22:15   Re: Caching (was Re: choosing the right platform) Ron Mayer
• 23:13   Re: Help analyzing 7.2.4 EXPLAIN Josh Berkus

11 April 2003

• 14:19   Re: Caching (was Re: choosing the right platform) scott.marlowe
• 15:16   Re: Caching (was Re: choosing the right platform) Josh Berkus
• 16:38   Re: Caching (was Re: choosing the right platform) Ron Mayer

12 April 2003

• 16:06   update query blows out shane hill
• 16:17   Re: update query blows out Tom Lane
• 17:06   Re: update query blows out shane hill
• 19:53   Re: update query blows out Tom Lane

14 April 2003

• 00:45   Multicolumn indexes and equal conditions Bruno Wolff III

15 April 2003

• 08:47   for help! linweidong
• 08:54   Re: for help! Shridhar Daithankar
• 13:23   Re: [GENERAL] Yet Another (Simple) Case of Index not used Bruce Momjian
• 14:40   Re: for help! Will LaShell
• 14:49   Do Views offer any performance advantage? Robert John Shepherd
• 15:29   Re: [GENERAL] Yet Another (Simple) Case of Index not used Richard Huxton
• 15:39   Re: for help! scott.marlowe
• 16:26   Re: Do Views offer any performance advantage? Tom Lane
• 18:05   Using indexes for like foo% type queries when foo isn't constant (not a locale issue) Greg Stark
• 18:55   Re: Do Views offer any performance advantage? Andreas Pflug
• 22:37   Re: Do Views offer any performance advantage? Tom Lane

16 April 2003

• 05:10   Is there a performance between Inherits and Views? dex
• 07:45   Re: Do Views offer any performance advantage? Andreas Pflug
• 14:48   Re: for help! Josh Berkus
• 14:53   Re: for help! Andrew Sullivan
• 15:01   Re: for help! Tom Lane
• 15:12   Re: for help! Andrew Sullivan
• 15:26   the RAID question, again Vincent van Leeuwen
• 23:03   dum query plan Jonathan Moore

17 April 2003

• 00:21   Re: dum query plan Stephan Szabo
• 01:32   Re: the RAID question, again Nikolaus Dilger
• 02:15   Re: dum query plan Tom Lane
• 02:21   Re: the RAID question, again Josh Berkus
• 13:11   Re: dum query plan Jean-Luc Lachance
• 14:29   dum query plan: more info. Jonathan Moore
• 15:28   Re: dum query plan: more info. Manfred Koizar
• 15:31   Re: dum query plan: more info. Tom Lane
• 16:48   Performance of Inherits versus Views dex
• 18:17   Query speed problems Victor Danilchenko
• 18:38   Re: Query speed problems Victor Danilchenko
• 18:55   Re: Query speed problems Stephan Szabo
• 18:59   Re: Query speed problems Peter Darley
• 19:24   Re: Query speed problems Victor Danilchenko
• 19:30   Re: Query speed problems Victor Danilchenko
• 20:08   Re: Query speed problems Stephan Szabo

18 April 2003

• 00:26   Re: Query speed problems Nikolaus Dilger
• 04:11   Foreign key performance Kevin Brown
• 04:30   Re: Foreign key performance Stephan Szabo
• 05:06   Re: [HACKERS] Foreign key performance Tom Lane
• 05:25   Re: [HACKERS] Foreign key performance Stephan Szabo
• 14:01   Re: Query speed problems Victor Danilchenko

19 April 2003

• 12:01   Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown
• 14:58   Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane
• 18:04   Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus
• 19:26   Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane

20 April 2003

• 00:13   Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown
• 02:34   Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane
• 05:28   Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown
• 09:07   Re: [SQL] Yet Another (Simple) Case of Index not used Andreas Pflug
• 14:21   Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane
• 14:25   Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane
• 14:38   Re: [SQL] Yet Another (Simple) Case of Index not used Andreas Pflug
• 15:46   Re: [SQL] Yet Another (Simple) Case of Index not used Andrew Sullivan
• 17:09   problems Ian Knopke
• 17:36   Re: problems Tom Lane
• 23:46   Re: [SQL] Yet Another (Simple) Case of Index not used Kevin Brown

21 April 2003

• 00:53   Re: [SQL] Yet Another (Simple) Case of Index not used Tom Lane
• 15:15   Re: [SQL] Yet Another (Simple) Case of Index not used Josh Berkus

22 April 2003

• 07:23   Re: [SQL] Yet Another (Simple) Case of Index not used Jim C. Nasby
• 07:30   Re: choosing the right platform Jim C. Nasby
• 07:33   Re: [SQL] Yet Another (Simple) Case of Index not used Christopher Kings-Lynne
• 11:11   Re: the RAID question, again Vincent van Leeuwen
• 16:19   Re: the RAID question, again Josh Berkus
• 16:34   Re: the RAID question, again scott.marlowe
• 16:45   Re: the RAID question, again Will LaShell

23 April 2003

• 15:34   Re: [SQL] Yet Another (Simple) Case of Index not used Greg Stark
• 16:58   Important speed difference between a query and a function with the same query Frederic Jolliton

24 April 2003

• 14:47   Re: Important speed difference between a query and a Frederic Jolliton
• 14:57   Re: Important speed difference between a query and a Tom Lane
• 14:57   Re: Important speed difference between a query and a Stephan Szabo
• 15:33   Re: Important speed difference between a query and a Frederic Jolliton
• 15:41   Re: Important speed difference between a query and a Frederic Jolliton
• 16:28   Re: Important speed difference between a query and a Stephan Szabo
• 16:40   Re: Important speed difference between a query and a Frederic Jolliton
• 22:38   More tablescanning fun Jim C. Nasby
• 22:58   Re: More tablescanning fun Tom Lane

25 April 2003

• 03:59   Re: More tablescanning fun Jim C. Nasby
• 04:23   Re: More tablescanning fun Tom Lane
• 06:01   Re: Important speed difference between a query and a Hannu Krosing
• 13:38   Re: More tablescanning fun Jim C. Nasby
• 14:09   Re: Important speed difference between a query and a function with the same query Jim C. Nasby
• 15:28   Re: More tablescanning fun Hannu Krosing
• 15:56   Re: More tablescanning fun Jim C. Nasby
• 19:10   Re: More tablescanning fun Tom Lane
• 21:33   Indexes with different datatypes Cecilia Alvarez
• 21:36   Indexes with different datatypes:Correction Cecilia Alvarez
• 21:49   Re: Indexes with different datatypes:Correction scott.marlowe

26 April 2003

• 14:15   Automatic analyze on select into Jim C. Nasby
• 15:18   Re: Automatic analyze on select into Tom Lane
• 17:16   Re: Automatic analyze on select into Jim C. Nasby
• 17:40   Re: Automatic analyze on select into Tom Lane

27 April 2003

• 05:50   Re: More tablescanning fun Hannu Krosing

28 April 2003

• 01:30   pgsql BLOB issues Jeremy Andrus
• 04:00   Re: pgsql BLOB issues Tom Lane
• 04:33   Re: pgsql BLOB issues Jeremy Andrus
• 07:20   Re: pgsql BLOB issues Christopher Kings-Lynne
• 09:39   Diferent execution plan for similar query 
• 09:41   Re: Diferent execution plan for similar query Shridhar Daithankar
• 09:59   Re: Diferent execution plan for similar query Magnus Naeslund(w)
• 10:00   Re: Diferent execution plan for similar query Magnus Naeslund(w)
• 10:01   Re: Diferent execution plan for similar query Shridhar Daithankar
• 10:12   Re: Diferent execution plan for similar query Andrew Sullivan
• 17:21   How to get the optimizer to use an index with multiple fields Jim C. Nasby
• 17:32   Re: How to get the optimizer to use an index with multiple fields Jim C. Nasby
• 19:04   Re: How to get the optimizer to use an index with multiple scott.marlowe
• 21:54   Re: How to get the optimizer to use an index with multiple Jim C. Nasby

29 April 2003

• 06:01   Is 292 inserts/sec acceptable performance ? Rajesh Kumar Mallah
• 06:26   Re: Is 292 inserts/sec acceptable performance ? Shridhar Daithankar
• 08:03   Optimizer not using index when it should Rob Messer
• 10:12   Re: Is 292 inserts/sec acceptable performance ? Rajesh Kumar Mallah
• 10:24   profiling plpgsql functions.. Rajesh Kumar Mallah
• 12:04   Re: Optimizer not using index when it should Rod Taylor
• 12:35   Query Plan far worse in 7.3.2 than 7.2.1 SZŰCS Gábor
• 12:53   Best ODBC cursor and lock types for fastest reading? Robert John Shepherd
• 13:01   Re: Is 292 inserts/sec acceptable performance ? Tom Lane
• 13:18   Re: Optimizer not using index when it should Tom Lane
• 13:28   Re: profiling plpgsql functions.. Tom Lane
• 13:53   Re: Query Plan far worse in 7.3.2 than 7.2.1 Tom Lane
• 14:40   Re: Best ODBC cursor and lock types for fastest reading? Josh Berkus
• 14:44   Re: Best ODBC cursor and lock types for fastest reading? Robert John Shepherd
• 14:49   Re: Is 292 inserts/sec acceptable performance ? 
• 14:57   Re: profiling plpgsql functions.. 
• 15:02   Re: profiling plpgsql functions.. Tom Lane
• 15:04   Re: Query Plan far worse in 7.3.2 than 7.2.1 SZŰCS Gábor
• 22:05   Re: Query Plan far worse in 7.3.2 than 7.2.1 Tom Lane

30 April 2003

• 05:04   Why LIMIT after scanning the table? Jim C. Nasby
• 06:38   Re: Is 292 inserts/sec acceptable performance ? Rajesh Kumar Mallah
• 10:00   Re: Query Plan far worse in 7.3.2 than 7.2.1 SZŰCS Gábor
• 13:17   Re: More tablescanning fun Manfred Koizar
• 13:19   Re: Why LIMIT after scanning the table? Stephan Szabo
• 13:22   Re: Why LIMIT after scanning the table? Tom Lane
• 13:40   Query Plan far worse in 7.3.2 than 7.2.1 Peter Darley
• 13:54   Re: Query Plan far worse in 7.3.2 than 7.2.1 Tom Lane
• 14:14   Re: Query Plan far worse in 7.3.2 than 7.2.1 Peter Darley
• 15:03   Re: [SQL] 7.3 analyze & vacuum analyze problem Josh Berkus
• 15:11   Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios
• 15:22   Re: Why LIMIT after scanning the table? Jean-Luc Lachance
• 15:34   Like search performance. Diehl, Jeffrey
• 16:08   Re: Like search performance. Nikolaus Dilger
• 16:26   Re: Like search performance. SZUCS Gábor
• 16:33   Re: Like search performance. Josh Berkus
• 17:48   Re: [SQL] 7.3 analyze & vacuum analyze problem Josh Berkus
• 21:25   Re: [SQL] 7.3 analyze & vacuum analyze problem Ron Mayer
• 23:10   Re: [SQL] 7.3 analyze & vacuum analyze problem Tom Lane