Mailing lists [pgsql-performance]

1 August 2005

• 04:05   Re: Performance problems testing with Spamassassin 3.1.0 Michael Parker
• 04:42   Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane
• 04:54   Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane
• 16:34   Re: [PATCHES] COPY FROM performance improvements Tom Lane
• 17:09   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 19:48   Re: [PATCHES] COPY FROM performance improvements Alon Goldshuv
• 20:04   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 21:18   Re: Performance problems testing with Spamassassin 3.1.0 PFC
• 21:28   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 21:50   Re: Performance problems testing with Spamassassin 3.1.0 Jim C. Nasby
• 22:09   Re: Performance problems testing with Spamassassin 3.1.0 Michael Parker
• 22:19   Planner incorrectly choosing seq scan over index scan Meetesh Karia
• 22:37   Re: Planner incorrectly choosing seq scan over index scan Tobias Brox
• 23:16   Re: Planner incorrectly choosing seq scan over index scan John Arbash Meinel
• 23:30   Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia
• 23:56   Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia

2 August 2005

• 00:15   Re: Planner incorrectly choosing seq scan over index scan Tom Lane
• 07:06   Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia
• 15:03   Re: [PATCHES] COPY FROM performance improvements Alon Goldshuv
• 16:05   "nice"/low priority Query Tobias Brox
• 16:19   Re: "nice"/low priority Query Tom Lane
• 17:00   Re: "nice"/low priority Query Richard Huxton
• 17:25   Re: "nice"/low priority Query Jim C. Nasby
• 18:57   pg_dump for table with bytea takes a long time Sailer, Denis (YBUSA-CDR)
• 19:59   Re: "nice"/low priority Query Tobias Brox

3 August 2005

• 09:02   Re: "nice"/low priority Query Richard Huxton
• 12:48   Re: Planner incorrectly choosing seq scan over index scan Meetesh Karia
• 13:12   Is There A Windows Version of Performance Tuning Documents? Lane Van Ingen
• 15:08   Re: Is There A Windows Version of Performance Tuning Documents? John A Meinel

4 August 2005

• 08:14   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 08:24   Indexed views. prasanna s
• 08:34   Re: Indexed views. Christopher Kings-Lynne
• 08:45   Re: Performance problems testing with Spamassassin 3.1.0 PFC
• 08:52   Re: Indexed views. Laszlo Hornyak
• 14:10   Re: Performance problems testing with Spamassassin 3.1.0 John A Meinel
• 14:37   Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane
• 15:08   Re: Performance problems testing with Spamassassin 3.1.0 John A Meinel
• 16:16   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 16:16   Re: Performance problems testing with Spamassassin 3.1.0 Tom Lane
• 16:32   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 17:34   Re: "nice"/low priority Query Neil Conway
• 17:36   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 19:36   Re: Performance problems testing with Spamassassin 3.1.0 John A Meinel
• 22:38   Re: Performance problems testing with Spamassassin 3.1.0 Matthew Schumacher
• 22:43   Re: Performance problems testing with Spamassassin 3.1.0 John A Meinel

5 August 2005

• 11:11   Performance problems on 4-way AMD Opteron 875 (dual core) Dirk Lutzebäck
• 12:27   Re: Performance problems on 4-way AMD Opteron 875 (dual core) Michael Stone
• 12:56   Re: Performance problems on 4-way AMD Opteron 875 (dual Dirk Lutzebäck
• 13:53   Re: Performance problems on 4-way AMD Opteron 875 (dual core) Tom Lane
• 18:35   Why hash join instead of nested loop? Rhett Garber
• 22:13   Re: Why hash join instead of nested loop? Havasvölgyi Ottó
• 23:17   Re: Why hash join instead of nested loop? Rhett Garber

6 August 2005

• 05:04   Re: Why hash join instead of nested loop? Tom Lane
• 13:16   Slow update statement Patrick Hatcher
• 13:34   Re: Slow update statement John A Meinel
• 14:12   Re: Slow update statement Tom Lane

8 August 2005

• 02:01   Re: Slow update statement Patrick Hatcher
• 02:09   Re: Slow update statement Patrick Hatcher
• 03:48   Re: Slow update statement Tom Lane
• 04:38   Re: Slow update statement Patrick Hatcher
• 12:05   Re: Finding bottleneck Kari Lavikka
• 14:39   Re: Finding bottleneck Tom Lane
• 15:19   Re: Slow update statement Tom Lane
• 15:24   Re: Finding bottleneck Merlin Moncure
• 15:37   Re: Finding bottleneck Tom Lane
• 16:21   Re: Finding bottleneck Kari Lavikka
• 16:56   Re: Finding bottleneck Tom Lane
• 17:00   Re: Why hash join instead of nested loop? Rhett Garber
• 17:56   Re: Finding bottleneck Kari Lavikka
• 19:27   Re: Finding bottleneck Tom Lane

9 August 2005

• 00:58   Re: Why hash join instead of nested loop? Tom Lane
• 01:09   Re: Why hash join instead of nested loop? Steinar H. Gunderson
• 04:33   Re: QRY seems not using indexes Qingqing Zhou
• 05:05   Re: QRY seems not using indexes Mark Kirkwood
• 05:12   Re: Why hash join instead of nested loop? Michael Fuhr
• 12:16   Re: Why hash join instead of nested loop? Ian Westmacott
• 14:36   Re: Why hash join instead of nested loop? Tom Lane
• 14:50   Re: Why hash join instead of nested loop? Ian Westmacott
• 16:51   Re: Why hash join instead of nested loop? Rhett Garber
• 17:13   Re: Why hash join instead of nested loop? Tom Lane
• 18:02   Table locking problems? Dan Harris
• 18:10   Re: Why hash join instead of nested loop? Rhett Garber
• 18:31   Re: Table locking problems? Joshua D. Drake
• 18:38   Re: Why hash join instead of nested loop? Tom Lane
• 18:52   Re: Why hash join instead of nested loop? Rhett Garber
• 18:54   Re: Table locking problems? Michael Fuhr
• 19:02   Re: Why hash join instead of nested loop? Tom Lane
• 19:13   Re: Why hash join instead of nested loop? Rhett Garber
• 19:14   Re: Table locking problems? Steve Poe
• 19:38   Re: Table locking problems? Tom Lane
• 20:43   Re: Table locking problems? Dan Harris
• 21:33   Re: Table locking problems? Dan Harris
• 21:52   Re: Table locking problems? John A Meinel
• 22:03   Re: Table locking problems? Dan Harris
• 22:30   Re: Table locking problems? John A Meinel

10 August 2005

• 17:53   partial index regarded more expensive Tobias Brox
• 18:15   Re: partial index regarded more expensive PFC
• 18:32   Re: partial index regarded more expensive Tobias Brox
• 21:04   Re: Planner doesn't look at LIMIT? Ian Westmacott
• 22:55   Re: Planner doesn't look at LIMIT? Tom Lane
• 23:35   Speedier count(*) Dan Harris

11 August 2005

• 00:23   Re: Speedier count(*) Joshua D. Drake
• 00:36   Re: Speedier count(*) Michael Fuhr
• 01:07   Re: Speedier count(*) John A Meinel
• 03:15   Re: partial index regarded more expensive Tom Lane
• 03:38   it is always delete temp table will slow down the postmaster? Chun Yit(Chronos)
• 03:52   Re: Speedier count(*) Gavin Sherry
• 04:40   Re: Speedier count(*) Mark Cotner
• 06:39   Re: it is always delete temp table will slow down the postmaster? Qingqing Zhou
• 07:03   Re: it is always delete temp table will slow down the postmaster? Chun Yit(Chronos)
• 07:24   Re: Speedier count(*) Tino Wildenhain
• 10:37   Re: Speedier count(*) Gavin Sherry
• 10:52   Re: Speedier count(*) Tino Wildenhain
• 11:33   Why is not using the index Luis Cornide Arce
• 12:08   Re: Speedier count(*) PFC
• 12:23   PG8 Tuning Paul Johnson
• 12:34   Re: Speedier count(*) Tino Wildenhain
• 13:01   Re: PG8 Tuning Richard Huxton
• 13:01   Re: Why is not using the index Richard Huxton
• 13:19   [SPAM?] Re: PG8 Tuning Steve Poe
• 13:26   Re: Planner doesn't look at LIMIT? Ian Westmacott
• 13:59   Re: Why is not using the index Luis Cornide Arce
• 15:02   Re: PG8 Tuning Michael Stone
• 15:28   BG writer question? Alan Stange
• 15:59   Re: Speedier count(*) Dan Harris
• 16:43   Re: BG writer question? Alvaro Herrera
• 17:04   Re: [SPAM?] Re: PG8 Tuning Jeffrey W. Baker
• 18:21   Re: [SPAM?] Re: PG8 Tuning Tom Arthurs
• 19:04   Re: PG8 Tuning Mark Lewis
• 20:36   Odd Locking Problem John A Meinel
• 20:39   Re: PG8 Tuning Merlin Moncure
• 21:08   Re: Odd Locking Problem Alvaro Herrera
• 21:14   Re: Odd Locking Problem John A Meinel
• 22:21   Mostly read performance Jeffrey Tenny
• 22:39   Re: Mostly read performance John A Meinel
• 23:13   Re: Mostly read performance Jeffrey Tenny
• 23:30   Re: Odd Locking Problem John A Meinel
• 23:54   Re: PG8 Tuning Michael Stone

12 August 2005

• 00:34   Re: Mostly read performance Michael Stone
• 07:32   Re: Mostly read performance Greg Stark
• 12:18   Re: [SPAM?] Re: PG8 Tuning Jeff Trout
• 22:54   Re: Mostly read performance (2 replies) Jeffrey Tenny

14 August 2005

• 22:52   How many views is ok? Petr Kavan
• 22:55   Re: [Fwd: PG8 Tuning] Jignesh Shah
• 22:56   Performance pb vs SQLServer. Stéphane COEZ

15 August 2005

• 00:22   Re: How many views is ok? John Arbash Meinel
• 00:27   Re: Performance pb vs SQLServer. John Arbash Meinel
• 00:38   Re: How many views is ok? Tom Lane
• 01:02   Re: Performance pb vs SQLServer. Steinar H. Gunderson
• 01:04   Re: Performance pb vs SQLServer. Steinar H. Gunderson
• 01:06   Re: Performance pb vs SQLServer. John Arbash Meinel
• 01:18   Re: Performance pb vs SQLServer. Tom Lane
• 01:37   Re: Performance pb vs SQLServer. Steinar H. Gunderson
• 04:54   Re: Performance pb vs SQLServer. dario_d_s@unitech.com.ar
• 05:23   Re: How many views is ok? Petr Kavan
• 08:18   Re: Performance pb vs SQLServer. Magnus Hagander
• 08:25   Re: Performance pb vs SQLServer. Magnus Hagander
• 15:25   Re: Odd Locking Problem Manfred Koizar
• 16:22   Re: Performance pb vs SQLServer. Alvaro Herrera
• 16:29   Re: I'm configuraing a new system (Bigish) and need some advice. Jeremiah Jahn
• 20:35   choosing RAID level for xlogs Anjan Dave

16 August 2005

• 07:01   database encoding with index search problem wisan watcharinporn
• 07:29   Looking for a large database for testing Sebastian Hennebrueder
• 08:08   Re: Looking for a large database for testing Tino Wildenhain
• 08:24   Re: Looking for a large database for testing Sebastian Hennebrueder
• 08:25   Re: database encoding with index search problem Richard Huxton
• 08:39   Re: Looking for a large database for testing Mark Rae
• 09:38   Re: Looking for a large database for testing Oleg Bartunov
• 15:37   Need for speed Ulrich Wisser
• 15:59   Re. : Need for speed bsimon@loxane.com
• 16:05   Re: Need for speed Richard Huxton
• 16:11   Re: [SPAM?] Re: PG8 Tuning Josh Berkus
• 16:13   Re: Need for speed John A Meinel
• 16:25   Re: [SPAM?] Re: PG8 Tuning Alvaro Herrera
• 16:30   Re: [SPAM?] Re: PG8 Tuning Joshua D. Drake
• 16:46   Re: Need for speed Jeffrey W. Baker
• 16:46   Re: PG8 Tuning John A Meinel
• 17:38   Re: [SPAM?] Re: PG8 Tuning Michael Stone
• 17:59   Re: Need for speed Alex Turner
• 18:00   Re: choosing RAID level for xlogs mudfoot@rawbw.com
• 18:38   Re: choosing RAID level for xlogs Anjan Dave
• 18:48   Re: Need for speed Dennis Bjorklund
• 19:04   Re: choosing RAID level for xlogs John A Meinel
• 19:04   Re: choosing RAID level for xlogs Vivek Khera
• 19:16   Re: choosing RAID level for xlogs John A Meinel
• 19:21   Re: choosing RAID level for xlogs Alex Turner
• 19:52   Re: choosing RAID level for xlogs Alex Turner
• 22:04   Re: Looking for a large database for testing Sebastian Hennebrueder
• 22:42   Re: choosing RAID level for xlogs Gregory S. Williamson
• 22:52   Re: PG8 Tuning Tom Lane
• 23:22   Re: PG8 Tuning John A Meinel

17 August 2005

• 01:12   Re: choosing RAID level for xlogs Anjan Dave
• 02:28   Re: PG8 Tuning Tom Lane
• 03:15   Re: choosing RAID level for xlogs Alex Turner
• 04:42   Performance problem using V3 protocol in jdbc driver Barry Lind
• 04:49   Re: Finding bottleneck Ron
• 05:01   Re: [JDBC] Performance problem using V3 protocol in jdbc driver Tom Lane
• 05:43   Re: [JDBC] Performance problem using V3 protocol in jdbc driver Barry Lind
• 08:16   Re: Performance problem using V3 protocol in jdbc driver mudfoot@rawbw.com
• 09:13   Re: Need for speed Ulrich Wisser
• 09:48   Data Selection Slow From VB 6.0 Mahesh Shinde
• 10:29   Re: Data Selection Slow From VB 6.0 Chris Mair
• 13:00   Re: [JDBC] Performance problem using V3 protocol in jdbc driver Dave Cramer
• 14:52   Re: Need for speed Tom Lane
• 15:19   Re: Data Selection Slow From VB 6.0 John A Meinel
• 16:50   Re: Need for speed Jeffrey W. Baker
• 17:31   Re: Need for speed Josh Berkus
• 17:52   Re: Tuning Effective Cache Question Chris Hoover
• 17:53   Tuning Effective Cache Question Chris Hoover
• 18:37   Re: Need for speed Ron
• 19:42   Re: Need for speed Ron
• 21:09   bitmap scan issues 8.1 devel Merlin Moncure
• 21:25   Re: PG8 Tuning Josh Berkus
• 21:26   Re: Need for speed Matthew Nuzum
• 21:40   Re: Tuning Effective Cache Question Josh Berkus
• 21:57   Re: Insert performance (OT?) Manfred Koizar
• 22:35   Re: Insert performance (OT?) John A Meinel
• 22:46   Re: [HACKERS] bitmap scan issues 8.1 devel Tom Lane
• 23:09   Re: [HACKERS] bitmap scan issues 8.1 devel Josh Berkus

18 August 2005

• 02:02   limit number of concurrent callers to a stored proc? Alan Stange
• 02:11   extremly low memory usage Jeremiah Jahn
• 02:23   Re: extremly low memory usage John A Meinel
• 02:30   Re: limit number of concurrent callers to a stored proc? Gavin Sherry
• 02:32   Re: limit number of concurrent callers to a stored proc? Christopher Kings-Lynne
• 03:21   Re: limit number of concurrent callers to a stored Ron
• 08:59   Re: Performance pb vs SQLServer. Qingqing Zhou
• 13:00   Re: extremly low memory usage Jeff Trout
• 14:47   Re: Performance pb vs SQLServer. John A Meinel
• 15:01   FW: Tx forecast improving harware capabilities. Sebastian Lallana
• 16:29   Re: FW: Tx forecast improving harware capabilities. Josh Berkus
• 16:35   Re: extremly low memory usage Jeremiah Jahn
• 17:14   Re: extremly low memory usage John Arbash Meinel
• 17:39   Re: extremly low memory usage Jeremiah Jahn
• 17:55   Re: extremly low memory usage John Arbash Meinel
• 19:23   Re: limit number of concurrent callers to a stored proc? Merlin Moncure
• 19:57   Re: extremly low memory usage Ron
• 22:08   Re: FW: Tx forecast improving harware capabilities. David Hodgkinson

19 August 2005

• 04:33   Re: Performance pb vs SQLServer. Stéphane COEZ
• 04:33   Re: Performance pb vs SQLServer. Stéphane COEZ
• 04:34   Re: [JDBC] Data Selection Slow From VB 6.0 Oliver Jowett
• 04:34   Query plan looks OK, but slow I/O - settings advice? Roger Hand
• 04:34   Re: [JDBC] Performance problem using V3 protocol in jdbc driver Csaba Nagy
• 04:35   Re: Need for speed Roger Hand
• 04:37   Re: I'm configuraing a new system (Bigish) and need some advice. Jeremiah Jahn
• 04:37   Re: Performance pb vs SQLServer. Stéphane COEZ
• 04:37   I'm configuraing a new system (Bigish) and need some advice. Jeremiah Jahn
• 06:56   Re: Query plan looks OK, but slow I/O - settings advice? Jeffrey W. Baker
• 07:18   Re: Query plan looks OK, but slow I/O - settings advice? Gavin Sherry
• 07:35   Re: Query plan looks OK, but slow I/O - settings advice? Roger Hand
• 08:24   sustained update load of 1-2k/sec Mark Cotner
• 09:09   Re: sustained update load of 1-2k/sec Bob Ippolito
• 10:15   Re: sustained update load of 1-2k/sec Mark Cotner
• 11:28   Re: sustained update load of 1-2k/sec Bob Ippolito
• 11:36   Re: Finding bottleneck Kari Lavikka
• 12:41   Re: sustained update load of 1-2k/sec Alex Turner
• 12:50   Re: Need for speed Christopher Browne
• 13:06   Re: Finding bottleneck Tom Lane
• 13:37   Re: sustained update load of 1-2k/sec Tom Lane
• 13:37   Re: Finding bottleneck Merlin Moncure
• 13:58   Re: sustained update load of 1-2k/sec Andreas Pflug
• 14:03   Re: Finding bottleneck Tom Lane
• 14:09   Re: sustained update load of 1-2k/sec Tom Lane
• 14:55   Re: sustained update load of 1-2k/sec Ron
• 15:04   Re: sustained update load of 1-2k/sec Ron
• 15:27   Re: I'm configuraing a new system (Bigish) and need some Jeremiah Jahn
• 15:27   LEFT JOIN ON vs. LEFT JOIN USING performance Diego de Lima
• 15:44   Re: LEFT JOIN ON vs. LEFT JOIN USING performance John A Meinel
• 15:44   Re: LEFT JOIN ON vs. LEFT JOIN USING performance Tom Lane
• 16:34   Re: sustained update load of 1-2k/sec Jeffrey W. Baker
• 16:48   Re: extremly low memory usage Jeremiah Jahn
• 17:12   Re: sustained update load of 1-2k/sec J. Andrew Rogers
• 17:24   Re: Finding bottleneck Merlin Moncure
• 17:24   Re: extremly low memory usage John A Meinel
• 17:58   Re: sustained update load of 1-2k/sec Ron
• 18:12   Re: sustained update load of 1-2k/sec PFC
• 18:43   Re: extremly low memory usage Ron
• 19:23   Re: extremly low memory usage John A Meinel
• 19:32   Re: sustained update load of 1-2k/sec Alex Turner
• 19:57   Re: extremly low memory usage Jeremiah Jahn
• 20:11   Re: extremly low memory usage Jeremiah Jahn
• 21:06   Re: extremly low memory usage Jeremiah Jahn
• 21:06   Re: extremly low memory usage John A Meinel
• 21:12   Re: extremly low memory usage John A Meinel
• 21:21   Re: sustained update load of 1-2k/sec Ron
• 23:02   Re: sustained update load of 1-2k/sec Mark Cotner

20 August 2005

• 06:52   Re: Query plan looks OK, but slow I/O - settings advice? Dan Harris
• 07:12   Re: extremly low memory usage Dan Harris
• 11:18   Re: extremly low memory usage Marko Ristola
• 12:15   Re: Query plan looks OK, but slow I/O - settings advice? Michael Stone
• 12:18   Re: extremly low memory usage Michael Stone
• 12:18   index as large as table ohp@pyrenet.fr
• 12:23   Re: extremly low memory usage Michael Stone
• 13:08   Re: index as large as table Gavin Sherry
• 14:41   Re: extremly low memory usage Tom Lane
• 15:11   Re: index as large as table Steinar H. Gunderson
• 15:59   Re: extremly low memory usage Ron
• 18:16   Re: extremly low memory usage Jeremiah Jahn
• 18:31   Re: extremly low memory usage Jeremiah Jahn
• 18:53   Re: extremly low memory usage Jeremiah Jahn
• 21:02   Re: extremly low memory usage Ron
• 21:13   Re: extremly low memory usage Ron
• 21:25   Re: extremly low memory usage Ron

21 August 2005

• 02:29   Re: extremly low memory usage John A Meinel
• 02:36   Re: extremly low memory usage John A Meinel
• 03:49   complex query performance assistance request John Mendenhall
• 09:52   Re: extremly low memory usage Marko Ristola
• 15:01   Re: extremly low memory usage Jeremiah Jahn
• 15:56   Re: extremly low memory usage John A Meinel
• 18:32   (Re)-indexing on updates Yves Vindevogel
• 19:36   Fwd: (Re)-indexing on updates Yves Vindevogel
• 20:00   Fwd: (Re)-indexing on updates Yves Vindevogel
• 20:37   Re: (Re)-indexing on updates Jeffrey W. Baker
• 22:59   Re: extremly low memory usage Ron
• 23:37   Re: extremly low memory usage Ron

22 August 2005

• 09:11   Re: (Re)-indexing on updates Yves Vindevogel
• 09:29   Re: sustained update load of 1-2k/sec Mark Cotner
• 13:28   Re: Finding bottleneck Merlin Moncure
• 14:06   MemoryContextSwitchTo during table scan? Jignesh Shah
• 14:50   Re: Finding bottleneck Tom Lane
• 15:33   Re: extremly low memory usage William Yu
• 16:18   Re: extremly low memory usage Jeremiah Jahn
• 17:26   Re: MemoryContextSwitchTo during table scan? Tom Lane
• 18:03   Re: MemoryContextSwitchTo during table scan? Luke Lonergan
• 18:19   Re: Finding bottleneck Merlin Moncure
• 18:58   Re: complex query performance assistance request John Mendenhall
• 19:11   Re: MemoryContextSwitchTo during table scan? Josh Berkus
• 21:13   Re: complex query performance assistance request Tom Lane
• 21:55   Re: complex query performance assistance request John Mendenhall
• 22:37   Re: MemoryContextSwitchTo during table scan? Jignesh Shah

23 August 2005

• 00:10   Re: MemoryContextSwitchTo during table scan? Neil Conway
• 00:43   Re: Looking for a large database for testing Jim C. Nasby
• 00:48   Re: Need for speed Jim C. Nasby
• 00:54   Re: complex query performance assistance request Tom Lane
• 01:19   pgbench Philip Pinkerton
• 03:13   unused item pointers? Alan Stange
• 04:42   Re: unused item pointers? Tom Lane
• 05:00   Re: pgbench Josh Berkus
• 05:14   Re: unused item pointers? Jeffrey W. Baker
• 09:48   Re: extremly low memory usage John A Meinel
• 13:52   Re: pgbench Thomas F. O'Connell
• 14:50   fake condition causes far better plan Szűcs Gábor
• 15:18   Re: fake condition causes far better plan Tom Lane
• 16:16   Re: Performance for relative large DB Chris Browne
• 17:10   Caching by Postgres gokulnathbabu manoharan
• 17:26   Re: Caching by Postgres John A Meinel
• 17:41   Re: Caching by Postgres Bruno Wolff III
• 17:43   Re: Caching by Postgres Frank Wiles
• 17:54   Re: Caching by Postgres Josh Berkus
• 18:50   Re: Caching by Postgres Donald Courtney
• 19:05   Re: complex query performance assistance request John Mendenhall
• 19:23   Re: Caching by Postgres Tom Lane
• 19:34   Re: Caching by Postgres Josh Berkus
• 20:18   Re: Caching by Postgres mark@mark.mielke.cc
• 20:37   Re: Caching by Postgres Michael Stone
• 20:42   Re: Caching by Postgres Chris Browne
• 21:19   Re: Caching by Postgres Chris Browne
• 21:34   Re: Read/Write block sizes (Was: Caching by Postgres) Jignesh Shah
• 22:00   Re: Caching by Postgres William Yu
• 23:04   Re: Read/Write block sizes Chris Browne
• 23:18   Re: Read/Write block sizes (Was: Caching by Postgres) Michael Stone
• 23:24   Re: Read/Write block sizes Michael Stone
• 23:29   Re: Caching by Postgres PFC
• 23:36   Re: Read/Write block sizes Jim C. Nasby
• 23:40   Re: Read/Write block sizes Steve Poe
• 23:44   Re: Read/Write block sizes (Was: Caching by Postgres) Jeffrey W. Baker

24 August 2005

• 02:11   Re: Caching by Postgres Josh Berkus
• 02:26   Re: Read/Write block sizes Jignesh K. Shah
• 02:31   Re: Read/Write block sizes Josh Berkus
• 04:22   Re: Read/Write block sizes Alan Stange
• 04:38   Re: Caching by Postgres Gavin Sherry
• 04:44   Re: Read/Write block sizes Jeffrey W. Baker
• 05:07   Re: Caching by Postgres Tom Lane
• 05:13   Re: Read/Write block sizes Tom Lane
• 05:20   Re: Read/Write block sizes Guy Thornley
• 05:24   Re: Caching by Postgres Gavin Sherry
• 05:24   Re: Read/Write block sizes Jeffrey W. Baker
• 05:57   Re: Read/Write block sizes Tom Lane
• 06:22   Re: Read/Write block sizes Jeffrey W. Baker
• 10:35   Re: Read/Write block sizes PFC
• 13:27   Re: Caching by Postgres Donald Courtney
• 13:52   Re: Read/Write block sizes Bruce Momjian
• 15:32   Re: Caching by Postgres Stephen Frost
• 15:37   performance drop on RAID5 Alexandre Barros
• 15:54   Re: performance drop on RAID5 Frank Wiles
• 16:18   Re: Caching by Postgres PFC
• 16:32   Re: performance drop on RAID5 Arjen van der Meijden
• 16:43   Re: Read/Write block sizes Chris Browne
• 16:43   Re: Performance for relative large DB Chris Browne
• 16:47   Re: performance drop on RAID5 Rosser Schwarz
• 16:50   Re: Read/Write block sizes Josh Berkus
• 16:54   Re: performance drop on RAID5 Joshua D. Drake
• 17:04   Re: performance drop on RAID5 Merlin Moncure
• 17:36   Some ideas for comment Chris Hoover
• 18:04   Re: Caching by Postgres mark@mark.mielke.cc
• 19:06   Re: Caching by Postgres William Yu
• 19:17   Re: Some ideas for comment Merlin Moncure
• 19:25   Re: Caching by Postgres Alan Stange
• 19:51   Re: Some ideas for comment Alvaro Herrera
• 20:03   Re: Some ideas for comment Tom Lane
• 20:08   Re: Caching by Postgres mark@mark.mielke.cc
• 20:52   Performance indexing of a simple query Mark Fox
• 21:14   Re: Some ideas for comment Chris Hoover
• 21:19   Re: Read/Write block sizes Jignesh Shah
• 21:28   Re: Read/Write block sizes Lance Obermeyer
• 21:37   Re: Caching by Postgres PFC
• 22:21   Re: Performance indexing of a simple query Jim C. Nasby
• 22:45   Re: Caching by Postgres Alan Stange
• 22:49   Re: Caching by Postgres Michael Stone
• 22:57   Re: Read/Write block sizes Jim C. Nasby

25 August 2005

• 00:30   Re: Caching by Postgres mark@mark.mielke.cc
• 00:31   RAID arrays (and vendors) Jim C. Nasby
• 00:31   Re: Performance indexing of a simple query Tom Lane
• 01:35   Re: Caching by Postgres mark@mark.mielke.cc
• 07:08   Need for speed 2 Ulrich Wisser
• 07:18   Re: Some ideas for comment Jens-Wolfhard Schicke
• 13:46   Re: Need for speed 2 Frank Wiles
• 15:16   Re: Need for speed 2 Ron
• 17:30   Re: Need for speed 2 Merlin Moncure
• 19:00   Re: Need for speed 2 Kelly Burkhart
• 19:13   What *_mem to increase when running CLUSTER Andrew Lazarus
• 19:28   Re: What *_mem to increase when running CLUSTER Steve Poe
• 19:42   Re: Read/Write block sizes Josh Berkus
• 20:19   Re: What *_mem to increase when running CLUSTER Tom Lane
• 20:26   Re: Read/Write block sizes Ron
• 20:49   Re: Read/Write block sizes Chris Browne
• 23:47   Re: Read/Write block sizes Ron

26 August 2005

• 00:27   Limit + group + join Tobias Brox
• 01:56   Re: Limit + group + join Jeffrey W. Baker
• 02:07   Re: Limit + group + join Tobias Brox
• 02:33   Re: Limit + group + join Jeffrey W. Baker
• 03:44   Re: Limit + group + join Mark Kirkwood
• 06:08   postmaster memory keep going up???? Chun Yit(Chronos)
• 06:21   Re: Limit + group + join Tobias Brox
• 08:35   Re: postmaster memory keep going up???? Richard Huxton
• 11:09   Inefficient queryplan for query with intersectable subselects/joins Arjen van der Meijden
• 13:10   Re: Inefficient queryplan for query with intersectable Richard Huxton
• 14:18   Re: Limit + group + join Stephan Szabo
• 14:49   difference in plan between 8.0 and 8.1? Alan Stange
• 15:03   Re: Limit + group + join Merlin Moncure
• 15:40   Re: difference in plan between 8.0 and 8.1? Tom Lane
• 15:41   Re: difference in plan between 8.0 and 8.1? Michael Fuhr
• 15:43   Sending a select to multiple servers. Ligesh
• 15:46   Re: difference in plan between 8.0 and 8.1? Merlin Moncure
• 15:49   Re: Limit + group + join Tom Lane
• 16:06   Re: Sending a select to multiple servers. Frank Wiles
• 16:12   Re: Sending a select to multiple servers. Merlin Moncure
• 16:28   Re: Performance indexing of a simple query Jim C. Nasby
• 18:12   Re: Performance indexing of a simple query Tom Lane
• 18:58   OSX & Performance Jeff Trout
• 19:02   Re: difference in plan between 8.0 and 8.1? Alan Stange
• 20:15   How does the planner execute unions? Chris Hoover
• 20:46   Re: How does the planner execute unions? Bruno Wolff III
• 21:19   Re: Inefficient queryplan for query with intersectable Arjen van der Meijden
• 22:04   Weird performance drop after VACUUM Ümit Öztosun
• 22:35   Re: Sending a select to multiple servers. Ligesh
• 22:50   Re: Sending a select to multiple servers. Ligesh
• 22:55   Re: Weird performance drop after VACUUM asif ali
• 23:07   Re: Inefficient queryplan for query with intersectable Tom Lane
• 23:15   Re: Weird performance drop after VACUUM Philip Hallstrom
• 23:28   Re: Weird performance drop after VACUUM Michael Fuhr
• 23:32   Re: Weird performance drop after VACUUM Tom Lane
• 23:33   Re: Limit + group + join Mark Kirkwood
• 23:48   Re: Limit + group + join Tom Lane

27 August 2005

• 00:10   Re: Weird performance drop after VACUUM asif ali
• 01:41   Re: Weird performance drop after VACUUM Michael Fuhr
• 02:55   Re: Limit + group + join Mark Kirkwood
• 03:03   Re: Limit + group + join Greg Stark
• 04:58   Re: Caching by Postgres Thomas Ganss
• 05:02   Performance for relative large DB tobbe
• 05:04   Need indexes on empty tables for good performance ? Lenard, Rohan (Rohan)
• 05:11   Re: Performance for relative large DB tobbe
• 06:20   Re: Need indexes on empty tables for good performance ? Bruno Wolff III
• 06:30   Re: Performance for relative large DB Chris Travers
• 09:31   Re: Weird performance drop after VACUUM Umit Oztosun
• 10:19   Re: Weird performance drop after VACUUM Steinar H. Gunderson
• 10:50   Re: Inefficient queryplan for query with intersectable Arjen van der Meijden
• 14:27   Re: Inefficient queryplan for query with intersectable Tom Lane
• 15:11   Re: Inefficient queryplan for query with Ron
• 15:26   Re: Weird performance drop after VACUUM Steinar H. Gunderson
• 15:40   Re: Weird performance drop after VACUUM Tom Lane
• 16:42   Re: Weird performance drop after VACUUM Tom Lane
• 22:18   Re: Limit + group + join Tom Lane

28 August 2005

• 00:49   Re: Limit + group + join Mark Kirkwood
• 01:43   Re: Limit + group + join Tobias Brox
• 14:44   Re: Inefficient queryplan for query with intersectable Arjen van der Meijden
• 20:00   Re: OSX & Performance Tom Lane
• 20:41   intarray is broken ? (8.1b1) Ilia Kantor
• 20:48   Bitmap scan when it is not needed Ilia Kantor
• 20:59   Planner improvement suggestion Ilia Kantor
• 21:25   Re: intarray is broken ? (8.1b1) Tom Lane
• 21:30   Re: Planner improvement suggestion Tom Lane
• 22:49   Re: Bitmap scan when it is not needed Tom Lane

29 August 2005

• 16:23   shared buffers Carlos Henrique Reimer
• 17:27   Re: OSX & Performance Jeff Trout
• 17:57   Re: OSX & Performance Tom Lane
• 18:08   Re: Weird performance drop after VACUUM asif ali
• 18:42   Re: Limit + group + join Merlin Moncure
• 19:56   getting an index to work with partial indices ... Marc G. Fournier
• 20:16   Re: Need indexes on empty tables for good performance ? Thomas F. O'Connell
• 20:20   Re: getting an index to work with partial indices ... Tom Lane
• 20:29   Re: Weird performance drop after VACUUM Michael Fuhr
• 21:26   Re: Performance for relative large DB Jim C. Nasby
• 22:59   Re: Weird performance drop after VACUUM asif ali

30 August 2005

• 01:26   Re: shared buffers Christopher Kings-Lynne
• 01:54   Re: shared buffers Carlos Henrique Reimer
• 02:07   Re: shared buffers Christopher Kings-Lynne
• 02:16   Re: shared buffers Tom Lane
• 04:53   How to improve Postgres performance Hemant Pandey
• 06:04   Re: How to improve Postgres performance Dennis Bjorklund
• 07:05   Re: shared buffers William Yu
• 12:37   RAID Configuration Sugestion Alvaro Nunes Melo
• 12:58   Re: RAID Configuration Sugestion Bruno Wolff III
• 13:05   Observation about db response time Akshay Mathur
• 13:15   Re: Observation about db response time Frank Wiles
• 13:50   Re: RAID Configuration Sugestion Bruno Wolff III
• 14:04   Re: OSX & Performance Jeff Trout
• 14:46   Re: RAID Configuration Sugestion Ron
• 14:53   Re: Observation about db response time Vivek Khera
• 16:03   Re: Need indexes on empty tables for good performance ? Chris Travers
• 16:03   High load and iowait but no disk access Rémy Beaumont
• 16:04   Observation about db response time 
• 16:11   Re: RAID Configuration Sugestion Matthew Nuzum
• 16:12   Re: Need indexes on empty tables for good performance ? Lenard, Rohan (Rohan)
• 16:21   Re: High load and iowait but no disk access Rémy Beaumont
• 16:26   Re: High load and iowait but no disk access Michael Stone
• 16:29   Re: High load and iowait but no disk access Tom Lane
• 16:31   Re: High load and iowait but no disk access Tom Lane
• 16:42   Re: High load and iowait but no disk access Rémy Beaumont
• 16:56   Re: RAID Configuration Sugestion Joshua D. Drake
• 17:43   Re: Need indexes on empty tables for good performance ? Chris Travers
• 18:20   Re: RAID Configuration Sugestion Ron
• 18:29   Re: High load and iowait but no disk access Josh Berkus
• 18:30   Re: High load and iowait but no disk access Woody Woodring
• 18:44   Re: High load and iowait but no disk access Rémy Beaumont
• 18:49   Re: Observation about db response time george young
• 18:54   Re: High load and iowait but no disk access Rémy Beaumont
• 18:54   Re: RAID Configuration Sugestion Matthew Nuzum
• 18:58   Re: High load and iowait but no disk access Anjan Dave
• 19:27   Re: RAID Configuration Sugestion Joshua D. Drake
• 19:42   Re: High load and iowait but no disk access mudfoot@rawbw.com
• 21:14   When to do a vacuum for highly active table Markus Benne
• 21:30   Re: When to do a vacuum for highly active table Tom Lane
• 22:15   Re: When to do a vacuum for highly active table mark@mark.mielke.cc
• 22:19   'Real' auto vacuum? Ralph Mason
• 22:45   Re: 'Real' auto vacuum? mark@mark.mielke.cc
• 22:55   Re: 'Real' auto vacuum? Josh Berkus
• 23:02   Re: RAID Configuration Sugestion Ron
• 23:04   Re: When to do a vacuum for highly active table Chris Browne
• 23:05   Re: When to do a vacuum for highly active table Tom Lane
• 23:37   Re: 'Real' auto vacuum? Ralph Mason

31 August 2005

• 00:04   Re: RAID Configuration Sugestion Michael Stone
• 00:41   Re: RAID Configuration Sugestion Ron
• 00:43   Re: RAID Configuration Sugestion Michael Stone
• 02:51   Re: RAID Configuration Sugestion Ron
• 05:18   Re: 'Real' auto vacuum? Mindaugas Riauba
• 13:51   Re: 'Real' auto vacuum? Brad Nicholson
• 18:25   Swapping Carlos Henrique Reimer
• 18:49   Re: Swapping Tom Lane
• 19:17   Big question on insert performance/using COPY FROM Morgan Kita
• 19:28   Re: Swapping Tobias Brox
• 20:37   Re: Swapping Tobias Brox