Mailing lists [pgsql-performance]

1 April 2004

• 00:14   Re: What index for 'like (%keyword%)' ??? Christopher Kings-Lynne
• 18:21   PostgreSQL and Linux 2.6 kernel. Gary Doades
• 22:00   single index on more than two coulumns a bad thing? Palle Girgensohn
• 23:36   Re: single index on more than two coulumns a bad thing? Josh Berkus

2 April 2004

• 03:38   Re: single index on more than two coulumns a bad thing? Tom Lane
• 03:44   Re: Index Performance Help Greg Stark
• 03:59   Re: single index on more than two coulumns a bad thing? Greg Stark
• 05:32   Re: PostgreSQL and Linux 2.6 kernel. Tom Lane
• 06:04   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 10:56   Re: single index on more than two coulumns a bad thing? Aaron Werman
• 13:56   Spatial join insists on sequential scan of larger table Clive Page
• 14:47   Re: Spatial join insists on sequential scan of larger table Tom Lane
• 14:53   Re: single index on more than two coulumns a bad thing? Bruno Wolff III
• 15:06   Re: Spatial join insists on sequential scan of larger Clive Page

3 April 2004

• 09:47   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 12:23   Re: single index on more than two coulumns a bad thing? Palle Girgensohn
• 18:00   Re: PostgreSQL and Linux 2.6 kernel. Josh Berkus
• 20:30   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 20:31   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 20:31   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 20:31   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 21:34   Re: Spatial join insists on sequential scan of larger Clive Page
• 21:43   Re: PostgreSQL and Linux 2.6 kernel. Aaron Werman
• 22:52   Re: PostgreSQL and Linux 2.6 kernel. Cott Lang

4 April 2004

• 02:27   Re: PostgreSQL and Linux 2.6 kernel. Mike Nolan
• 08:13   Substitute for this oracle query in postGre Kamalraj Singh Madhan
• 08:45   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 08:52   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 08:56   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 09:06   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 09:44   Re: PostgreSQL and Linux 2.6 kernel. Paul Thomas
• 10:14   Re: Substitute for this oracle query in postGre Christopher Kings-Lynne
• 13:04   Re: PostgreSQL and Linux 2.6 kernel. Cott Lang
• 14:46   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 21:05   Re: single index on more than two coulumns a bad thing? Leeuw van der, Tim

5 April 2004

• 15:42   performance comparission postgresql/ms-sql server Heiko Kehlenbrink
• 15:46   Re: PostgreSQL and Linux 2.6 kernel. Josh Berkus
• 15:53   Re: performance comparission postgresql/ms-sql server Josh Berkus
• 16:08   Re: performance comparission postgresql/ms-sql server Shridhar Daithankar
• 16:11   Re: performance comparission postgresql/ms-sql server Tom Lane
• 16:27   SETOF performance Jeff
• 16:56   Re: PostgreSQL and Linux 2.6 kernel. markw@osdl.org
• 17:05   Re: atrocious update performance Rosser Schwarz
• 17:51   Re: SETOF performance Joe Conway
• 18:27   Re: Delete performance on delete from table with inherited tables Chris Kratz
• 18:46   Estimated rows way off Michael Guerin
• 18:59   Re: PostgreSQL and Linux 2.6 kernel. Magnus Naeslund(t)
• 19:14   Re: PostgreSQL and Linux 2.6 kernel. Gary Doades
• 19:19   Re: single index on more than two coulumns a bad thing? Aaron Werman
• 19:35   Re: atrocious update performance Kevin Barnard
• 21:32   Re: performance comparission postgresql/ms-sql server Matthew T. O'Connor
• 23:22   Re: atrocious update performance Rosser Schwarz

6 April 2004

• 00:48   Re: atrocious update performance scott.marlowe
• 01:35   possible improvement between G4 and G5 Qing Zhao
• 01:37   Re: atrocious update performance Stephan Szabo
• 05:46   Re: possible improvement between G4 and G5 Tom Lane
• 07:26   Re: performance comparission postgresql/ms-sql server Shridhar Daithankar
• 08:04   good pc but bad performance,why? huang yaqin
• 11:15   Re: good pc but bad performance,why? Richard Huxton
• 12:46   Re: good pc but bad performance,why? Bill Moran
• 13:00   Back to Linux 2.6 kernel thoughts... Richard Huxton
• 14:40   Re: performance comparission postgresql/ms-sql server Shridhar Daithankar
• 14:42   Re: performance comparission postgresql/ms-sql server Kaarel
• 15:01   Wierd issues Andrew Matthews
• 15:42   Re: good pc but bad performance,why? Tom Lane
• 15:53   Re: possible improvement between G4 and G5 Jim C. Nasby
• 16:22   Re: possible improvement between G4 and G5 Aaron Werman
• 18:51   Re: possible improvement between G4 and G5 Josh Berkus
• 19:16   Re: good pc but bad performance,why? Stefan Kaltenbrunner
• 20:22   Re: possible improvement between G4 and G5 Aaron Werman
• 20:26   plan problem Ken Geis
• 21:42   Re: possible improvement between G4 and G5 Josh Berkus

7 April 2004

• 04:03   Re: good pc but bad performance,why? huang yaqin
• 07:15   Re: performance comparission postgresql/ms-sql server Heiko Kehlenbrink
• 07:19   Re: [ADMIN] Raw devices vs. Filesystems Grega Bremec
• 08:33   Re: good pc but bad performance,why? Richard Huxton
• 08:38   Re: plan problem Richard Huxton
• 09:00   Re: good pc but bad performance,why? huang yaqin
• 09:03   Re: plan problem Ken Geis
• 09:54   Re: good pc but bad performance,why? Dennis Bjorklund
• 10:41   Re: good pc but bad performance,why? Steven Butler
• 11:30   Re: good pc but bad performance,why? Andrew McMillan
• 11:54   Re: good pc but bad performance,why? Shridhar Daithankar
• 12:31   Re: plan problem Richard Huxton
• 14:36   Re: good pc but bad performance,why? Aaron Werman
• 16:09   Re: [ADMIN] Raw devices vs. Filesystems Josh Berkus
• 16:37   Re: [ADMIN] Raw devices vs. Filesystems Steve Atkins
• 17:07   Re: PostgreSQL and Linux 2.6 kernel. Neil Conway
• 19:10   Postgresql educational sources Nid
• 19:54   Re: good pc but bad performance,why? scott.marlowe
• 20:28   Re: Postgresql educational sources scott.marlowe
• 21:05   statistics Jaime Casanova
• 22:12   Re: good pc but bad performance,why? Bruce Momjian
• 23:48   Re: statistics Paul Thomas

8 April 2004

• 01:31   Re: good pc but bad performance,why? Tom Lane
• 01:33   Re: good pc but bad performance,why? Bruce Momjian
• 02:13   Re: good pc but bad performance,why? Tom Lane
• 03:13   Re: good pc but bad performance,why? Bruce Momjian
• 04:33   Re: [ADMIN] Raw devices vs. Filesystems Grega Bremec
• 07:58   data=writeback Priem, Alexander
• 08:54   Re: good pc but bad performance,why? Andrew McMillan
• 09:01   Re: data=writeback Chris
• 09:25   Re: data=writeback Priem, Alexander
• 09:44   Re: data=writeback Chris
• 09:46   select count(*) on large tables Cosimo Streppone
• 10:09   Re: data=writeback Priem, Alexander
• 10:54   Re: select count(*) on large tables Dennis Bjorklund
• 11:54   Re: good pc but bad performance,why? Geoffrey
• 12:29   Re: data=writeback 
• 14:09   Re: select count(*) on large tables Tom Lane
• 14:52   Re: data=writeback Bruce Momjian
• 14:56   Re: good pc but bad performance,why? Bruce Momjian
• 15:06   Re: Postgresql educational sources Robert Treat
• 17:33   tsearch query plan Mark Lubratt
• 22:42   Re: statistics Jaime Casanova
• 23:33   Re: tsearch query plan Josh Berkus

9 April 2004

• 03:28   Re: tsearch query plan Mark Lubratt
• 05:26   Re: tsearch query plan Tom Lane
• 15:02   Re: Wierd issues Tom Lane
• 16:02   Re: [ADMIN] Raw devices vs. Filesystems Josh Berkus
• 16:50   Re: plan problem Tom Lane
• 17:28   Upgrading question (recycled transaction log) Patrick Hatcher
• 18:03   Re: Upgrading question (recycled transaction log) Tom Lane
• 19:45   Performance data for OpenFTS? Josh Berkus

10 April 2004

• 00:25   Re: good pc but bad performance,why? Shridhar Daithankar
• 00:27   Re: Wierd issues Andrew Matthews

12 April 2004

• 09:27   Index Backward Scan fast / Index Scan slow ! Pailloncy Jean-Gérard
• 11:52   Effect of too many columns Rajesh Kumar Mallah
• 12:13   Re: Effect of too many columns Bruno Wolff III
• 12:28   Re: Index Backward Scan fast / Index Scan slow ! Tom Lane
• 14:39   Deleting certain duplicates Shea,Dan [CIS]
• 15:18   Re: Deleting certain duplicates Shea,Dan [CIS]
• 15:40   index v. seqscan for certain values Jeremy Dunn
• 16:09   Re: index v. seqscan for certain values Bill Moran
• 17:08   Re: index v. seqscan for certain values Jeremy Dunn
• 17:40   Re: index v. seqscan for certain values Stephan Szabo
• 17:51   Re: index v. seqscan for certain values Tom Lane
• 19:02   Re: Index Backward Scan fast / Index Scan slow ! Pailloncy Jean-Gérard
• 19:03   Re: Index Backward Scan fast / Index Scan slow ! (Modifié par Pailloncy Jean-Gérard) Pailloncy Jean-Gérard
• 19:05   Re: index v. seqscan for certain values Jeremy Dunn
• 19:52   Re: index v. seqscan for certain values Bruno Wolff III
• 20:55   Re: Re: Index Backward Scan fast / Index Scan slow ! (Modifié par Pailloncy Jean-Gérard)  Tom Lane
• 21:02   Re: index v. seqscan for certain values Tom Lane
• 21:24   Re: Index Backward Scan fast / Index Scan slow ! Tom Lane

13 April 2004

• 00:17   Tracking down performance issue Ken Geis
• 11:12   Re: Index Backward Scan fast / Index Scan slow ! Pailloncy Jean-Gérard
• 13:47   Re: Index Backward Scan fast / Index Scan slow ! Tom Lane
• 14:26   Re: Deleting certain duplicates Rajesh Kumar Mallah
• 14:41   Re: index v. seqscan for certain values Jeremy Dunn
• 17:55   Re: index v. seqscan for certain values Tom Lane
• 18:02   query slows down with more accurate stats Robert Treat
• 18:04   Re: index v. seqscan for certain values Jeremy Dunn
• 18:35   Re: index v. seqscan for certain values Robert Treat
• 19:10   configure shmmax on MAC OS X Qing Zhao
• 19:18   Re: query slows down with more accurate stats Tom Lane
• 19:25   Re: configure shmmax on MAC OS X Jeff Bohmer
• 19:55   Re: configure shmmax on MAC OS X Tom Lane
• 20:10   Re: configure shmmax on MAC OS X Qing Zhao
• 20:49   View columns calculated Peter Darley
• 20:59   Re: configure shmmax on MAC OS X Joshua D. Drake
• 21:23   Re: View columns calculated Tom Lane

14 April 2004

• 12:39    Pailloncy Jean-Gérard
• 13:23   Re: Tom Lane
• 17:53   select count(*) very slow on an already vacuumed table. Rajesh Kumar Mallah
• 19:09   Re: select count(*) very slow on an already vacuumed table. Richard Huxton
• 20:12   Re: PostgreSQL and Linux 2.6 kernel. Simon Riggs
• 20:42   Re: select count(*) very slow on an already vacuumed table. Rajesh Kumar Mallah

15 April 2004

• 07:08   Re: select count(*) very slow on an already vacuumed table. Rajesh Kumar Mallah
• 07:17   linux distro for better pg performance pginfo
• 07:32   Re: select count(*) very slow on an already vacuumed table. Rajesh Kumar Mallah
• 07:53   Re: select count(*) very slow on an already vacuumed table. Richard Huxton
• 10:29   Re: select count(*) very slow on an already vacuumed table. Rajesh Kumar Mallah
• 11:34   Re: [ SOLVED ] select count(*) very slow on an already Rajesh Kumar Mallah
• 12:10   Toooo many context switches (maybe SLES8?) Dirk Lutzebäck
• 12:13   Re: [ SOLVED ] select count(*) very slow on an already pginfo
• 13:36   Re: [ SOLVED ] select count(*) very slow on an already Bill Moran
• 13:40   Re: linux distro for better pg performance Gavin M. Roy
• 16:05   Re: Toooo many context switches (maybe SLES8?) Joe Conway
• 16:19   Re: [ SOLVED ] select count(*) very slow on an already Rajesh Kumar Mallah
• 16:29   Re: Toooo many context switches (maybe SLES8?) Dirk Lutzebäck
• 16:42   Re: Toooo many context switches (maybe SLES8?) Joe Conway
• 17:17   Re: PostgreSQL and Linux 2.6 kernel. Bruno Wolff III
• 17:39   Re: Toooo many context switches (maybe SLES8?) Josh Berkus
• 17:44   Re: [ SOLVED ] select count(*) very slow on an already Richard Huxton
• 18:28   Re: linux distro for better pg performance J. Andrew Rogers
• 18:30   Re: [ SOLVED ] select count(*) very slow on an already Mark Lubratt
• 18:48   Re: [ SOLVED ] select count(*) very slow on an already Bill Moran
• 19:24   Re: [ SOLVED ] select count(*) very slow on an already Shea,Dan [CIS]
• 19:35   Re: PostgreSQL and Linux 2.6 kernel. Simon Riggs
• 19:38   Re: Toooo many context switches (maybe SLES8?) Tom Lane
• 20:13   Re: [ SOLVED ] select count(*) very slow on an already Bill Moran
• 20:37   Re: Toooo many context switches (maybe SLES8?) Josh Berkus
• 20:40   Re: PostgreSQL and Linux 2.6 kernel. Josh Berkus
• 21:38   Re: PostgreSQL and Linux 2.6 kernel. Greg Stark
• 22:19   Re: PostgreSQL and Linux 2.6 kernel. Geoffrey
• 22:21   Re: PostgreSQL and Linux 2.6 kernel. Tom Lane
• 23:02   Re: index v. seqscan for certain values Manfred Koizar
• 23:30   Re: query slows down with more accurate stats Manfred Koizar

16 April 2004

• 00:18   Re: query slows down with more accurate stats Tom Lane
• 01:05   Re: PostgreSQL and Linux 2.6 kernel. Joshua D. Drake
• 02:27   Re: PostgreSQL and Linux 2.6 kernel. Greg Stark
• 07:24   Re: PostgreSQL and Linux 2.6 kernel. Simon Riggs
• 08:22   Re: [ SOLVED ] select count(*) very slow on an already Rajesh Kumar Mallah
• 10:13   Re: query slows down with more accurate stats Manfred Koizar
• 13:03   RESOLVED: Re: Wierd context-switching issue on Xeon Dirk Lutzebäck
• 13:40   Re: [ SOLVED ] select count(*) very slow on an already Shea,Dan [CIS]
• 13:49   Re: RESOLVED: Re: Wierd context-switching issue on Xeon Tom Lane
• 14:34   Re: query slows down with more accurate stats Tom Lane
• 15:17   Poor performance of group by query Jim C. Nasby
• 15:28   Long running queries degrade performance Chris Kratz
• 15:37   Re: query slows down with more accurate stats Robert Treat
• 15:45   Horribly slow hash join Jim C. Nasby
• 15:46   Re: Long running queries degrade performance Mike Nolan
• 16:34   Re: Horribly slow hash join Tom Lane
• 16:37   Re: Poor performance of group by query Tom Lane
• 16:40   Index Problem? Ron St-Pierre
• 16:46   Re: Horribly slow hash join Jim C. Nasby
• 16:57   Re: RESOLVED: Re: Wierd context-switching issue on Xeon Josh Berkus
• 17:01   Re: Index Problem? Josh Berkus
• 17:05   Re: Horribly slow hash join Tom Lane
• 17:52   Re: Deleting certain duplicates Shea,Dan [CIS]
• 17:54   Re: Index Problem? Ron St-Pierre
• 17:56   Re: Long running queries degrade performance Chris Kratz
• 19:10   Re: Index Problem? Josh Berkus
• 20:05   Re: Index Problem? Tom Lane
• 20:25   Re: Long running queries degrade performance Mike Nolan
• 20:51   Re: Long running queries degrade performance Chris Kratz
• 21:12   Re: Long running queries degrade performance Tom Lane
• 21:26   Re: Long running queries degrade performance Chris Kratz
• 21:45   sunquery and estimated rows Litao Wu
• 21:53   Re: Index Problem? Ron St-Pierre
• 22:24   Re: query slows down with more accurate stats Manfred Koizar
• 22:57   Re: Poor performance of group by query Greg Stark
• 23:45   Re: sunquery and estimated rows Tom Lane

17 April 2004

• 13:12   Re: Long running queries degrade performance Christopher Browne
• 14:29   Re: [ SOLVED ] select count(*) very slow on an already Jeff
• 16:08   Re: Horribly slow hash join Tom Lane
• 20:35   Re: Horribly slow hash join Marcos Martínez(R)
• 23:04   Re: Horribly slow hash join Greg Stark

18 April 2004

• 03:34   Re: Poor performance of group by query Mark Kirkwood
• 03:46   Re: Horribly slow hash join Tom Lane
• 06:18   Re: Horribly slow hash join Dennis Bjorklund
• 06:43   Re: Horribly slow hash join Greg Stark
• 15:39   Re: Horribly slow hash join Tom Lane
• 15:46   Re: Horribly slow hash join Tom Lane
• 15:58   Re: Horribly slow hash join Dennis Bjorklund
• 16:23   Re: Horribly slow hash join Tom Lane
• 16:27   Re: Horribly slow hash join Dennis Bjorklund
• 18:47   Re: Toooo many context switches (maybe SLES8?) Dave Cramer
• 19:22   Re: sunquery and estimated rows Markus Bertheau
• 21:47   Re: Wierd context-switching issue on Xeon Tom Lane
• 23:09   Re: sunquery and estimated rows Tom Lane
• 23:32   Re: Wierd context-switching issue on Xeon Dave Cramer

19 April 2004

• 00:40   Re: Wierd context-switching issue on Xeon Greg Stark
• 02:16   Re: sunquery and estimated rows Tom Lane
• 02:20   Re: Wierd context-switching issue on Xeon Tom Lane
• 02:30   Re: Wierd context-switching issue on Xeon Tom Lane
• 03:12   Re: Horribly slow hash join Bruno Wolff III
• 03:20   Re: Wierd context-switching issue on Xeon Tom Lane
• 04:43   Re: Horribly slow hash join Dennis Bjorklund
• 05:29   Re: Horribly slow hash join Greg Stark
• 06:09   Re: Horribly slow hash join Tom Lane
• 07:28   Re: RESOLVED: Re: Wierd context-switching issue on Xeon Dirk Lutzebäck
• 11:02   very slow simple query - outer join makes it quicker Gerard Isdell
• 12:02   Re: very slow simple query - outer join makes it quicker Rod Taylor
• 12:05   Re: Horribly slow hash join Dave Cramer
• 12:12   Re: Horribly slow hash join Greg Stark
• 12:16   Re: Horribly slow hash join Greg Stark
• 12:30   Re: Wierd context-switching issue on Xeon Dave Cramer
• 12:37   Re: very slow simple query - outer join makes it quicker Rod Taylor
• 13:52   Re: Wierd context-switching issue on Xeon Anjan Dave
• 16:00   Re: query slows down with more accurate stats Tom Lane
• 17:52   Re: Wierd context-switching issue on Xeon Josh Berkus
• 18:02   Re: Wierd context-switching issue on Xeon Tom Lane
• 18:02   Re: Wierd context-switching issue on Xeon J. Andrew Rogers
• 18:10   Re: possible improvement between G4 and G5 Vivek Khera
• 18:33   Re: Wierd context-switching issue on Xeon Bruce Momjian
• 20:16   Re: Wierd context-switching issue on Xeon scott.marlowe
• 21:02   Re: Wierd context-switching issue on Xeon Joe Conway
• 21:54   Re: Wierd context-switching issue on Xeon Josh Berkus
• 22:56   Re: Wierd context-switching issue on Xeon Tom Lane

20 April 2004

• 00:02   Re: Wierd context-switching issue on Xeon Tom Lane
• 00:53   Re: Wierd context-switching issue on Xeon Tom Lane
• 02:29   order by index, and inheritance Michiel Meeuwissen
• 03:00   Re: Wierd context-switching issue on Xeon Joe Conway
• 03:11   Re: sunquery and estimated rows Litao Wu
• 03:37   Why will vacuum not end? Shea,Dan [CIS]
• 03:47   Re: Wierd context-switching issue on Xeon Robert Creager
• 03:57   Re: Why will vacuum not end? Christopher Kings-Lynne
• 05:20   Re: Wierd context-switching issue on Xeon jelle
• 10:35   Re: Wierd context-switching issue on Xeon ohp@pyrenet.fr
• 11:16   Re: Deleting certain duplicates Greg Sabino Mullane
• 12:46   Re: Wierd context-switching issue on Xeon Jeff
• 12:58   Re: Why will vacuum not end? Shea,Dan [CIS]
• 13:04   Re: Wierd context-switching issue on Xeon Dave Cramer
• 13:14   Re: Why will vacuum not end? Bill Moran
• 13:44   Re: Wierd context-switching issue on Xeon Matt Clark
• 13:58   Any way to 'analyze' indexes to get updated sizes? Jeremy M. Guthrie
• 13:58   Re: Toooo many context switches (maybe SLES8?) Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
• 13:58   Re: Index Problem? Jochem van Dieten
• 13:58   Re: sunquery and estimated rows Rod Taylor
• 13:58   Re: Wierd context-switching issue on Xeon Sven Geisler
• 13:58   Re: possible improvement between G4 and G5 Aaron Werman
• 13:59   seeking consultant for high performance, complex searching with Postgres web app Mark Stosberg
• 14:01   Re: Wierd context-switching issue on Xeon Dirk.Lutzebaeck@t-online.de (Dirk Lutzebaeck)
• 14:48   Re: Toooo many context switches (maybe SLES8?) Dave Cramer
• 15:28   Re: Wierd context-switching issue on Xeon Dirk Lutzebäck
• 15:39   Use of subquery causes seq scan??? Chris Hoover
• 23:18   Re: Wierd context-switching issue on Xeon Paul Tuckfield
• 23:34   Re: Wierd context-switching issue on Xeon Rod Taylor
• 23:34   Re: Use of subquery causes seq scan??? Tom Lane
• 23:34   Moving postgres to FC disks Anjan Dave
• 23:35   Re: Horribly slow hash join Jim C. Nasby

21 April 2004

• 00:24   Re: Moving postgres to FC disks Joshua D. Drake
• 00:34   Re: Wierd context-switching issue on Xeon Paul Tuckfield
• 00:41   Re: Wierd context-switching issue on Xeon Josh Berkus
• 00:42   Re: Use of subquery causes seq scan??? Bruno Wolff III
• 01:14   Re: 225 times slower Pailloncy Jean-Gérard
• 01:14   Re: Wierd context-switching issue on Xeon J. Andrew Rogers
• 01:21   Re: Why will vacuum not end? Christopher Kings-Lynne
• 01:31   Re: Wierd context-switching issue on Xeon Josh Berkus
• 01:50   Re: Wierd context-switching issue on Xeon Bruce Momjian
• 01:50   Re: Wierd context-switching issue on Xeon Anjan Dave
• 01:50   pgbench written in Pro*C Bruce Momjian
• 01:51   Re: seeking consultant for high performance, complex searching Rajesh Kumar Mallah
• 01:51   Re: Persistent Connections Thomas Swan
• 02:14   Re: Moving postgres to FC disks Aaron Werman
• 02:38   Re: Wierd context-switching issue on Xeon Dave Cramer
• 02:51   Re: pgbench written in Pro*C Tom Lane
• 03:32   Re: pgbench written in Pro*C Bruce Momjian
• 03:47   Re: Wierd context-switching issue on Xeon Joe Conway
• 06:37   Re: Wierd context-switching issue on Xeon pginfo
• 07:17   slow seqscan Edoardo Ceccarelli
• 07:46   Re: slow seqscan Christopher Kings-Lynne
• 07:48   Re: slow seqscan Nick Barr
• 08:31   MySQL vs PG TPC-H benchmarks Nick Barr
• 08:34   Re: slow seqscan Edoardo Ceccarelli
• 08:48   Re: slow seqscan Christopher Kings-Lynne
• 09:41   Re: slow seqscan Edoardo Ceccarelli
• 10:10   Re: slow seqscan Edoardo Ceccarelli
• 10:15   Re: slow seqscan Christopher Kings-Lynne
• 11:19   Re: Wierd context-switching issue on Xeon ohp@pyrenet.fr
• 11:50   Re: slow seqscan Edoardo Ceccarelli
• 12:12   Re: Wierd context-switching issue on Xeon Dirk Lutzebäck
• 12:19   Re: MySQL vs PG TPC-H benchmarks Rod Taylor
• 12:22   Re: MySQL vs PG TPC-H benchmarks Rod Taylor
• 12:56   Re: MySQL vs PG TPC-H benchmarks Paul Thomas
• 13:32   Re: MySQL vs PG TPC-H benchmarks Cestmir Hybl
• 14:09   Re: MySQL vs PG TPC-H benchmarks Paul Thomas
• 14:37   Re: slow seqscan Stephan Szabo
• 15:06   Re: Wierd context-switching issue on Xeon Dave Cramer
• 15:46   Help understanding stat tables Chris Hoover
• 16:35   Shared buffers, Sort memory, Effective Cache Size Frédéric Robinet
• 16:42   Re: Help understanding stat tables Chris Hoover
• 16:42   Re: slow seqscan Edoardo Ceccarelli
• 17:30   Re: Wierd context-switching issue on Xeon Josh Berkus
• 17:47   Re: MySQL vs PG TPC-H benchmarks Josh Berkus
• 18:19   Re: Wierd context-switching issue on Xeon Paul Tuckfield
• 18:20   Re: slow seqscan Tom Lane
• 18:51   Re: Wierd context-switching issue on Xeon Tom Lane
• 18:57   Re: MySQL vs PG TPC-H benchmarks Matthew T. O'Connor
• 19:09   Re: Help understanding stat tables Tom Lane
• 19:13   Re: Wierd context-switching issue on Xeon Dave Cramer
• 19:44   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Jan Wieck
• 20:47   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer
• 21:50   Re: Moving postgres to FC disks Cott Lang

22 April 2004

• 01:46   Re: Wierd context-switching issue on Xeon Tom Lane
• 02:36   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane
• 02:56   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus
• 04:24   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane
• 04:37   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Christopher Kings-Lynne
• 04:56   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Bruce Momjian
• 05:13   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane
• 06:03   Re: 225 times slower Tom Lane
• 06:04   Re: Wierd context-switching issue on Xeon Tom Lane
• 06:44   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer
• 07:17   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer
• 12:37   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane
• 12:56   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Eduardo Almeida
• 14:06   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Eduardo Almeida
• 16:28   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Jan Wieck
• 17:12   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Grega Bremec
• 17:29   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Tom Lane
• 17:54   Setting Shared Buffers , Effective Cache, Sort Mem Parameters Pallav Kalva
• 19:25   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus
• 19:47   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Tom Lane
• 20:05   Re: 225 times slower Pailloncy Jean-Gérard
• 20:24   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Bruce Momjian
• 20:31   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Markus Bertheau
• 20:45   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus
• 21:02   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Tom Lane
• 21:28   Re: [pgsql-advocacy] MySQL vs PG TPC-H benchmarks Eduardo Almeida
• 22:28   Looking for ideas on how to speed up warehouse loading Sean Shanny
• 22:57   Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters Manfred Koizar
• 23:07   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Rod Taylor
• 23:09   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Magnus Hagander
• 23:12   Re: Setting Shared Buffers , Effective Cache, Sort Mem scott.marlowe
• 23:54   Re: Looking for ideas on how to speed up warehouse loading Sean Shanny

23 April 2004

• 00:56   Re: Looking for ideas on how to speed up warehouse loading Nicholas Shanny
• 02:03   Re: Looking for ideas on how to speed up warehouse loading Tom Lane
• 02:28   Re: Wierd context-switching issue on Xeon Anjan Dave
• 04:39   Re: Looking for ideas on how to speed up warehouse loading Joe Conway
• 12:19   Re: Looking for ideas on how to speed up warehouse loading Aaron Werman
• 13:32   Help with performance problems Chris Hoover
• 16:16   Re: Help with performance problems Aaron Werman
• 16:29   Re: Looking for ideas on how to speed up warehouse loading scott.marlowe
• 16:43   Re: Help with performance problems Josh Berkus
• 17:16   Re: Help with performance problems Chris Hoover
• 17:25   Re: Help with performance problems scott.marlowe
• 17:53   Re: Help with performance problems Chris Hoover
• 18:01   Re: Help with performance problems Chris Hoover
• 18:16   Re: Help with performance problems Josh Berkus
• 18:19   Re: Why will vacuum not end? Shea,Dan [CIS]
• 18:48   Re: Why will vacuum not end? Josh Berkus
• 18:56   Re: Help with performance problems Ron St-Pierre
• 19:27   Re: Help with performance problems Chris Hoover
• 20:02   Re: Help with performance problems scott.marlowe
• 21:35   Re: Help with performance problems Ron St-Pierre
• 21:42   Re: Setting Shared Buffers , Effective Cache, Sort Mem Parameters Manfred Koizar
• 22:04   Re: Setting Shared Buffers , Effective Cache, Sort Mem Ron Mayer

24 April 2004

• 02:50   Re: Setting Shared Buffers , Effective Cache, Sort Mem Tom Lane
• 03:00   Re: Help with performance problems Tom Lane
• 04:28   Re: order by index, and inheritance Rod Taylor
• 04:29   Re: order by index, and inheritance Rod Taylor
• 14:45   Re: Why will vacuum not end? Shea,Dan [CIS]
• 15:36   Re: Why will vacuum not end? Josh Berkus
• 15:38   Re: Setting Shared Buffers , Effective Cache, Sort Mem Josh Berkus
• 17:55   Re: Why will vacuum not end? Manfred Koizar
• 19:48   Re: Why will vacuum not end? Shea,Dan [CIS]
• 19:58   Re: Why will vacuum not end? Shea,Dan [CIS]

25 April 2004

• 00:02   Re: Why will vacuum not end? Manfred Koizar
• 00:26   Re: Why will vacuum not end? Manfred Koizar
• 01:50   Re: Why will vacuum not end? Josh Berkus
• 07:13   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Andrew McMillan
• 13:05   Re: Why will vacuum not end? Shea,Dan [CIS]
• 20:24   Number of pages in a random sample (was: query slows down with more accurate stats) Manfred Koizar
• 20:44   Re: Why will vacuum not end? Manfred Koizar

26 April 2004

• 09:02   Re: OT: Help with performance problems Rob Fielding
• 17:46   Re: Wierd context-switching issue on Xeon Magnus Naeslund(t)
• 17:47   Re: Shared buffers, Sort memory, Effective Cache Size Qing Zhao
• 17:51   index usage brad-pgperf@duttonbros.com
• 17:51   Re: Wierd context-switching issue on Xeon Kenneth Marshall
• 17:51   Re: Looking for ideas on how to speed up warehouse loading CoL
• 17:55   Re: order by index, and inheritance Michiel Meeuwissen
• 17:55   Re: order by index, and inheritance Michiel Meeuwissen
• 19:46   Re: Help with performance problems Chris Hoover
• 20:24   planner/optimizer question brad-pgperf@duttonbros.com
• 20:57   is a good practice to create an index on the oid? Edoardo Ceccarelli
• 22:24   Re: Wierd context-switching issue on Xeon Josh Berkus
• 22:25   Re: index usage brad-pgperf@duttonbros.com
• 22:46   Re: index usage Stephan Szabo
• 23:00   Re: [JDBC] is a good practice to create an index on the oid? Dave Cramer

27 April 2004

• 00:03   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus
• 00:11   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer
• 02:43   Re: is a good practice to create an index on the oid? Christopher Kings-Lynne
• 11:55   Re: [JDBC] is a good practice to create an index on the Dave Cramer
• 12:09   Re: Shared buffers, Sort memory, Effective Cache Size Manfred Koizar
• 12:54   Re: planner/optimizer question Atesz
• 15:01   Re: [JDBC] is a good practice to create an index on the Christopher Kings-Lynne
• 15:14   Re: [JDBC] is a good practice to create an index on the Dave Cramer
• 17:32   Join problem Silke Trissl
• 18:03   Re: OT: Help with performance problems scott.marlowe
• 18:05   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus
• 18:24   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Dave Cramer
• 21:02   Re: Wierd context-switching issue on Xeon patch for 7.4.1 Josh Berkus
• 21:27   Simply join in PostrgeSQL takes too long Vitaly Belman
• 21:43   Re: [JDBC] is a good practice to create an index on the Edoardo Ceccarelli
• 21:56   Re: Simply join in PostrgeSQL takes too long Atesz
• 22:00   Re: Simply join in PostrgeSQL takes too long Nick Barr
• 22:01   Re: Simply join in PostrgeSQL takes too long Rod Taylor
• 22:36   Re: Simply join in PostrgeSQL takes too long Josh Berkus

28 April 2004

• 01:25   Re: [JDBC] is a good practice to create an index on the Christopher Kings-Lynne
• 04:28   Re: planner/optimizer question Tom Lane
• 06:35   Re: planner/optimizer question Gary Doades
• 06:58   Re: planner/optimizer question Christopher Kings-Lynne
• 07:07   Re: planner/optimizer question Gary Doades
• 07:18   Re: planner/optimizer question Christopher Kings-Lynne
• 07:32   Re: planner/optimizer question Manfred Koizar
• 08:12   Re: Join problem Suller András
• 08:13   Re: [JDBC] is a good practice to create an index on the Edoardo Ceccarelli
• 08:24   Re: Simply join in PostrgeSQL takes too long Manfred Koizar
• 08:31   Re: [JDBC] is a good practice to create an index on the Christopher Kings-Lynne
• 08:39   Re: [JDBC] is a good practice to create an index on the Bruno Wolff III
• 12:24   Re: Simply join in PostrgeSQL takes too long Rod Taylor
• 12:52   Re: Join problem Tom Lane
• 13:05   Re: planner/optimizer question Tom Lane
• 15:41   Re: index usage scott.marlowe
• 16:42   Re: index usage Tom Lane
• 19:57   Re: [ADMIN] 7.4.2 out of memory scott.marlowe

29 April 2004

• 02:41   Re: Wierd context-switching issue on Xeon Robert Creager
• 13:20   Re: Wierd context-switching issue on Xeon ohp@pyrenet.fr
• 16:41   Use arrays or not? Roelant Ossewaarde
• 16:54   Re: [HACKERS] Number of pages in a random sample Manfred Koizar
• 17:01   Re: planner/optimizer question Manfred Koizar
• 17:11   Re: Simply join in PostrgeSQL takes too long Manfred Koizar
• 17:37   Re: Simply join in PostrgeSQL takes too long Rod Taylor
• 17:57   Re: Simply join in PostrgeSQL takes too long Manfred Koizar
• 18:13   Re: planner/optimizer question Gary Doades
• 18:21   Re: Wierd context-switching issue on Xeon Josh Berkus
• 19:13   Re: planner/optimizer question Rod Taylor
• 19:23   Re: planner/optimizer question Gary Doades
• 20:14   Re: planner/optimizer question Rosser Schwarz
• 20:26   Re: planner/optimizer question Gary Doades
• 21:07   Re: planner/optimizer question Josh Berkus
• 21:08   Re: planner/optimizer question Gary Doades
• 21:09   Re: Simply join in PostrgeSQL takes too long Vitaly Belman
• 21:27   Re: planner/optimizer question Gary Doades
• 21:55   Re: planner/optimizer question Tom Lane
• 22:13   Re: Simply join in PostrgeSQL takes too long Josh Berkus
• 22:32   Re: planner/optimizer question Gary Doades
• 23:01   Re: planner/optimizer question Gary Doades
• 23:15   analyzer/planner and clustered rows Joseph Shraibman
• 23:15   Insert only tables and vacuum performance Joseph Shraibman
• 23:18   Re: planner/optimizer question Tom Lane
• 23:45   Re: Insert only tables and vacuum performance Joseph Shraibman
• 23:45   why can't 2 indexes be used at once? Joseph Shraibman

30 April 2004

• 00:45   Re: Insert only tables and vacuum performance Rod Taylor
• 00:53   Re: Insert only tables and vacuum performance Joseph Shraibman
• 03:58   Re: why can't 2 indexes be used at once? Tom Lane
• 04:30   Re: Insert only tables and vacuum performance Tom Lane
• 05:27   Re: planner/optimizer question Dennis Bjorklund
• 05:58   Re: Insert only tables and vacuum performance Joseph Shraibman
• 06:34   Re: planner/optimizer question Gary Doades
• 07:01   Re: planner/optimizer question Gary Doades
• 07:31   Re: analyzer/planner and clustered rows Manfred Koizar
• 12:32   Re: planner/optimizer question Jeff
• 17:46   Re: planner/optimizer question Jochem van Dieten
• 18:29   Re: planner/optimizer question Gary Doades
• 18:59   Re: planner/optimizer question Gary Doades
• 19:49   Re: planner/optimizer question Kris Jurka
• 21:34   Re: planner/optimizer question Manfred Koizar