Skip site navigation (1)
Skip section navigation (2)
pgsql-performance 2004-01 Chronological Index (1/2)
Last updated: Wed Jan 18 04:22:20 2012
355 messages
31 January 2004
Re: another query optimization question Marc G. Fournier (20:19)
Re: High Performance/High Reliability File system on SuSE64 Bruce Momjian (18:40)
Re: another query optimization question Tom Lane (15:48)
Re: another query optimization question David Teran (10:28)
Re: Unique index and estimated rows. Kari Lavikka (08:52)
Re: High Performance/High Reliability File system on SuSE64 Tom Lane (05:08)
Re: Unique index and estimated rows. Josh Berkus (05:02)
Re: views? Neil Conway (04:35)
30 January 2004
Re: another query optimization question David Teran (22:02)
Re: another query optimization question Richard Huxton (20:25)
Re: query optimization differs between view and explicit Reece Hart (19:27)
Re: another query optimization question Tom Lane (19:19)
Re: another query optimization question David Teran (18:20)
Re: another query optimization question Stephan Szabo (18:10)
Re: another query optimization question PC Drew (18:09)
another query optimization question David Teran (18:00)
Re: query optimization question Jack Coates (17:13)
Re: Cost of indexscan Tom Lane (15:07)
Re: query optimization question Tom Lane (14:51)
Re: On the performance of views Shridhar Daithankar (10:08)
Re: query optimization question Greg Stark (10:01)
Unique index and estimated rows. Kari Lavikka (09:15)
Re: Explain plan for 2 column index : timestamps and time zones lnd (08:47)
Cost of indexscan Kari Lavikka (08:16)
Re: query optimization question Dennis Bjorklund (07:23)
Re: query optimization question Dennis Bjorklund (07:19)
Re: query optimization differs between view and explicit Tom Lane (05:27)
Re: query optimization differs between view and explicit Stephan Szabo (01:21)
Re: query optimization differs between view and explicit Christopher Kings-Lynne (00:49)
query optimization differs between view and explicit query Reece Hart (00:32)
29 January 2004
Re: Explain plan for 2 column index Tom Lane (22:08)
Re: query optimization question Tom Lane (22:02)
Re: Explain plan for 2 column index Richard Huxton (21:37)
Re: query optimization question Jack Coates (21:23)
Re: query optimization question Tom Lane (19:31)
Explain plan for 2 column index lnd (19:30)
Re: On the performance of views Bill Moran (19:12)
Re: query optimization question Jack Coates (19:05)
Re: On the performance of views Josh Berkus (18:43)
Re: query optimization question Tom Lane (18:05)
Re: query optimization question Jack Coates (17:24)
Re: [SQL] limit 1 and functional indexes Bruno Wolff III (15:42)
Re: query optimization question Tom Lane (02:05)
query optimization question Jack Coates (01:06)
28 January 2004
Linux / Clariion Cott Lang (21:33)
Optimization questions Greg Spiegelberg (19:50)
views? Loeke (19:20)
Re: High Performance/High Reliability File system on markw (18:37)
Re: postgres timeout. Stef (17:38)
Re: postgres timeout. [SOLVED] Stef (16:59)
Re: [SQL] postgres timeout. Tom Lane (16:49)
postgres timeout. Stef (16:33)
Re: On the performance of views Bill Moran (16:02)
Re: On the performance of views Shridhar Daithankar (08:44)
Re: pl/pgSQL versus pl/Python Joe Conway (01:00)
27 January 2004
Re: On the performance of views Josh Berkus (20:10)
Re: (partial?) indexes, LIKE and NULL PC Drew (19:52)
Re: On the performance of views Bill Moran (19:39)
(partial?) indexes, LIKE and NULL Marinos J. Yannikos (19:30)
pl/pgSQL versus pl/Python Joshua D. Drake (18:51)
Re: High Performance/High Reliability File system on SuSE64 George Essig (17:53)
Re: Insert Times Alan Stange (15:58)
Re: Insert Times PC Drew (14:06)
Re: Insert Times Leeuw van der, Tim (07:39)
Re: Insert Times Brad Gawne (03:14)
26 January 2004
Re: help with dual indexing Orion Henry (20:53)
Re: On the performance of views Bill Moran (17:18)
Re: On the performance of views Josh Berkus (17:12)
Re: On the performance of views Tom Lane (16:46)
Re: High Performance/High Reliability File system on SuSE64 Greg Stark (16:18)
Re: High Performance/High Reliability File system on SuSE64 Christopher Browne (15:39)
Re: On the performance of views Shridhar Daithankar (15:30)
On the performance of views Bill Moran (15:19)
Re: Queries with timestamp II Tomasz Myrta (15:01)
Re: Queries with timestamp II Shridhar Daithankar (14:38)
Queries with timestamp II Arnau (14:13)
Re: Persistent Connections Randolf Richardson (06:39)
25 January 2004
Re: Benchmarking PostgreSQL? Ivan Voras (12:23)
Re: Persistent Connections Nick Barr (11:29)
Re: Benchmarking PostgreSQL? Tom Lane (02:56)
Re: Slow delete times?? Octavio Alvarez (02:13)
Benchmarking PostgreSQL? Ivan Voras (01:02)
24 January 2004
Re: High Performance/High Reliability File system on SuSE64 Doug McNaught (20:15)
Persistent Connections postgres (17:49)
Re: High Performance/High Reliability File system on SuSE64 Paul Ganainm (17:32)
Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake (17:11)
Re: High Performance/High Reliability File system on SuSE64 Mark Kirkwood (03:26)
Re: Slow delete times?? Tom Lane (01:45)
query slows under load Jenny Zhang (01:31)
Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake (01:27)
Re: High Performance/High Reliability File system on SuSE64 Christopher Weimann (01:23)
Re: help with dual indexing Tom Lane (01:08)
Re: Slow delete times?? Joshua D. Drake (00:56)
Slow delete times?? Octavio Alvarez (00:39)
23 January 2004
Re: High Performance/High Reliability File system on SuSE64 Christopher Browne (22:38)
Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake (20:56)
Re: High Performance/High Reliability File system on SuSE64 Andrew Sullivan (20:51)
Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake (19:06)
Re: High Performance/High Reliability File system on SuSE64 Andrew Sullivan (19:02)
help with dual indexing Orion Henry (18:59)
Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake (18:19)
Re: High Performance/High Reliability File system on SuSE64 Andrew Sullivan (17:56)
Optimizing SQL: bind variables, prepared stms, histograms lnd (17:08)
Re: High Performance/High Reliability File system on SuSE64 Joshua D. Drake (16:50)
High Performance/High Reliability File system on SuSE64 Dave Thompson (16:44)
Re: Postgres on Netapp Bruce Momjian (15:01)
Queries with timestamp, 2 Arnau Rebassa i Villalonga (07:50)
Re: Trigger performance Pavel Stehule (07:36)
Re: database performance and query performance question Greg Stark (00:21)
22 January 2004
Re: database performance and query performance question Josh Berkus (21:53)
Re: database performance and query performance question Shea,Dan [CIS] (21:33)
Re: database performance and query performance question Shea,Dan [CIS] (21:10)
Re: database performance and query performance question Hannu Krosing (20:54)
Re: database performance and query performance question Hannu Krosing (20:48)
Re: database performance and query performance question Josh Berkus (20:44)
Re: database performance and query performance question Shea,Dan [CIS] (20:36)
Re: database performance and query performance question Shea,Dan [CIS] (20:36)
Re: database performance and query performance question Josh Berkus (20:22)
Re: database performance and query performance question Josh Berkus (20:01)
database performance and query performance question Shea,Dan [CIS] (19:47)
Re: Trigger performance pginfo (17:17)
Re: Trigger performance Tom Lane (17:11)
Re: Trigger performance pginfo (16:44)
Re: Trigger performance Tom Lane (15:38)
Function & Update/Insert Problem and Performance postgres (15:30)
Trigger performance pginfo (10:47)
21 January 2004
Re: Queries with timestamps Richard Huxton (20:39)
Re: Queries with timestamps Josh Berkus (19:27)
Re: ORDER BY and LIMIT with SubSelects Bruno Wolff III (19:03)
Queries with timestamps Arnau (18:50)
ORDER BY and LIMIT with SubSelects Ron St-Pierre (17:18)
Re: Trigger question Stephan Szabo (16:51)
Re: Trigger question Harald Fuchs (13:50)
Re: Really slow even after vacuum Dennis Bjorklund (10:43)
Re: PostgreSQL vs. Oracle disk space usage Thierry Missimilly (10:12)
Really slow even after vacuum Jeroen Baekelandt (09:34)
Re: database profiling Christopher Kings-Lynne (01:45)
20 January 2004
Re: Trigger question Richard Huxton (19:06)
Re: Trigger question Tom Lane (16:43)
Re: Trigger question Stephan Szabo (16:31)
Re: Trigger question Harald Fuchs (16:16)
Re: Trigger question Tom Lane (16:03)
Re: Trigger question Neil Conway (15:17)
Re: Trigger question Richard Huxton (08:14)
Re: Trigger question Neil Conway (00:01)
19 January 2004
Re: Join optimisation Quandry Tom Lane (02:21)
17 January 2004
Re: Idle postmaster taking up a lot of CPU Tom Lane (17:33)
Re: Postgres on Netapp D'Arcy J.M. Cain (16:55)
Idle postmaster taking up a lot of CPU John Siracusa (15:35)
Re: Join optimisation Quandry Ceri Storey (11:59)
Re: Join optimisation Quandry Ceri Storey (10:41)
Re: Join optimisation Quandry Stephan Szabo (06:06)
Re: Potential Problem with PostgeSQL performance on SuSE Mark Kirkwood (01:51)
Re: Potential Problem with PostgeSQL performance on SuSE Josh Berkus (01:14)
Re: Join optimisation Quandry Ceri Storey (01:04)
16 January 2004
Potential Problem with PostgeSQL performance on SuSE Linux 9.0 Josh Berkus (20:38)
Re: Question about space usage: Tom Lane (19:26)
Re: Join optimisation Quandry Stephan Szabo (18:18)
Re: subquery and table join, index not use for table Stephan Szabo (17:49)
Re: shared_buffer value scott.marlowe (17:24)