Mailing lists [pgsql-performance]

1 January 2004

• 16:15   pg_restore makes disk busy cnliou

2 January 2004

• 02:34   Very slow update + not using clustered index Mike Glover
• 03:07   Re: Very slow update + not using clustered index Tom Lane
• 05:17   Re: Very slow update + not using clustered index Mike Glover
• 08:44   Why memory is not used ? Why vacuum so slow ? Hervé Piedvache
• 12:04   Tuning Techniques To Avoid? Christopher Browne
• 13:43   Re: Why memory is not used ? Why vacuum so slow ? Tom Lane
• 15:52   Re: Why memory is not used ? Why vacuum so slow ? Hervé Piedvache
• 21:29   Re: Why memory is not used ? Why vacuum so slow ? Tom Lane
• 21:29   Re: Very slow update + not using clustered index Tom Lane

3 January 2004

• 01:54   Re: Tuning Techniques To Avoid? Greg Stark
• 04:38   "fun with multipart primary keys" hobby kit Chris Trawick
• 04:58   Re: "fun with multipart primary keys" hobby kit Tom Lane
• 05:08   Re: "fun with multipart primary keys" hobby kit Chris Trawick
• 05:50   Re: deferred foreign keys Christopher Kings-Lynne

4 January 2004

• 00:19   Indexing a Boolean or Null column? D. Dante Lorenso
• 03:27   Re: Indexing a Boolean or Null column? Tom Lane
• 03:33   Re: Indexing a Boolean or Null column? Christopher Kings-Lynne
• 04:25   Re: Indexing a Boolean or Null column? D. Dante Lorenso
• 06:21   Re: Indexing a Boolean or Null column? Christopher Kings-Lynne
• 06:23   Re: Indexing a Boolean or Null column? Christopher Kings-Lynne
• 06:49   Re: Indexing a Boolean or Null column? Tom Lane
• 21:05   Re: Indexing a Boolean or Null column? Christopher Browne
• 22:37   Use my (date) index, darn it! John Siracusa

5 January 2004

• 05:56   Re: Use my (date) index, darn it! Tom Lane
• 10:29   optimizing Postgres queries David Teran
• 10:37   Re: optimizing Postgres queries Shridhar Daithankar
• 11:05   Re: optimizing Postgres queries David Teran
• 11:11   Re: optimizing Postgres queries Shridhar Daithankar
• 11:18   Re: optimizing Postgres queries David Teran
• 11:39   Re: optimizing Postgres queries Shridhar Daithankar
• 14:16   Re: optimizing Postgres queries Christopher Kings-Lynne
• 14:23   Re: optimizing Postgres queries Tom Lane
• 15:19   Re: Use my (date) index, darn it! John Siracusa
• 15:30   Re: Use my (date) index, darn it! Tom Lane
• 15:34   Re: deferred foreign keys Vivek Khera
• 16:05   Re: Use my (date) index, darn it! Christopher Browne
• 17:17   Re: Use my (date) index, darn it! John Siracusa
• 17:39   Re: deferred foreign keys Bruno Wolff III
• 17:48   Re: optimizing Postgres queries David Teran
• 17:54   Re: optimizing Postgres queries Tom Lane
• 17:58   Re: deferred foreign keys Vivek Khera
• 17:58   Re: deferred foreign keys Stephan Szabo
• 18:02   Re: deferred foreign keys Vivek Khera
• 18:02   Re: optimizing Postgres queries David Teran
• 18:03   Select max(foo) and select count(*) optimization John Siracusa
• 18:06   Re: optimizing Postgres queries Tom Lane
• 18:21   Re: optimizing Postgres queries David Teran
• 18:49   Re: deferred foreign keys Stephan Szabo
• 18:53   Re: Select max(foo) and select count(*) optimization Rod Taylor
• 19:01   Re: Select max(foo) and select count(*) optimization John Siracusa
• 19:15   Re: deferred foreign keys Rod Taylor
• 19:24   Re: Select max(foo) and select count(*) optimization Neil Conway
• 19:35   Re: Use my (date) index, darn it! Christopher Browne
• 19:35   Re: Select max(foo) and select count(*) optimization Christopher Browne
• 21:34   Re: deferred foreign keys Stephan Szabo
• 23:22   Re: Select max(foo) and select count(*) optimization Paul Tuckfield
• 23:41   Re: Select max(foo) and select count(*) optimization Doug McNaught

6 January 2004

• 01:05   Re: Select max(foo) and select count(*) optimization Christopher Browne
• 01:35   Re: Select max(foo) and select count(*) optimization Christopher Browne
• 04:26   Re: optimizing Postgres queries Bruce Momjian
• 05:33   Re: Select max(foo) and select count(*) optimization Shridhar Daithankar
• 05:44   Re: Select max(foo) and select count(*) optimization Shridhar Daithankar
• 11:18   Re: Select max(foo) and select count(*) optimization D'Arcy J.M. Cain
• 11:21   Re: Select max(foo) and select count(*) optimization Shridhar Daithankar
• 14:41   Inefficient SELECT with OFFSET and LIMIT Clive Page
• 15:04   Re: Select max(foo) and select count(*) optimization Robert Treat
• 15:34   Re: Select max(foo) and select count(*) optimization Shridhar Daithankar
• 17:13   Re: Inefficient SELECT with OFFSET and LIMIT Greg Stark
• 17:37   Re: Inefficient SELECT with OFFSET and LIMIT Tom Lane
• 18:29   Re: Select max(foo) and select count(*) optimization Mark Kirkwood
• 19:50   PgAdmin startup query VERY slow Michael Shapiro
• 20:30   Re: PgAdmin startup query VERY slow Josh Berkus
• 20:33   Re: PgAdmin startup query VERY slow Michael Shapiro
• 20:42   Re: PgAdmin startup query VERY slow Josh Berkus
• 21:57   Re: Select max(foo) and select count(*) optimization D'Arcy J.M. Cain
• 22:13   Re: PgAdmin startup query VERY slow Tom Lane
• 22:20   Re: Select max(foo) and select count(*) optimization Tom Lane

7 January 2004

• 16:15   Index creation Eric Jain
• 16:19   Find original number of rows before applied LIMIT/OFFSET? D. Dante Lorenso
• 16:27   Re: Index creation Jeff
• 18:42   Re: Find original number of rows before applied LIMIT/OFFSET? Greg Stark
• 18:47   RAID array stripe sizes Greg Stark
• 19:10   Re: Index creation scott.marlowe
• 22:06   failures on machines using jfs Andrew Sullivan

8 January 2004

• 18:17   Re: failures on machines using jfs Josh Berkus

9 January 2004

• 01:50   Re: optimizing Postgres queries David Teran
• 01:51   Re: Select max(foo) and select count(*) optimization CoL
• 01:51   Slow query problem Bradley Tate
• 01:51   Re: optimizing Postgres queries Tom Lane
• 02:29   Re: Slow query problem Mike Glover
• 03:19   PostgreSQL vs. Oracle disk space usage Seum-Lim Gan
• 03:24   Re: Slow query problem Bruno Wolff III
• 04:13   Re: Slow query problem Tom Lane
• 06:30   Re: Slow query problem Dennis Björklund
• 07:55   Re: Slow query problem Richard Huxton
• 07:57   Re: Slow query problem Dennis Björklund
• 08:19   Re: Slow query problem Richard Huxton
• 15:26   Re: Slow query problem Bradley Tate
• 15:42   Re: Slow query problem Tom Lane
• 16:16   Re: Slow query problem Stephan Szabo

10 January 2004

• 02:30   Re: failures on machines using jfs Robert Creager

11 January 2004

• 01:36   Re: failures on machines using jfs Christopher Browne
• 14:54   Postgresql on Quad CPU machine D. Dante Lorenso
• 15:08   Re: Postgresql on Quad CPU machine Doug McNaught
• 15:18   Re: failures on machines using jfs Spiegelberg, Greg
• 16:05   Re: failures on machines using jfs Tom Lane
• 17:11   COUNT & Pagination David Shadovitz
• 18:16   Re: optimizing Postgres queries Rod Taylor
• 18:20   Explain not accurate Richard van den Berg
• 18:55   Re: Explain not accurate Dennis Bjorklund
• 20:00   Re: COUNT & Pagination Jeff Fitzmyers
• 23:22   Re: Explain not accurate Christopher Kings-Lynne
• 23:36   Re: COUNT & Pagination Christopher Kings-Lynne

12 January 2004

• 01:56   Re: Explain not accurate Greg Stark
• 02:04   annoying query/planner choice Andrew Rawnsley
• 02:50   Re: annoying query/planner choice Dennis Bjorklund
• 03:04   Re: annoying query/planner choice Andrew Rawnsley
• 03:06   Re: annoying query/planner choice Christopher Browne
• 04:40   Re: annoying query/planner choice Tom Lane
• 09:17   Re: COUNT & Pagination Richard Huxton
• 14:01   Re: annoying query/planner choice Andrew Rawnsley
• 14:39   Re: COUNT & Pagination David Shadovitz
• 15:13   Re: failures on machines using jfs Hannu Krosing
• 16:04   Re: failures on machines using jfs Greg Spiegelberg
• 20:47   Re: COUNT & Pagination Robert Treat

13 January 2004

• 02:08   Ignore Some Updates cnliou
• 04:00   Re: Ignore Some Updates Tom Lane
• 11:46   Re: failures on machines using jfs Hannu Krosing
• 11:59   Re: failures on machines using jfs Bill Moran
• 14:04   Re: failures on machines using jfs Greg Spiegelberg
• 15:05   freebsd 5.2 and max_connections David Hill
• 16:14   Re: freebsd 5.2 and max_connections Richard Huxton
• 16:33   Re: COUNT & Pagination mallah@trade-india.com
• 16:54   Re: COUNT & Pagination David Shadovitz
• 17:17   Re: COUNT & Pagination scott.marlowe

14 January 2004

• 11:47   100 simultaneous connections, critical limit? Jón Ragnarsson
• 12:02   Re: 100 simultaneous connections, critical limit? Shridhar Daithankar
• 12:36   Re: 100 simultaneous connections, critical limit? Christopher Browne
• 12:43   Re: 100 simultaneous connections, critical limit? Jón Ragnarsson
• 13:01   Re: 100 simultaneous connections, critical limit? Nick Barr
• 14:05   Re: 100 simultaneous connections, critical limit? Tom Lane
• 16:29   Re: 100 simultaneous connections, critical limit? scott.marlowe
• 17:01   Re: 100 simultaneous connections, critical limit? Adam Alkins
• 17:15   Re: COUNT & Pagination Rajesh Kumar Mallah
• 17:37   Re: 100 simultaneous connections, critical limit? Evil Azrael
• 20:39   Re: 100 simultaneous connections, critical limit? scott.marlowe
• 20:43   Re: COUNT & Pagination scott.marlowe

15 January 2004

• 00:24   Re: 100 simultaneous connections, critical limit? Christopher Kings-Lynne
• 01:57   Re: 100 simultaneous connections, critical limit? Andrew McMillan
• 12:57   insert speed - Mac OSX vs Redhat Syd
• 13:17   Re: insert speed - Mac OSX vs Redhat Matt Clark
• 13:25   Trigger question pginfo
• 14:45   Re: insert speed - Mac OSX vs Redhat Tom Lane
• 14:58   Weird query speed Rigmor Ukuhe
• 15:11   Re: Trigger question Richard Huxton
• 15:41   Re: Weird query speed Tom Lane
• 16:10   Re: Trigger question Evil Azrael
• 20:18   Re: insert speed - Mac OSX vs Redhat Syd
• 22:52   shared_buffer value Anjan Dave
• 23:18   Re: shared_buffer value Richard Huxton
• 23:52   Re: shared_buffer value Tom Lane

16 January 2004

• 01:29   IDE/SCSI disk tools to turn off write caching Syd
• 05:25   Re: 100 simultaneous connections, critical limit? Thomas Swan
• 09:26   Re: Trigger question Chris Travers
• 12:05   Re: Trigger question Harald Fuchs
• 15:40   Re: shared_buffer value Anjan Dave
• 15:47   Re: COUNT & Pagination CoL
• 15:47   Postgres on Netapp Shankar K
• 15:47   100 simultaneous connections, critical limit? Jón Ragnarsson
• 15:47   subquery and table join, index not use for table CoL
• 15:47   Question about space usage: Jeremy M. Guthrie
• 15:47   Join optimisation Quandry Ceri Storey
• 15:58   Re: Postgres on Netapp Larry Rosenman
• 16:05   Re: Postgres on Netapp Rod Taylor
• 16:24   Re: shared_buffer value scott.marlowe
• 16:49   Re: subquery and table join, index not use for table Stephan Szabo
• 17:18   Re: Join optimisation Quandry Stephan Szabo
• 18:26   Re: Question about space usage: Tom Lane
• 19:38   Potential Problem with PostgeSQL performance on SuSE Linux 9.0 Josh Berkus
• 21:11   Re: Potential Problem with PostgeSQL performance on SuSE Mark Kirkwood

17 January 2004

• 00:15   Re: Potential Problem with PostgeSQL performance on SuSE Josh Berkus
• 00:51   Re: Potential Problem with PostgeSQL performance on SuSE Mark Kirkwood
• 05:06   Re: Join optimisation Quandry Stephan Szabo
• 14:35   Idle postmaster taking up a lot of CPU John Siracusa
• 15:55   Re: Postgres on Netapp D'Arcy J.M. Cain
• 16:33   Re: Idle postmaster taking up a lot of CPU Tom Lane
• 20:35   Re: Idle postmaster taking up a lot of CPU John Siracusa

18 January 2004

• 19:48   Re: Join optimisation Quandry Ceri Storey
• 19:57   Re: Join optimisation Quandry Ceri Storey
• 20:09   Re: Join optimisation Quandry Ceri Storey

19 January 2004

• 01:21   Re: Join optimisation Quandry Tom Lane
• 22:59   Re: COUNT & Pagination Neil Conway
• 23:01   Re: Trigger question Neil Conway

20 January 2004

• 07:14   Re: Trigger question Richard Huxton
• 14:18   Re: Trigger question Neil Conway
• 15:03   Re: Trigger question Tom Lane
• 15:16   Re: Trigger question Harald Fuchs
• 15:31   Re: Trigger question Stephan Szabo
• 15:44   Re: Trigger question Tom Lane
• 18:06   Re: Trigger question Richard Huxton
• 19:16   database profiling Orion Henry

21 January 2004

• 00:45   Re: database profiling Christopher Kings-Lynne
• 08:34   Really slow even after vacuum Jeroen Baekelandt
• 09:12   Re: PostgreSQL vs. Oracle disk space usage Thierry Missimilly
• 09:43   Re: Really slow even after vacuum Dennis Bjorklund
• 12:51   Re: Trigger question Harald Fuchs
• 15:51   Re: Trigger question Stephan Szabo
• 16:19   ORDER BY and LIMIT with SubSelects Ron St-Pierre
• 17:50   Queries with timestamps Arnau
• 18:03   Re: ORDER BY and LIMIT with SubSelects Bruno Wolff III
• 18:30   Re: Queries with timestamps Josh Berkus
• 19:39   Re: Queries with timestamps Richard Huxton
• 19:59   Re: Queries with timestamps Josh Berkus

22 January 2004

• 09:48   Trigger performance pginfo
• 14:30   Function & Update/Insert Problem and Performance postgres@countup.de
• 14:38   Re: Trigger performance Tom Lane
• 15:44   Re: Trigger performance pginfo
• 16:11   Re: Trigger performance Tom Lane
• 16:17   Re: Trigger performance pginfo
• 18:47   database performance and query performance question Shea,Dan [CIS]
• 19:01   Re: database performance and query performance question Josh Berkus
• 19:22   Re: database performance and query performance question Josh Berkus
• 19:36   Re: database performance and query performance question Shea,Dan [CIS]
• 19:36   Re: database performance and query performance question Shea,Dan [CIS]
• 19:44   Re: database performance and query performance question Josh Berkus
• 19:48   Re: database performance and query performance question Hannu Krosing
• 19:54   Re: database performance and query performance question Hannu Krosing
• 20:10   Re: database performance and query performance question Shea,Dan [CIS]
• 20:33   Re: database performance and query performance question Shea,Dan [CIS]
• 20:53   Re: database performance and query performance question Josh Berkus
• 22:39   Re: database performance and query performance question Hannu Krosing
• 23:21   Re: database performance and query performance question Greg Stark

23 January 2004

• 06:36   Re: Trigger performance Pavel Stehule
• 14:02   Re: Postgres on Netapp Bruce Momjian
• 15:44   High Performance/High Reliability File system on SuSE64 Dave Thompson
• 15:50   Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake
• 16:08   Optimizing SQL: bind variables, prepared stms, histograms 
• 16:56   Re: High Performance/High Reliability File system on SuSE64 Andrew Sullivan
• 17:19   Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake
• 17:59   help with dual indexing Orion Henry
• 18:02   Re: High Performance/High Reliability File system on SuSE64 Andrew Sullivan
• 18:06   Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake
• 19:51   Re: High Performance/High Reliability File system on SuSE64 Andrew Sullivan
• 19:56   Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake
• 21:38   Re: High Performance/High Reliability File system on SuSE64 Christopher Browne
• 21:58   Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake
• 23:39   Slow delete times?? Octavio Alvarez
• 23:56   Re: Slow delete times?? Joshua D. Drake

24 January 2004

• 00:08   Re: help with dual indexing Tom Lane
• 00:27   Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake
• 00:31   query slows under load Jenny Zhang
• 00:45   Re: Slow delete times?? Tom Lane
• 02:26   Re: High Performance/High Reliability File system on SuSE64 Mark Kirkwood
• 16:11   Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake
• 16:32   Re: High Performance/High Reliability File system on SuSE64 Paul Ganainm
• 16:49   Persistent Connections postgres@countup.de
• 19:15   Re: High Performance/High Reliability File system on SuSE64 Doug McNaught
• 20:55   Re: High Performance/High Reliability File system on SuSE64 Mark Kirkwood

25 January 2004

• 00:02   Benchmarking PostgreSQL? Ivan Voras
• 01:13   Re: Slow delete times?? Octavio Alvarez
• 01:56   Re: Benchmarking PostgreSQL? Tom Lane
• 10:29   Re: Persistent Connections Nick Barr
• 11:23   Re: Benchmarking PostgreSQL? Ivan Voras
• 20:14   Re: query slows under load Stephan Szabo

26 January 2004

• 13:13   Queries with timestamp II Arnau
• 14:01   Re: Queries with timestamp II Tomasz Myrta
• 14:19   On the performance of views Bill Moran
• 14:30   Re: On the performance of views Shridhar Daithankar
• 14:39   Re: High Performance/High Reliability File system on SuSE64 Christopher Browne
• 15:26   Re: High Performance/High Reliability File system on SuSE64 Greg Stark
• 15:46   Re: On the performance of views Tom Lane
• 16:12   Re: On the performance of views Josh Berkus
• 16:18   Re: On the performance of views Bill Moran
• 19:53   Re: help with dual indexing Orion Henry
• 20:01   Insert Times PC Drew

27 January 2004

• 02:14   Re: Insert Times Brad Gawne
• 06:39   Re: Insert Times Leeuw van der, Tim
• 13:06   Re: Insert Times PC Drew
• 14:59   Re: Insert Times Alan Stange
• 16:53   Re: High Performance/High Reliability File system on SuSE64 George Essig
• 17:51   pl/pgSQL versus pl/Python Joshua D. Drake
• 18:30   (partial?) indexes, LIKE and NULL Marinos J. Yannikos
• 18:39   Re: On the performance of views Bill Moran
• 18:52   Re: (partial?) indexes, LIKE and NULL PC Drew
• 19:10   Re: On the performance of views Josh Berkus
• 21:47   Re: (partial?) indexes, LIKE and NULL Tom Lane

28 January 2004

• 00:00   Re: pl/pgSQL versus pl/Python Joe Conway
• 07:44   Re: On the performance of views Shridhar Daithankar
• 15:02   Re: On the performance of views Bill Moran
• 15:33   postgres timeout. Stef
• 15:49   Re: [SQL] postgres timeout. Tom Lane
• 15:59   Re: postgres timeout. [SOLVED] Stef
• 16:39   Re: postgres timeout. Stef
• 17:37   Re: High Performance/High Reliability File system on markw@osdl.org
• 18:50   Optimization questions Greg Spiegelberg
• 20:33   Linux / Clariion Cott Lang
• 21:09   Re: Linux / Clariion Nick Barr

29 January 2004

• 00:06   query optimization question Jack Coates
• 01:05   Re: query optimization question Tom Lane
• 14:42   Re: [SQL] limit 1 and functional indexes Bruno Wolff III
• 16:24   Re: query optimization question Jack Coates
• 17:05   Re: query optimization question Tom Lane
• 17:43   Re: On the performance of views Josh Berkus
• 18:05   Re: query optimization question Jack Coates
• 18:12   Re: On the performance of views Bill Moran
• 18:30   Explain plan for 2 column index 
• 18:31   Re: query optimization question Tom Lane
• 20:24   Re: query optimization question Jack Coates
• 20:37   Re: Explain plan for 2 column index Richard Huxton
• 21:02   Re: query optimization question Tom Lane
• 21:08   Re: Explain plan for 2 column index Tom Lane
• 21:27   Re: query optimization question Jack Coates
• 23:32   query optimization differs between view and explicit query Reece Hart
• 23:49   Re: query optimization differs between view and explicit Christopher Kings-Lynne

30 January 2004

• 00:21   Re: query optimization differs between view and explicit Stephan Szabo
• 04:27   Re: query optimization differs between view and explicit Tom Lane
• 06:19   Re: query optimization question Dennis Bjorklund
• 06:23   Re: query optimization question Dennis Bjorklund
• 07:16   Cost of indexscan Kari Lavikka
• 07:48   Re: Explain plan for 2 column index : timestamps and time zones 
• 08:15   Unique index and estimated rows. Kari Lavikka
• 09:01   Re: query optimization question Greg Stark
• 09:09   Re: On the performance of views Shridhar Daithankar
• 13:51   Re: query optimization question Tom Lane
• 14:07   Re: Cost of indexscan Tom Lane
• 16:13   Re: query optimization question Jack Coates
• 17:00   another query optimization question David Teran
• 17:09   Re: another query optimization question PC Drew
• 17:10   Re: another query optimization question Stephan Szabo
• 17:20   Re: another query optimization question David Teran
• 18:19   Re: another query optimization question Tom Lane
• 18:27   Re: query optimization differs between view and explicit Reece Hart
• 19:25   Re: another query optimization question Richard Huxton
• 21:02   Re: another query optimization question David Teran
• 21:40   Re: another query optimization question Tom Lane

31 January 2004

• 01:10   Re: High Performance/High Reliability File system on SuSE64 Christopher Weimann
• 01:10   Queries with timestamp, 2 Arnau Rebassa i Villalonga
• 01:10   Re: Persistent Connections Randolf Richardson
• 01:11   Re: Queries with timestamp II Shridhar Daithankar
• 01:11   views? Loeke
• 03:36   Re: views? Neil Conway
• 04:02   Re: Unique index and estimated rows. Josh Berkus
• 04:08   Re: High Performance/High Reliability File system on SuSE64 Tom Lane
• 07:52   Re: Unique index and estimated rows. Kari Lavikka
• 09:28   Re: another query optimization question David Teran
• 14:48   Re: another query optimization question Tom Lane
• 17:40   Re: High Performance/High Reliability File system on SuSE64 Bruce Momjian
• 19:35   Re: another query optimization question Marc G. Fournier
• 20:40   Re: another query optimization question David Teran