Mailing lists [pgsql-performance]

1 December 2005

• 02:55   Query is 800 times slower when running in function! Ralph Mason
• 02:58   Re: RES: pg_dump slow Ron
• 03:58   Re: Query is 800 times slower when running in function! Tom Lane
• 04:58   About the relation between fragmentation of file and VACUUM Tatsumi Abe
• 09:05   Re: About the relation between fragmentation of file and Richard Huxton
• 10:32   pg_dump slow Franklin Haut
• 11:00   Re: About the relation between fragmentation of file and Michael Stone
• 11:44   Re: About the relation between fragmentation of file and VACUUM Bill McGonigle
• 12:34   slow insert into very large table Wolfgang Gehner
• 12:42   15,000 tables Michael Riess
• 13:00   Re: slow insert into very large table Andreas Pflug
• 13:20   Re: 15,000 tables David Lang
• 14:13   filesystem performance with lots of files David Lang
• 14:15   Re: 15,000 tables Michael Riess
• 14:15   Re: 15,000 tables Michael Riess
• 14:29   Re: About the relation between fragmentation of file and David Lang
• 14:42   Re: 15,000 tables Jaime Casanova
• 14:49   Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny
• 14:50   Re: slow insert into very large table Tom Lane
• 15:03   Re: 15,000 tables Tom Lane
• 15:15   Re: 15,000 tables Jaime Casanova
• 15:15   Re: pg_dump slow Merlin Moncure
• 15:15   Re: 15,000 tables Michael Riess
• 15:26   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane
• 15:30   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny
• 15:31   Re: 15,000 tables Guido Neitzer
• 15:34   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane
• 15:45   Re: 15,000 tables Michael Riess
• 16:07   Re: 15,000 tables 
• 16:31   pg_stat* values ... Marc G. Fournier
• 17:03   Re: filesystem performance with lots of files Qingqing Zhou
• 17:04   Re: 15,000 tables Chris Browne
• 17:07   Re: 15,000 tables Gavin M. Roy
• 17:08   COPY into table too slow with index Rick Schumeyer
• 17:40   Re: 15,000 tables Tino Wildenhain
• 17:48   Re: 15,000 tables Ron
• 17:49   Re: 15,000 tables Gavin M. Roy
• 17:57   Re: 15,000 tables Tom Lane
• 18:04   Insert performance slows down in large batch Jeremy Haile
• 18:09   Re: 15,000 tables Gavin M. Roy
• 18:19   Re: Insert performance slows down in large batch Tom Lane
• 18:34   Re: 15,000 tables Michael Riess
• 18:41   Re: 15,000 tables Jaime Casanova
• 19:29   Re: 15,000 tables Merlin Moncure
• 20:16   Re: 15,000 tables Scott Marlowe
• 20:17   Re: 15,000 tables Alvaro Herrera
• 21:23   Re: COPY into table too slow with index: now an I/O question Rick Schumeyer

2 December 2005

• 01:27   Re: COPY into table too slow with index: now an I/O Luke Lonergan
• 02:01   Database restore speed Steve Oualline
• 02:10   Re: COPY into table too slow with index: now an I/O Tom Lane
• 02:27   Re: COPY into table too slow with index: now an I/O question Rick Schumeyer
• 02:50   Re: 15,000 tables Craig A. James
• 04:17   Re: COPY into table too slow with index: now an I/O Luke Lonergan
• 05:23   Re: Database restore speed Luke Lonergan
• 06:14   Re: filesystem performance with lots of files David Lang
• 06:39   Re: Open request for benchmarking input (fwd) David Lang
• 06:49   Re: filesystem performance with lots of files Qingqing Zhou
• 06:51   Re: 15,000 tables David Lang
• 06:54   Re: Database restore speed David Lang
• 07:06   Re: filesystem performance with lots of files David Lang
• 07:07   Re: Database restore speed Luke Lonergan
• 07:15   Re: 15,000 tables Ron
• 12:02   Re: 15,000 tables Michael Stone
• 12:04   Re: COPY into table too slow with index: now an I/O Michael Stone
• 13:16   Re: 15,000 tables Alex Stapleton
• 13:20   Re: 15,000 tables Alex Stapleton
• 14:16   Re: 15,000 tables Jan Wieck
• 15:10   Network permormance under windows Teracat
• 15:13   Re: Network permormance under windows Merlin Moncure
• 15:28   Re: pg_dump slow Merlin Moncure
• 15:33   Re: pg_dump slow Merlin Moncure
• 16:18   Re: Open request for benchmarking input (fwd) Qingqing Zhou
• 18:00   two disks - best way to use them? Rick Schumeyer
• 18:31   Re: Network permormance under windows Josep Maria Pinyol Fontseca
• 19:05   Re: two disks - best way to use them? Ron
• 19:18   Re: Database restore speed Stephen Frost
• 19:27   Re: Network permormance under windows 
• 19:43   Re: Network permormance under windows Qingqing Zhou
• 19:48   Re: Database restore speed Luke Lonergan
• 20:08   Re: Network permormance under windows Josep Maria Pinyol Fontseca
• 20:09   Re: 15,000 tables Andrew Sullivan
• 20:18   Re: Database restore speed Stephen Frost
• 20:25   Re: Database restore speed Luke Lonergan
• 20:30   Re: Database restore speed Luke Lonergan
• 20:46   Re: Database restore speed Michael Stone
• 21:59   Re: 15,000 tables Francisco Reyes
• 22:01   Re: Database restore speed Tom Lane
• 22:02   15,000 tables - next step Michael Riess
• 22:03   Re: Database restore speed Luke Lonergan
• 22:26   Small table or partial index? Francisco Reyes

3 December 2005

• 02:26   Re: Database restore speed Mitch Skinner
• 03:04   Re: Database restore speed Luke Lonergan
• 08:07   Re: Database restore speed David Lang
• 08:12   Re: Database restore speed David Lang
• 08:22   Re: Database restore speed David Lang
• 08:33   Re: Database restore speed David Lang
• 08:39   Re: Database restore speed David Lang
• 11:38   Re: Database restore speed Simon Riggs
• 14:51   Re: 15,000 tables - next step Jan Wieck
• 15:20   Re: 15,000 tables - next step Michael Riess
• 15:26   Re: 15,000 tables - next step Alvaro Herrera
• 15:41   Re: 15,000 tables - next step Michael Riess
• 17:45   Re: 15,000 tables - next step Jaime Casanova
• 18:32   Re: 15,000 tables - next step Jan Wieck
• 18:42   Re: Database restore speed Luke Lonergan
• 19:32   Re: Database restore speed Tom Lane
• 20:29   Re: Database restore speed Luke Lonergan
• 22:00   Faster db architecture for a twisted table. Rodrigo Madera
• 22:29   Re: Database restore speed Mitch Skinner
• 23:00   Re: Faster db architecture for a twisted table. Andreas Pflug

4 December 2005

• 00:21   Re: Database restore speed David Lang
• 00:33   Re: Faster db architecture for a twisted table. Hélder M. Vieira
• 05:40   Re: Very slow queries - please help Thomas F. O'Connell
• 08:22   Re: 15,000 tables - next step William Yu
• 08:33   Re: 15,000 tables - next step Michael Riess
• 10:56   Re: Faster db architecture for a twisted table. Andreas Pflug
• 12:25   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny
• 17:31   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane
• 21:19   Re: Faster db architecture for a twisted table. Klint Gore

5 December 2005

• 02:20   Dividing up a single 250GB RAID10 server for postgres Rory Campbell-Lange
• 09:29   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny
• 12:47   BLCKSZ Olleg Samoylov
• 12:56   Re: two disks - best way to use them? Olleg Samoylov
• 13:32   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane
• 13:44   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny
• 14:02   Re: BLCKSZ Tom Lane
• 14:11   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Tom Lane
• 14:40   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny
• 14:45   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Markus Wollny
• 14:47   Re: two disks - best way to use them? Thomas Harold
• 15:18   Re: two disks - best way to use them? David Lang
• 15:45   Re: two disks - best way to use them? Thomas Harold
• 18:27   Re: Best hardware Mirjam (sent by Nabble.com)
• 19:17   Performance degradation after successive UPDATE's Assaf Yaari
• 19:31   Re: Performance degradation after successive UPDATE's Bruno Wolff III
• 21:11   Missed index opportunity for outer join? rm_pg@cheapcomplexdevices.com
• 21:32   Re: BLCKSZ Olleg
• 21:38   Re: Missed index opportunity for outer join? Tom Lane
• 22:04   Re: Missed index opportunity for outer join? rm_pg@cheapcomplexdevices.com
• 23:07   Re: BLCKSZ Alvaro Herrera

6 December 2005

• 00:21   Re: BLCKSZ Ron
• 02:07   Re: 15,000 tables - next step Jan Wieck
• 02:58   Re: two disks - best way to use them? David Lang
• 04:51   Re: BLCKSZ Tom Lane
• 04:52   Re: two disks - best way to use them? Thomas Harold
• 07:12   Re: two disks - best way to use them? Ron
• 07:54   Re: [GENERAL] need help Tino Wildenhain
• 08:09   Re: Performance degradation after successive UPDATE's Assaf Yaari
• 08:22   Memory Leakage Problem Kathy Lo
• 08:39   LVM and Postgres Rory Campbell-Lange
• 08:43   Can this query go faster??? Joost Kraaijeveld
• 08:52   Re: Performance degradation after successive UPDATE's Pandurangan R S
• 08:52   Re: Can this query go faster??? Michael Riess
• 08:54   Re: Can this query go faster??? Csaba Nagy
• 08:55   Re: Can this query go faster??? Markus Wollny
• 09:21   Re: Can this query go faster??? Joost Kraaijeveld
• 09:32   Re: Can this query go faster??? Tino Wildenhain
• 09:40   Re: BLCKSZ Olleg
• 09:59   Re: BLCKSZ Steinar H. Gunderson
• 10:21   Re: Can this query go faster??? Joost Kraaijeveld
• 10:36   Re: Can this query go faster??? Tino Wildenhain
• 10:42   Re: BLCKSZ David Lang
• 11:20   Re: Can this query go faster??? Joost Kraaijeveld
• 11:30   Re: Can this query go faster??? Tino Wildenhain
• 11:35   Re: Performance degradation after successive UPDATE's Jan Wieck
• 11:42   Re: Can this query go faster??? Csaba Nagy
• 12:41   Re: Can this query go faster??? Ron
• 12:58   Re: Can this query go faster??? Merlin Moncure
• 13:46   Re: Memory Leakage Problem Tom Lane
• 15:00   Re: two disks - best way to use them? Thomas Harold
• 15:20   Re: 8.1 count(*) distinct: IndexScan/SeqScan Pailloncy Jean-Gerard
• 15:48   TSearch2 vs. Apache Lucene Joshua Kramer
• 15:57   Re: Missed index opportunity for outer join? Tom Lane
• 15:59   Re: TSearch2 vs. Apache Lucene Michael Riess
• 16:14   Re: TSearch2 vs. Apache Lucene Oleg Bartunov
• 16:27   Re: TSearch2 vs. Apache Lucene Bruce Momjian
• 16:44   postgresql performance tuning Ameet Kini
• 16:48   Re: Memory Leakage Problem Scott Marlowe
• 17:02   Re: TSearch2 vs. Apache Lucene Tom Lane
• 17:04   Re: postgresql performance tuning Tom Lane
• 17:28   Re: TSearch2 vs. Apache Lucene Michael Riess
• 17:32   Re: TSearch2 vs. Apache Lucene Bruce Momjian
• 17:33   Re: postgresql performance tuning Vivek Khera
• 18:04   Re: High context switches occurring Anjan Dave
• 18:20   postgresql performance tuning Ameet Kini
• 18:26   Re: High context switches occurring Vivek Khera
• 19:07   Re: postgresql performance tuning Vivek Khera
• 19:11   Re: Missed index opportunity for outer join? Ron Mayer
• 19:12   Re: LVM and Postgres August Zajonc
• 19:33   Re: Missed index opportunity for outer join? Tom Lane
• 19:35   Re: TSearch2 vs. Apache Lucene Russell Garrett
• 19:40   Re: Performance degradation after successive UPDATE's Bruno Wolff III
• 19:46   Re: Can this query go faster??? Bruno Wolff III
• 19:49   Re: postgresql performance tuning Alan Stange
• 20:02   Re: postgresql performance tuning Michael Riess
• 20:08   Re: Missed index opportunity for outer join? Ron Mayer
• 20:22   Re: postgresql performance tuning Tom Lane
• 20:22   Context switching and Xeon processors Brandon Metcalf
• 20:26   Re: Missed index opportunity for outer join? Tom Lane
• 20:38   Re: Context switching and Xeon processors Tom Lane
• 20:38   Re: LVM and Postgres Rory Campbell-Lange
• 20:38   Re: Missed index opportunity for outer join? Ron Mayer
• 20:40   Re: postgresql performance tuning Alan Stange
• 20:45   Re: Context switching and Xeon processors Brandon Metcalf
• 20:52   Re: Context switching and Xeon processors Steinar H. Gunderson
• 21:00   Re: two disks - best way to use them? David Lang
• 21:03   Re: postgresql performance tuning Ameet Kini
• 22:45   Re: High context switches occurring Tom Lane
• 23:23   Re: postgresql performance tuning Michael Stone
• 23:25   Re: LVM and Postgres Michael Stone
• 23:52   Re: LVM and Postgres Alex Turner

7 December 2005

• 00:31   Re: LVM and Postgres Michael Stone
• 00:38   Re: TSearch2 vs. Apache Lucene Christopher Kings-Lynne
• 02:56   Re: Faster db architecture for a twisted table. Mitchell Skinner
• 02:56   Query Fails with error calloc - Cannot alocate memory Howard Oblowitz
• 02:56   need help Jenny
• 02:56   need help (not anymore) Jenny
• 02:56   Join the same row Edison Azzi
• 03:14   Re: LVM and Postgres Kevin Brown
• 03:15   Re: Query Fails with error calloc - Cannot alocate memory Christopher Kings-Lynne
• 03:34   Re: High context switches occurring Bruce Momjian
• 03:41   Re: Effects of cascading references in foreign keys Bruce Momjian
• 03:49   Re: High context switches occurring Tom Lane
• 05:23   Re: Query Fails with error calloc - Cannot alocate memory Neil Conway
• 06:56   Re: TSearch2 vs. Apache Lucene Michael Riess
• 07:17   Re: TSearch2 vs. Apache Lucene Christopher Kings-Lynne
• 07:28   Re: TSearch2 vs. Apache Lucene Michael Riess
• 08:27   Re: Join the same row Richard Huxton
• 08:31   table partitioning: effects of many sub-tables (was COPY too slow...) Rick Schumeyer
• 09:46   First query is slow, subsequent queries fast Stephan Vollmer
• 09:55   Re: First query is slow, subsequent queries fast Oleg Bartunov
• 11:14   Re: Performance degradation after successive UPDATE's Assaf Yaari
• 14:50   Re: postgresql performance tuning Vivek Khera
• 14:54   Re: High context switches occurring Anjan Dave
• 15:24   Re: High context switches occurring Scott Marlowe
• 17:33   Re: First query is slow, subsequent queries fast Stephan Vollmer
• 18:02   Re: Join the same row Richard Huxton
• 19:00   Re: Performance degradation after successive UPDATE's Bruno Wolff III

8 December 2005

• 02:21   view of view Keith Worthington
• 07:36   INSERTs becoming slower and slower Nörder-Tuitje, Marcus
• 07:40   Re: INSERTs becoming slower and slower Christopher Kings-Lynne
• 10:30   Re: LVM and Postgres Rory Campbell-Lange
• 11:14   Disk tests for a new database server Rory Campbell-Lange
• 12:13   Re: view of view Merlin Moncure
• 12:46   Re: view of view Rich Doughty
• 13:07   Re: INSERTs becoming slower and slower Matteo Beccati
• 13:29   Re: Performance degradation after successive UPDATE's Assaf Yaari
• 15:52   opinion on disk speed Vivek Khera
• 16:03   Re: opinion on disk speed Dave Page
• 16:09   slow COMMITs Evgeny Gridasov
• 16:24   Joining 2 tables with 300 million rows Amit V Shah
• 16:50   Re: opinion on disk speed Scott Marlowe
• 17:17   Re: Disk tests for a new database server Steve Poe
• 18:22   Re: opinion on disk speed Jeffrey W. Baker
• 20:54   Re: Joining 2 tables with 300 million rows Dmitri Bichko
• 21:01   Re: Joining 2 tables with 300 million rows Amit V Shah
• 21:56   Re: Disk tests for a new database server Rory Campbell-Lange

9 December 2005

• 01:30   Re: opinion on disk speed David Lang
• 09:01   Query not using index Kaloyan Iliev
• 13:15   Re: opinion on disk speed Jeremy Haile
• 14:06   Re: Query not using index Jaime Casanova
• 14:38   Re: Joining 2 tables with 300 million rows Jeff Trout
• 14:46   Re: opinion on disk speed Frank Wiles
• 14:49   Re: opinion on disk speed Frank Wiles
• 14:50   Re: opinion on disk speed Andreas Pflug
• 14:57   Re: opinion on disk speed Frank Wiles
• 15:39   Re: Query not using index Kaloyan Iliev

10 December 2005

• 10:34   Is RAID10 the best choice? Carlos Benkendorf
• 14:36   Clustered tables and seqscan disabled Henrique Engelmann
• 14:53   Executing a shell command from a PG function Yves Vindevogel
• 15:14   Re: Executing a shell command from a PG function Jaime Casanova
• 15:22   Re: Executing a shell command from a PG function Michael Fuhr
• 15:50   Re: Executing a shell command from a PG function Yves Vindevogel
• 15:53   Re: Clustered tables and seqscan disabled Tom Lane
• 16:14   Re: Queries taking ages in PG 8.1, have been much faster in PG<=8.0 Manfred Koizar
• 19:17   Bitmasks Ivan Voras

11 December 2005

• 05:12   Re: Bitmasks Greg Stark
• 10:53   How much expensive are row level statistics? Carlos Benkendorf
• 17:50   Re: High context switches occurring Tatsuo Ishii
• 17:50   Re: Join the same row Edison Azzi
• 17:51   Should Oracle outperform PostgreSQL on a complex multidimensional query? Pål Stenslet
• 17:51   Re: Query not using index Kaloyan Iliev
• 18:44   Re: How much expensive are row level statistics? Michael Fuhr
• 19:36   Re: Join the same row Tom Lane
• 19:38   Re: Should Oracle outperform PostgreSQL on a complex multidimensional query? Tom Lane
• 20:15   Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan

12 December 2005

• 01:07   Table Partitions / Partial Indexes Mike C
• 01:39   Re: Table Partitions / Partial Indexes Tom Lane
• 01:49   Re: Table Partitions / Partial Indexes Mike C
• 03:45   Re: Is RAID10 the best choice? Alex Turner
• 08:13   2 phase commit: performance implications? Andy Ballingall
• 10:44   7.4.7 vs. 8.1 Szabolcs BALLA
• 11:05   Re: 7.4.7 vs. 8.1 Steinar H. Gunderson
• 15:24   Re: Very slow queries - please help Bealach-na Bo
• 16:48   Re: How much expensive are row level statistics? Alvaro Herrera
• 17:30   Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan
• 17:33   Re: How much expensive are row level statistics? Merlin Moncure
• 17:42   Re: opinion on disk speed Vivek Khera
• 17:50   Re: How much expensive are row level statistics? Michael Fuhr
• 19:37   Re: How much expensive are row level statistics? Michael Fuhr
• 20:59   Re: opinion on disk speed Vivek Khera
• 21:16   Re: opinion on disk speed J. Andrew Rogers
• 21:19   Re: opinion on disk speed Vivek Khera
• 21:24   Re: Small table or partial index? Jim C. Nasby
• 21:34   Re: Joining 2 tables with 300 million rows Manfred Koizar
• 22:01   Re: How much expensive are row level statistics? Tom Lane
• 22:12   Re: opinion on disk speed Scott Marlowe
• 22:17   Re: opinion on disk speed J. Andrew Rogers

13 December 2005

• 00:07   Re: How much expensive are row level statistics? Michael Fuhr
• 02:20   Re: How much expensive are row level statistics? Tom Lane
• 10:37   partitioning Marc Cousin
• 10:40   Re: partitioning Pandurangan R S
• 10:50   Re: partitioning Pandurangan R S
• 12:11   Re: partitioning Marc Cousin
• 14:18   query from partitions Ключников А.С.
• 14:59   Re: query from partitions Richard Huxton
• 15:08   Re: query from partitions Steinar H. Gunderson
• 15:09   Re: Small table or partial index? Francisco Reyes
• 15:58   Re: query from partitions Ключников А.С.
• 16:25   Lots of postmaster processes (fwd) Ameet Kini
• 21:48   Re: query from partitions Simon Riggs
• 22:17   Re: Table Partitions / Partial Indexes Simon Riggs
• 22:18   Re: Should Oracle outperform PostgreSQL on a complex Tomeh, Husam
• 22:28   Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs
• 22:54   Re: Table Partitions / Partial Indexes Mike C

14 December 2005

• 00:55   Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan
• 05:55   SAN/NAS options Charles Sprickman
• 06:14   Re: SAN/NAS options Luke Lonergan
• 06:29   Re: SAN/NAS options Mark Kirkwood
• 12:34   Convert IN sublink to join 
• 14:26   Re: Convert IN sublink to join Tom Lane
• 16:53   Re: SAN/NAS options Andrew Rawnsley
• 17:32   Re: SAN/NAS options Michael Stone
• 19:57   Auto-tuning a VIEW? Zoltan Boszormenyi
• 20:45   Re: Auto-tuning a VIEW? PFC
• 21:06   Re: Auto-tuning a VIEW? Zoltan Boszormenyi
• 21:09   Simple Join Kevin Brown
• 21:18   Re: Auto-tuning a VIEW? PFC
• 21:47   Re: Simple Join Tom Lane
• 22:18   Re: Simple Join Kevin Brown
• 22:23   Re: Simple Join Jaime Casanova
• 22:30   Re: Simple Join Mark Kirkwood
• 22:47   Re: Simple Join Steinar H. Gunderson
• 22:50   Re: Simple Join Kevin Brown
• 23:02   Re: Simple Join Kevin Brown
• 23:23   Re: [postgis-users] Is my query planner failing me, or vice versa? Gregory S. Williamson
• 23:36   Re: Simple Join Mark Kirkwood

15 December 2005

• 00:51   PostgreSQL performance question. Harry Jackson
• 00:59   Re: PostgreSQL performance question. Christopher Kings-Lynne
• 01:29   Re: PostgreSQL performance question. Gavin Sherry
• 04:36   Re: [postgis-users] Is my query planner failing me, or vice versa? Tom Lane
• 06:51   Re: Simple Join Kevin Brown
• 06:53   Re: Simple Join Kevin Brown
• 07:15   Re: Simple Join Mark Kirkwood
• 10:02   Re: Simple Join Mitch Skinner
• 10:04   Re: [postgis-users] Is my query planner failing me, or vice versa? Markus Schaber
• 11:03   Re: [postgis-users] Is my query planner failing me, or vice versa? Gregory S. Williamson
• 18:29   Re: Simple Join Mark Kirkwood
• 20:13   Re: SAN/NAS options Anjan Dave
• 21:01   Re: SAN/NAS options Luke Lonergan
• 22:09   Overriding the optimizer Craig A. James
• 22:44   Re: How much expensive are row level statistics? Michael Fuhr
• 23:06   Re: How much expensive are row level statistics? Tom Lane
• 23:23   Re: Overriding the optimizer Tom Lane

16 December 2005

• 00:50   Re: Overriding the optimizer Christopher Kings-Lynne
• 01:00   Re: Overriding the optimizer Jaime Casanova
• 01:02   Re: Overriding the optimizer Christopher Kings-Lynne
• 01:19   Re: Overriding the optimizer Craig A. James
• 01:21   Re: Overriding the optimizer Craig A. James
• 01:25   Re: Overriding the optimizer Christopher Kings-Lynne
• 01:26   Re: Overriding the optimizer Craig A. James
• 01:31   Re: Overriding the optimizer Mark Kirkwood
• 01:34   Re: Overriding the optimizer Christopher Kings-Lynne
• 01:47   Re: Overriding the optimizer Craig A. James
• 01:55   Re: Overriding the optimizer Craig A. James
• 02:07   Re: Overriding the optimizer Craig A. James
• 02:15   Re: Overriding the optimizer Craig A. James
• 02:17   Re: Overriding the optimizer Mark Kirkwood
• 02:20   Re: Overriding the optimizer Christopher Kings-Lynne
• 02:41   Re: Overriding the optimizer Craig A. James
• 03:01   Re: Overriding the optimizer Craig A. James
• 03:07   Re: Overriding the optimizer David Lang
• 03:10   Re: Simple Join David Lang
• 03:23   Re: Overriding the optimizer Jaime Casanova
• 03:25   Re: Overriding the optimizer Jaime Casanova
• 03:27   Re: Overriding the optimizer David Lang
• 04:08   Re: Overriding the optimizer Kevin Brown
• 04:20   Re: Overriding the optimizer Kevin Brown
• 04:44   Re: Overriding the optimizer Craig A. James
• 04:45   Re: How much expensive are row level statistics? Kevin Brown
• 04:48   Re: Overriding the optimizer Kevin Brown
• 04:50   Re: Overriding the optimizer Bruno Wolff III
• 12:17   Re: How much expensive are row level statistics? Simon Riggs
• 12:22   Crashing DB or Server? Moritz Bayer
• 12:38   Re: Crashing DB or Server? Harry Jackson
• 13:17   Re: Crashing DB or Server? Moritz Bayer
• 13:18   Re: Overriding the optimizer Kyle Cordes
• 13:25   ALTER TABLE SET TABLESPACE and pg_toast PostgreSQL
• 13:33   Re: Crashing DB or Server? Csaba Nagy
• 13:40   Re: How much expensive are row level statistics? Merlin Moncure
• 13:45   Re: Overriding the optimizer Jaime Casanova
• 13:54   Re: Overriding the optimizer Tomasz Rybak
• 14:23   Re: ALTER TABLE SET TABLESPACE and pg_toast Tom Lane
• 15:52   Re: Overriding the optimizer Craig A. James
• 18:14   Re: Overriding the optimizer Mitch Skinner
• 18:40   8.1 - pg_autovacuum question Chris Hoover
• 19:26   Re: 8.1 - pg_autovacuum question Alvaro Herrera
• 20:11   Re: Simple Join Mark Kirkwood
• 20:56   Re: Lots of postmaster processes (fwd) Jim C. Nasby
• 21:18   Re: SAN/NAS options Jim C. Nasby
• 21:19   Re: SAN/NAS options Jim C. Nasby
• 21:38   Re: Overriding the optimizer Jim C. Nasby
• 21:41   Re: Overriding the optimizer Jim C. Nasby
• 21:45   Re: Overriding the optimizer Jim C. Nasby
• 21:49   Re: SAN/NAS options Mark Kirkwood
• 21:51   Re: SAN/NAS options Michael Stone
• 23:25   Re: SAN/NAS options Jim C. Nasby
• 23:48   Re: SAN/NAS options Michael Stone

17 December 2005

• 00:41   Re: Overriding the optimizer Kyle Cordes
• 01:44   Re: How much expensive are row level statistics? Bruce Momjian
• 03:28   Re: Should Oracle outperform PostgreSQL on a complex Bruce Momjian
• 04:21   Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood
• 06:28   Re: Overriding the optimizer Tom Lane
• 07:45   Re: Overriding the optimizer David Lang
• 08:15   Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs
• 11:31   Re: Overriding the optimizer Jaime Casanova
• 13:56   Re: Simple Join Bruce Momjian
• 15:43   Re: Should Oracle outperform PostgreSQL on a complex Bruce Momjian
• 17:13   Re: Should Oracle outperform PostgreSQL on a complex Tom Lane
• 17:35   Re: Should Oracle outperform PostgreSQL on a complex Tom Lane
• 17:47   Re: Should Oracle outperform PostgreSQL on a complex Tom Lane
• 18:04   Re: Should Oracle outperform PostgreSQL on a complex Bruce Momjian
• 18:05   Re: Should Oracle outperform PostgreSQL on a complex Luke Lonergan

18 December 2005

• 01:02   Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood
• 01:11   Re: PostgreSQL performance question. Harry Jackson
• 01:18   Re: PostgreSQL performance question. [OT] Steinar H. Gunderson
• 03:07   Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood
• 04:12   make bulk deletes faster? James Klo
• 05:50   Re: Should Oracle outperform PostgreSQL on a complex Greg Stark
• 09:27   Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs
• 12:48   Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs
• 15:30   PostgreSQL and Ultrasparc T1 Juan Casero
• 16:12   Re: PostgreSQL and Ultrasparc T1 Christopher Petrilli
• 16:54   Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs
• 21:04   Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood
• 21:10   Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood
• 21:13   Re: Should Oracle outperform PostgreSQL on a complex Mark Kirkwood
• 21:21   Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs
• 21:28   Re: Should Oracle outperform PostgreSQL on a complex Simon Riggs

19 December 2005

• 01:36   Re: make bulk deletes faster? Michael Fuhr
• 05:25   Re: PostgreSQL and Ultrasparc T1 Scott Marlowe
• 06:21   Re: PostgreSQL and Ultrasparc T1 Luke Lonergan
• 07:18   Re: make bulk deletes faster? James Klo
• 09:39   Re: make bulk deletes faster? Mitch Skinner
• 13:36   Re: PostgreSQL and Ultrasparc T1 Jignesh K. Shah
• 13:47   Re: make bulk deletes faster? Ang Chin Han
• 14:21   Re: PostgreSQL and Ultrasparc T1 Anjan Dave
• 16:30   Re: PostgreSQL and Ultrasparc T1 Luke Lonergan
• 16:33   Any way to optimize GROUP BY queries? Cristian Prieto
• 18:10   Re: make bulk deletes faster? James Klo
• 18:30   Re: PostgreSQL and Ultrasparc T1 Jignesh Shah
• 18:37   Re: PostgreSQL and Ultrasparc T1 Luke Lonergan
• 19:04   separate drives for WAL or pgdata files Anjan Dave
• 19:21   Re: PostgreSQL and Ultrasparc T1 Jignesh Shah
• 19:23   Is the optimizer choice right? Carlos Benkendorf
• 19:47   Re: Any way to optimize GROUP BY queries? Greg Stark
• 19:54   Re: Is the optimizer choice right? Greg Stark
• 23:31   Re: PostgreSQL and Ultrasparc T1 Juan Casero
• 23:41   Re: SAN/NAS options Matthew Schumacher

20 December 2005

• 00:25   Re: SAN/NAS options Anjan Dave
• 00:35   Re: PostgreSQL and Ultrasparc T1 Luke Lonergan
• 00:37   Re: PostgreSQL and Ultrasparc T1 Luke Lonergan
• 01:08   Re: High context switches occurring Anjan Dave
• 03:10   Re: High context switches occurring Juan Casero
• 03:28   Re: PostgreSQL and Ultrasparc T1 Jignesh K. Shah
• 04:26   Re: High context switches occurring Oleg Bartunov
• 05:00   Re: separate drives for WAL or pgdata files David Lang
• 05:33   Re: separate drives for WAL or pgdata files David Lang
• 05:53   Re: High context switches occurring Jignesh K. Shah
• 09:41   Read only transactions - Commit or Rollback Markus Schaber
• 09:55   Re: Read only transactions - Commit or Rollback Nörder-Tuitje, Marcus
• 10:36   unsubscribe William Lai
• 10:40   Re: Read only transactions - Commit or Rollback Grega Bremec
• 10:54   Re: Read only transactions - Commit or Rollback Nörder-Tuitje, Marcus
• 11:04   Re: Read only transactions - Commit or Rollback Markus Schaber
• 11:05   Re: Read only transactions - Commit or Rollback Michael Riess
• 11:27   Re: Read only transactions - Commit or Rollback Andreas Seltenreich
• 11:32   Re: Read only transactions - Commit or Rollback Markus Schaber
• 12:06   Re: Read only transactions - Commit or Rollback Nicolas Barbier
• 12:26   Re: filesystem performance with lots of files David Roussel
• 13:41   Re: High context switches occurring Tom Lane
• 14:00   Re: 2 phase commit: performance implications? David Roussel
• 14:01   Re: PostgreSQL and Ultrasparc T1 Alan Stange
• 14:10   Re: PostgreSQL and Ultrasparc T1 David Lang
• 14:14   Re: PostgreSQL and Ultrasparc T1 Alan Stange
• 14:18   Re: High context switches occurring Oleg Bartunov
• 14:24   Re: PostgreSQL and Ultrasparc T1 David Lang
• 14:28   Re: High context switches occurring Tom Lane
• 14:48   Re: Read only transactions - Commit or Rollback Tom Lane
• 15:02   Re: Read only transactions - Commit or Rollback Greg Stark
• 15:08   Re: Read only transactions - Commit or Rollback Markus Schaber
• 15:17   Re: Read only transactions - Commit or Rollback Tom Lane
• 15:51   Re: PostgreSQL and Ultrasparc T1 Richard_D_Levine@raytheon.com
• 16:25   Re: PostgreSQL and Ultrasparc T1 Jignesh K. Shah
• 17:26   What's the best hardver for PostgreSQL 8.1? Antal Attila
• 17:56   Re: Overriding the optimizer Jim C. Nasby
• 18:16   Re: make bulk deletes faster? Jim C. Nasby
• 18:22   Re: PostgreSQL and Ultrasparc T1 Jim C. Nasby
• 18:34   Re: PostgreSQL and Ultrasparc T1 Jim C. Nasby
• 18:47   Re: Any way to optimize GROUP BY queries? Jim C. Nasby
• 18:50   Re: High context switches occurring Anjan Dave
• 18:52   Re: separate drives for WAL or pgdata files Jim C. Nasby
• 18:59   Re: filesystem performance with lots of files Jim C. Nasby
• 19:06   Re: What's the best hardver for PostgreSQL 8.1? Jim C. Nasby
• 20:08   Re: What's the best hardver for PostgreSQL 8.1? Vivek Khera
• 20:48   Re: Any way to optimize GROUP BY queries? Tom Lane
• 23:43   Re: What's the best hardver for PostgreSQL 8.1? Juan Casero

21 December 2005

• 01:50   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 04:01   effizient query with jdbc Bühler, Johannes
• 04:01   effizient query with jdbc Bühler, Johannes
• 04:01   effizient query with jdbc Johannes Bühler
• 04:01   Re: Simple Join Mitchell Skinner
• 04:02   SAN/NAS options Charles Sprickman
• 04:02   effizient query with jdbc johannesbuehler@oderbruecke.de
• 04:02   Speed of different procedural language Ben Trewern
• 04:03   Re: [postgis-users] Is my query planner failing me,or vice versa? Mark Cave-Ayland
• 04:58   Re: SAN/NAS options Charles Sprickman
• 05:55   Re: Simple Join Mark Kirkwood
• 08:05   Windows performance again Josep Maria Pinyol Fontseca
• 09:04   Re: Windows performance again Richard Huxton
• 09:17   Re: SAN/NAS options Alex Stapleton
• 09:37   Re: What's the best hardver for PostgreSQL 8.1? Antal Attila
• 09:47   Re: SAN/NAS options Luke Lonergan
• 10:06   Re: Speed of different procedural language Steinar H. Gunderson
• 10:25   Re: [GENERAL] need help Alban Medici \(NetCentrex\)
• 11:10   Re: 2 phase commit: performance implications? Andy Ballingall
• 13:48   Re: Windows performance again Greg Stark
• 15:10   Re: Windows performance again Tom Lane
• 17:02   Wrong index used when ORDER BY LIMIT 1 Szűcs Gábor
• 17:16   ORDER BY costs Carlos Benkendorf
• 17:40   Re: Windows performance again Merlin Moncure
• 17:51   Re: Wrong index used when ORDER BY LIMIT 1 Michael Fuhr
• 18:34   Re: Wrong index used when ORDER BY LIMIT 1 Tom Lane
• 18:39   Re: ORDER BY costs Tom Lane
• 19:43   Re: Speed of different procedural language Merlin Moncure
• 20:24   Re: Speed of different procedural language Michael Fuhr
• 20:38   Re: Speed of different procedural language Steinar H. Gunderson
• 21:10   Re: Speed of different procedural language Michael Fuhr
• 22:57   Re: What's the best hardver for PostgreSQL 8.1? William Yu
• 23:35   Re: ORDER BY costs Carlos Benkendorf

22 December 2005

• 00:08   Re: Speed of different procedural language Steinar H. Gunderson
• 00:20   CPU and RAM Harry Jackson
• 01:03   MySQL is faster than PgSQL but a large margin in my program... any ideas why? Madison Kelly
• 01:13   Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why? Stephen Frost
• 01:13   Re: Speed of different procedural language Michael Fuhr
• 01:52   Re: MySQL is faster than PgSQL but a large margin in my program... any ideas why? Kevin Brown
• 02:01   Re: What's the best hardver for PostgreSQL 8.1? Juan Casero
• 02:33   Re: MySQL is faster than PgSQL but a large margin in Luke Lonergan
• 02:34   Re: What's the best hardver for PostgreSQL 8.1? Tom Arthurs
• 02:45   Re: Speed of different procedural language Tom Lane
• 03:01   Re: CPU and RAM Qingqing Zhou
• 03:17   Re: What's the best hardver for PostgreSQL 8.1? Jignesh K. Shah
• 05:59   Re: MySQL is faster than PgSQL but a large margin in my Madison Kelly
• 06:02   Re: MySQL is faster than PgSQL but a large margin in Madison Kelly
• 06:08   Re: MySQL is faster than PgSQL but a large margin in Luke Lonergan
• 06:10   Re: MySQL is faster than PgSQL but a large margin in Luke Lonergan
• 08:20   Re: CPU and RAM Richard Huxton
• 11:59   Re: Wrong index used when ORDER BY LIMIT 1 Szűcs Gábor
• 12:29   Re: Speed of different procedural language Merlin Moncure
• 12:35   Re: MySQL is faster than PgSQL but a large margin in Markus Schaber
• 13:06   Re: ORDER BY costs Carlos Benkendorf
• 13:17   Re: effizient query with jdbc Dave Cramer
• 14:31   Re: effizient query with jdbc Steve Peterson
• 15:23   Re: ORDER BY costs Carlos Benkendorf

23 December 2005

• 01:35   Re: What's the best hardver for PostgreSQL 8.1? Juan Casero
• 01:35   Re: MySQL is faster than PgSQL but a large margin in Juan Casero
• 02:16   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 02:53   Re: CPU and RAM Greg Stark
• 03:00   Re: What's the best hardver for PostgreSQL 8.1? Juan Casero
• 03:18   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 03:28   Re: CPU and RAM Qingqing Zhou
• 08:02   DELETE, INSERT vs SELECT, UPDATE || INSERT Anton Maksimenkov
• 11:34   Order by behaviour Carlos Benkendorf
• 11:51   Re: Order by behaviour Mario Weilguni
• 12:32   Re: Order by behaviour Carlos Benkendorf
• 12:34   Re: Order by behaviour Guido Neitzer
• 13:35   Re: Order by behaviour Carlos Benkendorf
• 13:37   Re: Order by behaviour Kresimir Tonkovic
• 14:03   Re: Order by behaviour Guido Neitzer
• 14:30   Re: DELETE, INSERT vs SELECT, UPDATE || INSERT Tom Lane
• 14:54   Re: Order by behaviour Tom Lane
• 15:16   Re: MySQL is faster than PgSQL but a large margin in Vivek Khera
• 15:23   Re: What's the best hardver for PostgreSQL 8.1? Vivek Khera
• 21:15   Re: What's the best hardver for PostgreSQL 8.1? Mark Kirkwood

24 December 2005

• 00:49   Re: Order by behaviour Carlos Benkendorf
• 03:00   Re: What's the best hardver for PostgreSQL 8.1? Vivek Khera
• 18:50   Re: What's the best hardver for PostgreSQL 8.1? Frank Wiles
• 20:31   Re: What's the best hardver for PostgreSQL 8.1? Ron
• 20:42   Re: What's the best hardver for PostgreSQL 8.1? Joshua D. Drake
• 20:57   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 21:25   Re: What's the best hardver for PostgreSQL 8.1? Ron
• 21:37   Re: What's the best hardver for PostgreSQL 8.1? William Yu
• 21:45   Re: What's the best hardver for PostgreSQL 8.1? Ron
• 21:53   Re: What's the best hardver for PostgreSQL 8.1? Sander Steffann

25 December 2005

• 00:52   Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan
• 02:04   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 02:16   Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan
• 02:44   Re: What's the best hardver for PostgreSQL 8.1? William Yu
• 03:20   Re: What's the best hardver for PostgreSQL 8.1? Joshua D. Drake
• 11:15   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 11:29   Re: What's the best hardver for PostgreSQL 8.1? Steinar H. Gunderson
• 14:10   Re: What's the best hardver for PostgreSQL 8.1? Bruno Wolff III
• 16:38   Re: What's the best hardver for PostgreSQL 8.1? Michael Stone

26 December 2005

• 10:21   Re: What's the best hardver for PostgreSQL 8.1? Benjamin Arai
• 11:13   Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan
• 11:32   Fwd: vacuuming template0 gave ERROR Gourish Singbal
• 16:38   Re: What's the best hardver for PostgreSQL 8.1? Alex Turner
• 17:13   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 17:39   Re: What's the best hardver for PostgreSQL 8.1? Benjamin Arai
• 17:50   Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan
• 20:03   Performance hit on large row counts David Scott
• 20:36   Re: Performance hit on large row counts Tom Lane
• 20:37   Bitmap indexes etc. Ivan Voras
• 20:57   Re: Bitmap indexes etc. Tom Lane
• 21:54   Re: What's the best hardver for PostgreSQL 8.1? Alex Turner
• 22:04   Re: What's the best hardver for PostgreSQL 8.1? Alex Turner
• 22:07   Re: Performance hit on large row counts David Scott
• 22:30   Re: What's the best hardver for PostgreSQL 8.1? David Lang
• 22:52   Re: Performance hit on large row counts Tom Lane

27 December 2005

• 06:24   Re: What's the best hardver for PostgreSQL 8.1? Dawid Kuroczko
• 12:25   Re: Bitmap indexes etc. Ivan Voras
• 12:35   Re: What's the best hardver for PostgreSQL 8.1? Michael Stone
• 15:16   Performance problems with 8.1.1 compared to 7.4.7 Albert Cervera Areny
• 15:50   Re: What's the best hardver for PostgreSQL 8.1? Ron
• 16:13   Re: Performance problems with 8.1.1 compared to 7.4.7 Michael Fuhr
• 16:52   Re: What's the best hardver for PostgreSQL 8.1? Bruce Momjian
• 17:02   Re: Performance problems with 8.1.1 compared to 7.4.7 Albert Cervera Areny
• 17:56   Re: Performance problems with 8.1.1 compared to 7.4.7 Frank Wiles
• 18:05   Re: What's the best hardver for PostgreSQL 8.1? Michael Stone
• 18:18   Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan
• 18:24   Re: What's the best hardver for PostgreSQL 8.1? Luke Lonergan
• 18:57   Re: What's the best hardver for PostgreSQL 8.1? Ron
• 20:15   Re: What's the best hardver for PostgreSQL 8.1? Michael Stone
• 21:47   Re: What's the best hardver for PostgreSQL 8.1? Ron

29 December 2005

• 08:48   How import big amounts of data? Arnau
• 09:50   Re: How import big amounts of data? Steinar H. Gunderson
• 10:39   Re: How import big amounts of data? Dennis Bjorklund
• 13:20   Re: How import big amounts of data? Ron
• 13:41   Re: How import big amounts of data? Teemu Torma
• 15:19   Re: How import big amounts of data? Arnau
• 16:05   Re: How import big amounts of data? Teemu Torma
• 20:22   Process executing COPY opens and reads every table on the system Jeffrey W. Baker
• 21:09   Invulnerable VACUUM process thrashing everything Jeffrey W. Baker
• 21:42   Re: Invulnerable VACUUM process thrashing everything Ron

30 December 2005

• 01:16   Re: Invulnerable VACUUM process thrashing everything Jeffrey W. Baker
• 01:43   Re: Invulnerable VACUUM process thrashing everything Russ Garrett
• 02:03   Re: Invulnerable VACUUM process thrashing everything Tom Lane
• 05:59   unsubscribe Arup Dutta
• 07:38   Re: CPU and RAM Harry Jackson