Mailing lists [pgsql-performance]

1 October 2004

• 00:17   Re: Web server to Database Taking forever Scott Marlowe
• 02:11   Re: Caching of Queries Jim C. Nasby
• 09:46   Re: Caching of Queries Matt Clark
• 10:31   inconsistent/weird index usage Dustin Sallings
• 17:53   Re: inconsistent/weird index usage John Meinel
• 18:38   Re: inconsistent/weird index usage Tom Lane
• 18:43   Re: inconsistent/weird index usage Richard Huxton
• 19:13   Re: Caching of Queries Jim C. Nasby
• 19:47   Re: Caching of Queries Matt Clark
• 20:30   Re: inconsistent/weird index usage Josh Berkus
• 20:34   Re: inconsistent/weird index usage Tom Lane
• 20:49   Re: Caching of Queries Aaron Werman
• 21:11   Re: Caching of Queries Josh Berkus
• 22:26   Slow update/insert process Patrick Hatcher
• 23:49   Re: Slow update/insert process Aaron Werman

2 October 2004

• 07:15   Re: Caching of Queries Aaron Werman

3 October 2004

• 00:02   Re: Caching of Queries Josh Berkus
• 01:08   Re: Caching of Queries William Yu
• 02:02   Query planner problem Ryan VanMiddlesworth
• 02:49   Re: Caching of Queries Josh Berkus
• 02:52   Re: Query planner problem Russell Smith
• 03:21   Re: inconsistent/weird index usage Hannu Krosing
• 03:21   Re: Query planner problem Tom Lane
• 03:44   Re: inconsistent/weird index usage Tom Lane
• 17:18   Re: Caching of Queries Pierre-Frédéric Caillaud
• 17:25   Re: Caching of Queries Pierre-Frédéric Caillaud
• 17:27   Re: Caching of Queries Pierre-Frédéric Caillaud
• 19:26   Re: Caching of Queries Tatsuo Ishii
• 19:27   Re: index not used when using function Pierre-Frédéric Caillaud

4 October 2004

• 01:57   Re: Query planner problem Greg Stark
• 21:27   Re: Slow update/insert process Patrick Hatcher
• 21:33   Performance suggestions for an update-mostly database? Steve Atkins
• 21:39   Re: Performance suggestions for an update-mostly database? Josh Berkus
• 21:53   Re: Performance suggestions for an update-mostly database? Steve Atkins
• 23:00   Re: Performance suggestions for an update-mostly database? Josh Berkus
• 23:18   Re: Caching of Queries Jim C. Nasby
• 23:23   Re: Performance suggestions for an update-mostly database? Jim C. Nasby

5 October 2004

• 03:28   would number of fields in a table affect search-query time? Miles Keaton
• 03:32   Re: would number of fields in a table affect search-query time? Tom Lane
• 03:34   Re: would number of fields in a table affect search-query time? Steinar H. Gunderson
• 06:07   Re: would number of fields in a table affect search-query time? Josh Berkus
• 10:39   Re: Comparing user attributes with bitwise operators Patrick Clery
• 19:35   Re: Caching of Queries Matt Clark
• 20:22   Excessive context switching on SMP Xeons Bill Montgomery
• 20:33   Re: Comparing user attributes with bitwise operators Josh Berkus
• 20:48   Re: Excessive context switching on SMP Xeons Josh Berkus

6 October 2004

• 01:08   Re: Excessive context switching on SMP Xeons Bill Montgomery
• 01:08   Re: Excessive context switching on SMP Xeons Gaetano Mendola
• 02:37   Re: Excessive context switching on SMP Xeons Josh Berkus
• 02:56   slow rule on update Janning Vygen
• 04:42   Planner picks the wrong plan? Nichlas Löfdahl
• 07:24   test post Max Baker
• 07:30   Re: Planner picks the wrong plan? Tom Lane
• 08:50   Re: Excessive context switching on SMP Xeons Alan Stange
• 11:44   Re: Excessive context switching on SMP Xeons Greg Stark
• 13:29   sequential scan on select distinct Ole Langbehn
• 14:15   stats on cursor and query execution troubleshooting Alban Médici (NetCentrex)
• 14:16   Re: sequential scan on select distinct Pierre-Frédéric Caillaud
• 17:12   Re: Excessive context switching on SMP Xeons Alan Stange
• 18:16   Re: stats on cursor and query execution troubleshooting Tom Lane
• 19:45   Re: Excessive context switching on SMP Xeons Bill Montgomery
• 20:08   Re: sequential scan on select distinct Ole Langbehn
• 20:41   Re: sequential scan on select distinct Greg Stark
• 21:28   Re: Excessive context switching on SMP Xeons SZUCS Gábor
• 21:31   Re: sequential scan on select distinct Pierre-Frédéric Caillaud
• 22:55   Re: Comparing user attributes with bitwise operators Patrick Clery
• 23:28   Re: Comparing user attributes with bitwise operators Patrick Clery
• 23:40   Re: Comparing user attributes with bitwise operators Greg Stark
• 23:40   Re: sequential scan on select distinct Tom Lane

7 October 2004

• 00:02   Re: sequential scan on select distinct Greg Stark
• 00:05   The never ending quest for clarity on shared_buffers Doug Y
• 00:20   Re: sequential scan on select distinct Tom Lane
• 01:36   Data warehousing requirements Gabriele Bartolini
• 02:28   Re: The never ending quest for clarity on shared_buffers Paul Ramsey
• 03:56   Re: Excessive context switching on SMP Xeons Gaetano Mendola
• 05:07   Re: Caching of Queries Tatsuo Ishii
• 05:30   Re: The never ending quest for clarity on shared_buffers Neil Conway
• 08:14   Re: Excessive context switching on SMP Xeons Alan Stange
• 09:47   Re: Caching of Queries Tom Lane
• 11:46   Re: Caching of Queries Tatsuo Ishii
• 15:43   Re: Data warehousing requirements Aaron Werman
• 16:00   Re: sequential scan on select distinct Pierre-Frédéric Caillaud
• 19:35   Re: sequential scan on select distinct Tom Lane
• 19:48   Re: Excessive context switching on SMP Xeons Bill Montgomery
• 21:08   Re: sequential scan on select distinct Greg Stark
• 21:11   Re: Data warehousing requirements Gabriele Bartolini
• 21:19   Re: sequential scan on select distinct Ole Langbehn
• 21:26   Re: sequential scan on select distinct Tom Lane
• 22:15   Re: Excessive context switching on SMP Xeons Michael Adler
• 22:29   Re: Excessive context switching on SMP Xeons Alan Stange
• 22:48   Re: Excessive context switching on SMP Xeons Bill Montgomery

8 October 2004

• 02:48   Re: Data warehousing requirements Josh Berkus
• 06:03   Re: Data warehousing requirements Aaron Werman
• 06:43   Re: Data warehousing requirements Tom Lane
• 09:54   Re: Data warehousing requirements Josh Berkus
• 12:48   Re: stats on cursor and query execution troubleshooting Alban Médici (NetCentrex)
• 12:51   Re: sequential scan on select distinct Pierre-Frédéric Caillaud
• 13:11   integer[] indexing. Dawid Kuroczko
• 13:26   Re: integer[] indexing. Pierre-Frédéric Caillaud
• 13:54   Re: sequential scan on select distinct Pierre-Frédéric Caillaud
• 16:29   Re: integer[] indexing. Harald Fuchs
• 16:38   Re: Re: Data warehousing requirements 
• 17:56   Re: [pgsql-benchmarks] stats on cursor and query execution troubleshooting Tom Lane
• 18:03   Re: integer[] indexing. Tom Lane
• 18:23   Re: Re: Re: Data warehousing requirements  Tom Lane
• 18:47   Query Tuning Pallav Kalva
• 20:43   Re: Query Tuning Tom Lane
• 21:28   Re: Query Tuning Pallav Kalva
• 23:32   Odd planner choice? Gary Doades
• 23:46   Re: Odd planner choice? Gary Doades

9 October 2004

• 00:05   Re: Odd planner choice? Tom Lane
• 00:29   Re: Odd planner choice? Gary Doades
• 01:42   First set of OSDL Shared Mem scalability results, some wierdness ... Josh Berkus
• 02:13   Re: First set of OSDL Shared Mem scalability results, J. Andrew Rogers
• 02:21   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane
• 02:32   Re: First set of OSDL Shared Mem scalability results, Tom Lane
• 02:40   Re: First set of OSDL Shared Mem scalability results, Steinar H. Gunderson
• 03:07   Re: First set of OSDL Shared Mem scalability results, Josh Berkus
• 03:30   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Josh Berkus
• 07:20   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Christopher Browne
• 15:21   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown
• 19:05   Re: First set of OSDL Shared Mem scalability results, some Matthew
• 19:07   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane

10 October 2004

• 00:37   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown
• 01:01   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown
• 03:06   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane
• 13:20   kernel 2.6 synchronous directory Gaetano Mendola
• 13:50   Re: First set of OSDL Shared Mem scalability results, some wierdness Gaetano Mendola

11 October 2004

• 01:49   Re: First set of OSDL Shared Mem scalability results, some Dennis Bjorklund
• 13:54   Views, joins and LIMIT Dawid Kuroczko
• 16:02   COPY slows down? Mike Harding
• 16:03   EXPLAIN ANALYZE much slower than running query normally Chris Hutchinson
• 16:03   why my query is not using index?? HyunSung Jang
• 16:03   Re: sequential scan on select distinct Mischa Sandberg
• 16:16   Re: EXPLAIN ANALYZE much slower than running query normally Janning Vygen
• 16:25   Re: why my query is not using index?? Janning Vygen
• 18:14   Re: Views, joins and LIMIT Tom Lane
• 18:22   Re: COPY slows down? Tom Lane
• 18:26   Re: why my query is not using index?? Tom Lane
• 19:39   Re: [pgsql-benchmarks] stats on cursor and query execution Alban Médici (NetCentrex)
• 21:38   IBM P-series machines (was: Excessive context switching on SMP Xeons) Andrew Sullivan

12 October 2004

• 00:49   Re: why my query is not using index?? Francisco Reyes
• 01:03   Understanding explains Francisco Reyes
• 01:06   Normal case or bad query plan? Gabriele Bartolini
• 01:26   Re: why my query is not using index?? Janning Vygen
• 01:34   Re: Normal case or bad query plan? Tom Lane
• 02:03   Re: Understanding explains Rosser Schwarz
• 03:50   TestPerf Project started Josh Berkus
• 04:21   Re: why my query is not using index?? John Meinel
• 04:28   Re: IBM P-series machines (was: Excessive context Rod Taylor
• 04:28   Re: EXPLAIN ANALYZE much slower than running query normally Tom Lane
• 05:13   Re: why my query is not using index?? Greg Stark
• 05:48   Re: IBM P-series machines (was: Excessive context Christopher Browne
• 08:09   Re: Normal case or bad query plan? Kris Jurka
• 08:55   Re: why my query is not using index?? Francisco Reyes
• 08:59   Re: Understanding explains Francisco Reyes
• 09:26   Re: Normal case or bad query plan? Gabriele Bartolini
• 09:27   Re: why my query is not using index?? Tom Lane
• 09:46   Re: Normal case or bad query plan? Tom Lane
• 10:53   Re: IBM P-series machines Matt Clark
• 15:43   Re: execute cursor fetch my ho
• 16:21   Re: Normal case or bad query plan? Aaron Werman
• 16:36   Re: execute cursor fetch Pierre-Frédéric Caillaud
• 17:05   Re: execute cursor fetch Stef
• 18:08   Re: execute cursor fetch Tom Lane
• 18:29   Re: Normal case or bad query plan? Gabriele Bartolini
• 18:41   Re: Normal case or bad query plan? Steinar H. Gunderson
• 19:26   Which plattform do you recommend I run PostgreSQL for best performance? nd02tsk@student.hig.se
• 19:47   Re: Which plattform do you recommend I run PostgreSQL for Matt Clark
• 20:26   Re: Which plattform do you recommend I run PostgreSQL for Francisco Reyes

13 October 2004

• 00:30   Re: Which plattform do you recommend I run PostgreSQL for best performance? Josh Berkus
• 01:18   Re: Which plattform do you recommend I run PostgreSQL for best performance? Christopher Browne
• 05:03   Re: Caching of Queries Bruce Momjian
• 13:14   query problem Robin Ericsson
• 18:38   Re: query problem ken
• 19:03   Re: query problem Tom Lane
• 19:54   Re: query problem Robin Ericsson
• 20:09   Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Mulder
• 20:19   Opteron vs RHAT Chris Browne
• 20:23   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Bryan Encina
• 20:30   [Fwd: Re: [GENERAL] query problem] Robin Ericsson
• 20:47   Re: Opteron vs RHAT Matt Clark
• 22:57   futex results with dbt-3 Mark Wong

14 October 2004

• 00:12   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Glenn
• 02:34   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Josh Berkus
• 04:49   Re: First set of OSDL Shared Mem scalability results, some Jan Wieck
• 04:52   Re: First set of OSDL Shared Mem scalability results, some Jan Wieck
• 06:30   Re: futex results with dbt-3 Neil Conway
• 07:47   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Bruce Momjian
• 07:52   Re: First set of OSDL Shared Mem scalability results, some Greg Stark
• 08:17   Re: First set of OSDL Shared Mem scalability results, some Jan Wieck
• 08:22   Re: First set of OSDL Shared Mem scalability results, some Greg Stark
• 08:29   Re: First set of OSDL Shared Mem scalability results, some Jan Wieck
• 21:29   Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin Magnus Hagander
• 22:33   Performance vs Schemas Igor Maciel Macaubas
• 22:45   Re: Performance vs Schemas Gregory S. Williamson
• 23:59   Re: Excessive context switching on SMP Xeons Dave Cramer

15 October 2004

• 00:26   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown
• 00:57   View & Query Performance Igor Maciel Macaubas
• 02:18   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Simon Riggs
• 03:55   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Josh Berkus
• 04:09   Re: [Testperf-general] Re: First set of OSDL Shared Mem Timothy D. Witham
• 04:25   mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Aaron Werman
• 04:52   Re: Performance vs Schemas Neil Conway
• 05:08   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown
• 05:19   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Christopher Browne
• 05:41   Re: Performance vs Schemas Iain
• 09:13   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane
• 11:28   Re: View & Query Performance Alban Medici (NetCentrex)
• 11:37   Re: View & Query Performance Richard Huxton
• 11:37   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Simon Riggs
• 13:19   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Kevin Brown
• 14:25   Select with qualified join condition / Batch inserts Bernd
• 14:36   Re: Select with qualified join condition / Batch inserts Matt Clark
• 14:45   Re: Select with qualified join condition / Batch inserts Leeuw van der, Tim
• 16:53   Re: First set of OSDL Shared Mem scalability results, some Alan Stange
• 18:17   Re: Select with qualified join condition / Batch inserts Michael Nonemacher
• 19:37   Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin Tom Lane
• 20:07   Tuning shared_buffers with ipcs ? Doug Y
• 20:22   Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin Merlin Moncure
• 20:48   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
• 20:57   Does PostgreSQL run with Oracle? Richard_D_Levine@raytheon.com
• 20:58   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability Bruce Momjian
• 21:02   Re: Does PostgreSQL run with Oracle? Bruce Momjian
• 21:08   Re: Select with qualified join condition / Batch inserts Tom Lane
• 21:13   Re: Does PostgreSQL run with Oracle? Steve Atkins
• 21:51   Re: Tuning shared_buffers with ipcs ? Tom Lane
• 21:56   Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin Tom Lane
• 22:06   Re: Does PostgreSQL run with Oracle? Tom Lane
• 22:16   Re: Does PostgreSQL run with Oracle? Marc Slemko
• 22:51   Re: Tuning shared_buffers with ipcs ? Doug Y
• 23:24   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Simon Riggs
• 23:43   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Josh Berkus
• 23:45   Re: Does PostgreSQL run with Oracle? Mike Rylander
• 23:53   Re: Tuning shared_buffers with ipcs ? Tom Lane

16 October 2004

• 00:09   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Sean Chittenden
• 00:11   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Josh Berkus
• 00:16   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Sean Chittenden
• 00:34   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
• 00:36   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Josh Berkus
• 00:40   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Mark Wong
• 01:18   Re: Tuning shared_buffers with ipcs ? Doug Y
• 01:22   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane
• 01:27   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
• 01:32   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Mark Wong
• 01:38   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane
• 01:45   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Tom Lane
• 01:56   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Mark Wong
• 02:11   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Mark Wong
• 02:32   Re: execute cursor fetch Kris Jurka
• 05:22   Re: mmap (was First set of OSDL Shared Mem scalability results, Bruce Momjian
• 20:54   Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...) Tom Lane

17 October 2004

• 01:16   Re: Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...) Josh Berkus
• 01:19   Re: Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...) Tom Lane
• 01:35   Re: Getting rid of AtEOXact_Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...) Josh Berkus
• 23:42   Re: [HACKERS] Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...) 

18 October 2004

• 00:12   Re: Re: [HACKERS] Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...)  Tom Lane
• 04:50   Re: [HACKERS] Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Gaetano Mendola
• 12:50   Indexes performance charavay
• 19:28   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Mark Wong
• 22:01   Queries slow using stored procedures Rod Dutton
• 22:09   How to time several queries? nd02tsk@student.hig.se
• 22:13   Re: How to time several queries? Joshua D. Drake
• 22:44   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Jan Wieck
• 23:17   Re: First set of OSDL Shared Mem scalability results, some Jan Wieck
• 23:37   Re: First set of OSDL Shared Mem scalability results, some Jan Wieck
• 23:43   Re: Indexes performance Josh Berkus

19 October 2004

• 00:36   Re: [HACKERS] Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Jan Wieck
• 00:59   Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... Josh Berkus
• 01:03   Re: [HACKERS] Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...) Tom Lane
• 01:19   Autotuning of shared buffer size (was: Re: [HACKERS] Getting rid of AtEOXact Buffers (was Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...)) Jan Wieck
• 04:02   Re: Indexes performance Tom Lane
• 11:25   Re: Queries slow using stored procedures Alban Medici (NetCentrex)
• 19:15   Why isn't this index being used? Knutsen, Mark
• 19:28   Re: Why isn't this index being used? Doug Y
• 19:34   Re: Why isn't this index being used? Knutsen, Mark
• 19:38   Vacuum takes a really long time, vacuum full required Max Baker
• 19:44   Re: Vacuum takes a really long time, vacuum full required Rod Taylor
• 19:47   Re: Why isn't this index being used? Andrew Sullivan
• 20:21   Re: Vacuum takes a really long time, vacuum full required Tom Lane
• 20:27   Index not used in query. Why? Andrei Bintintan
• 20:53   Re: Index not used in query. Why? Tom Lane
• 22:12   Re: Vacuum takes a really long time, vacuum full required Max Baker
• 22:43   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Max Baker
• 23:35   Speeding up this function Matt Nuzum
• 23:49   Re: Speeding up this function Jeremy Dunn
• 23:55   Re: Speeding up this function Matt Nuzum

20 October 2004

• 01:03   Re: Normal case or bad query plan? Mischa Sandberg
• 01:03   Re: Which plattform do you recommend I run PostgreSQL for best CoL
• 01:03   Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com
• 01:03   Re: Performance vs Schemas Aaron Werman
• 01:03   Performance on Win32 vs Cygwin MikeSmialek2@Hotmail.com
• 01:04   Re: [pgsql-hackers-win32] Performance on Win32 vs Cygwin Reini Urban
• 01:15   Re: Select with qualified join condition / Batch inserts Gavin Sherry
• 01:22   Re: futex results with dbt-3 Manfred Spraul
• 01:52   Re: futex results with dbt-3 Tom Lane
• 01:57   Re: futex results with dbt-3 Josh Berkus
• 02:32   how much mem to give postgres? Josh Close
• 02:40   Re: futex results with dbt-3 Tom Lane
• 03:22   Re: Select with qualified join condition / Batch inserts Russell Smith
• 03:28   Re: Does PostgreSQL run with Oracle? Greg Sabino Mullane
• 04:07   Re: Speeding up this function Pierre-Frédéric Caillaud
• 04:33   Re: how much mem to give postgres? Simon Riggs
• 05:53   Insert performance, what should I expect? Brock Henry
• 06:12   Re: Insert performance, what should I expect? Matthew T. O'Connor
• 06:17   Re: Insert performance, what should I expect? Rod Taylor
• 08:02   Re: how much mem to give postgres? Josh Close
• 08:35   Re: how much mem to give postgres? Tom Lane
• 09:23   Re: how much mem to give postgres? Josh Berkus
• 11:51   Re: Insert performance, what should I expect? Andrew McMillan
• 15:12   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Werman
• 15:31   Re: How to time several queries? nd02tsk@student.hig.se
• 16:34   Re: Which plattform do you recommend I run PostgreSQL nd02tsk@student.hig.se
• 16:57   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Aaron Mulder
• 17:06   OS desicion Tom Fischer
• 17:23   Re: OS desicion Matt Clark
• 17:36   Re: how much mem to give postgres? Josh Close
• 17:40   Re: how much mem to give postgres? Josh Close
• 18:07   Re: how much mem to give postgres? Matt Clark
• 19:08   Re: Index not used in query. Why? Contact AR-SD.NET
• 19:08   Re: How to time several queries? Matthew Nuzum
• 20:14   Re: Index not used in query. Why? Thomas F.O'Connell
• 20:39   Re: OS desicion Josh Berkus
• 21:10   Re: futex results with dbt-3 Mark Wong
• 21:12   Re: Insert performance, what should I expect? Robert Creager
• 21:12   Re: OS desicion Matt Clark
• 21:15   Re: futex results with dbt-3 Tom Lane
• 21:21   Re: Insert performance, what should I expect? Rod Taylor
• 21:44   Re: how much mem to give postgres? Steve Atkins
• 22:16   Re: how much mem to give postgres? Matt Clark
• 22:32   Re: how much mem to give postgres? Steve Atkins

21 October 2004

• 02:06   Re: futex results with dbt-3 Mark Wong
• 04:27   Re: futex results with dbt-3 Dave Cramer
• 04:28   iostat question jelle
• 06:25   create index with substr function Ray
• 09:11   Re: create index with substr function Tom Lane
• 09:12   Re: create index with substr function Stephan Szabo
• 09:12   Re: create index with substr function Ray
• 09:44   Re: create index with substr function Rosser Schwarz
• 09:45   Re: create index with substr function Ray
• 10:19   Re: create index with substr function Joshua D. Drake
• 11:58   Anything to be gained from a 'Postgres Filesystem'? Matt Clark
• 12:24   Re: Free PostgreSQL Training, Philadelphia, Oct 30 Alban Medici (NetCentrex)
• 12:27   Re: Anything to be gained from a 'Postgres Filesystem'? Leeuw van der, Tim
• 12:32   Re: Anything to be gained from a 'Postgres Filesystem'? Pierre-Frédéric Caillaud
• 12:38   Re: Anything to be gained from a 'Postgres Filesystem'? Matt Clark
• 14:27   Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson
• 14:44   Re: Anything to be gained from a 'Postgres Filesystem'? Leeuw van der, Tim
• 15:47   Re: Anything to be gained from a 'Postgres Filesystem'? Aaron Werman
• 16:02   Re: Anything to be gained from a 'Postgres Filesystem'? Neil Conway
• 17:45   Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson
• 17:55   Re: futex results with dbt-3 Mark Wong
• 18:21   Re: Anything to be gained from a 'Postgres Filesystem'? Tom Lane
• 18:23   Re: create index with substr function george young
• 18:34   Simple machine-killing query! Victor Ciurus
• 19:02   Re: Anything to be gained from a 'Postgres Filesystem'? Jan Dittmer
• 19:06   Re: Simple machine-killing query! Stephan Szabo
• 19:14   Re: Simple machine-killing query! Aaron Werman
• 19:42   Re: Simple machine-killing query! Tom Lane
• 19:49   Re: Anything to be gained from a 'Postgres Filesystem'? Steinar H. Gunderson
• 21:03   Re: Simple machine-killing query! Victor Ciurus
• 21:15   Re: Simple machine-killing query! Josh Berkus
• 22:40   Re: Anything to be gained from a 'Postgres Filesystem'? Sean Chittenden

22 October 2004

• 00:26   Links to OSDL test results up Josh Berkus
• 00:29   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Sean Chittenden
• 00:36   Performance Anomalies in 7.4.5 Thomas F.O'Connell
• 00:50   Re: Performance Anomalies in 7.4.5 Thomas F.O'Connell
• 01:05   Re: Performance Anomalies in 7.4.5 Dennis Bjorklund
• 01:11   Re: Performance Anomalies in 7.4.5 Thomas F.O'Connell
• 01:53   Re: Performance Anomalies in 7.4.5 Tom Lane
• 02:11   Re: Does PostgreSQL run with Oracle? Jim C. Nasby
• 02:15   Re: OS desicion Jim C. Nasby
• 02:20   Re: Anything to be gained from a 'Postgres Filesystem'? Jim C. Nasby
• 02:21   Re: Performance Anomalies in 7.4.5 Gary Doades
• 07:15   Large Database Performance suggestions Joshua Marsh
• 07:30   Re: Large Database Performance suggestions Gavin Sherry
• 07:37   Re: Large Database Performance suggestions Tom Lane
• 08:13   Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane
• 09:01   Re: Large Database Performance suggestions Scott Marlowe
• 15:38   Re: Large Database Performance suggestions Dave Cramer
• 23:06   Slow query Roger Ging
• 23:40   Re: Performance Anomalies in 7.4.5 Andrew Sullivan

23 October 2004

• 00:37   Re: Slow query Tom Lane
• 01:13   Re: Performance Anomalies in 7.4.5 Matthew T. O'Connor
• 11:44   Re: First set of OSDL Shared Mem scalability results, some Curt Sampson
• 14:50   Re: Insert performance, what should I expect? Gaetano Mendola
• 15:15   Re: Insert performance, what should I expect? Steinar H. Gunderson
• 15:20   Re: futex results with dbt-3 Gaetano Mendola
• 16:07   Re: Slow query Joshua Marsh
• 22:10   Re: First set of OSDL Shared Mem scalability results, some wierdness ... Tom Lane
• 22:20   Re: futex results with dbt-3 Tom Lane
• 23:20   Re: futex results with dbt-3 Gaetano Mendola

24 October 2004

• 03:20   Re: futex results with dbt-3 Gaetano Mendola
• 09:08   Re: Vacuum takes a really long time, vacuum full required Max Baker
• 09:46   Re: First set of OSDL Shared Mem scalability results, some Curt Sampson
• 18:39   Re: First set of OSDL Shared Mem scalability results, some Tom Lane
• 22:12   Queries slow using stored procedures Rod Dutton
• 22:25   Re: Queries slow using stored procedures John Meinel
• 23:09   Re: Queries slow using stored procedures John Meinel
• 23:11   Re: Queries slow using stored procedures John Meinel
• 23:28   Sequential Scan with LIMIT John Meinel

25 October 2004

• 00:11   Re: Sequential Scan with LIMIT Tom Lane
• 01:51   Re: Sequential Scan with LIMIT John Meinel
• 01:59   Reindexdb and REINDEX Rod Dutton
• 04:16   Re: Reindexdb and REINDEX Tom Lane
• 04:30   Re: First set of OSDL Shared Mem scalability results, some Curt Sampson
• 05:18   Re: First set of OSDL Shared Mem scalability results, some Tom Lane
• 05:33   Re: First set of OSDL Shared Mem scalability results, some Curt Sampson
• 11:17   Re: Sequential Scan with LIMIT Curt Sampson
• 11:25   Re: Sequential Scan with LIMIT Neil Conway
• 17:51   Re: Performance Anomalies in 7.4.5 Andrew Sullivan
• 18:33   Re: Sequential Scan with LIMIT John Meinel
• 19:57   Re: futex results with dbt-3 Manfred Spraul
• 19:57   Re: futex results with dbt-3 Manfred Spraul
• 19:57   Re: futex results with dbt-3 Manfred Spraul
• 19:58   Re: futex results with dbt-3 Manfred Spraul
• 19:58   Re: Performance Anomalies in 7.4.5 Bricklen
• 19:58   Re: First set of OSDL Shared Mem scalability results, some Tom Lane
• 19:58   different io elevators in linux Bjorn Bength
• 19:58   Re: First set of OSDL Shared Mem scalability results, some Tom Lane
• 19:58   Re: futex results with dbt-3 Manfred Spraul
• 20:34   Re: futex results with dbt-3 Josh Berkus
• 20:45   Re: futex results with dbt-3 Tom Lane
• 21:07   Re: different io elevators in linux Josh Berkus
• 21:45   Re: futex results with dbt-3 Tom Lane

26 October 2004

• 00:53   can't handle large number of INSERT/UPDATEs Anjan Dave
• 01:20   Re: can't handle large number of INSERT/UPDATEs Rod Taylor
• 06:29   Re: can't handle large number of INSERT/UPDATEs Dustin Sallings
• 12:18   FW: can't handle large number of INSERT/UPDATEs Rod Dutton
• 15:37   Measuring server performance with psql and pgAdmin Joost Kraaijeveld
• 19:24   Re: Large Database Performance suggestions Joshua Marsh
• 20:39   Re: Large Database Performance suggestions Tom Lane
• 21:42   Re: can't handle large number of INSERT/UPDATEs Anjan Dave
• 21:49   Re: can't handle large number of INSERT/UPDATEs Rod Taylor
• 21:56   Re: can't handle large number of INSERT/UPDATEs Anjan Dave
• 22:25   Re: can't handle large number of INSERT/UPDATEs Josh Berkus
• 22:29   Re: can't handle large number of INSERT/UPDATEs Matt Clark
• 23:18   Re: Measuring server performance with psql and pgAdmin Josh Berkus

27 October 2004

• 00:19   Re: Sequential Scan with LIMIT Jaime Casanova
• 00:51   Re: can't handle large number of INSERT/UPDATEs Andrew McMillan
• 01:13   Re: can't handle large number of INSERT/UPDATEs Anjan Dave
• 01:15   Re: can't handle large number of INSERT/UPDATEs Anjan Dave
• 01:53   Re: can't handle large number of INSERT/UPDATEs Tom Lane
• 02:14   Re: can't handle large number of INSERT/UPDATEs Anjan Dave
• 02:21   Re: Sequential Scan with LIMIT John Meinel
• 02:37   Re: can't handle large number of INSERT/UPDATEs Tom Lane
• 02:46   Re: can't handle large number of INSERT/UPDATEs Anjan Dave
• 03:00   Re: can't handle large number of INSERT/UPDATEs Curtis Zinzilieta
• 04:09   Re: [PATCHES] [HACKERS] ARC Memory Usage analysis Thomas F.O'Connell
• 04:37   Re: [PATCHES] [HACKERS] ARC Memory Usage analysis Josh Berkus
• 04:40   Re: can't handle large number of INSERT/UPDATEs Josh Berkus
• 07:13   Re: can't handle large number of INSERT/UPDATEs Anjan Dave
• 07:21   Re: can't handle large number of INSERT/UPDATEs Tom Lane
• 08:18   Re: can't handle large number of INSERT/UPDATEs John Meinel
• 09:03   Re: can't handle large number of INSERT/UPDATEs Iain
• 10:09   Re: can't handle large number of INSERT/UPDATEs Matt Clark
• 15:24   Re: Free PostgreSQL Training, Philadelphia, Oct 30 D'Arcy J.M. Cain
• 21:16   Re: Sequential Scan with LIMIT Jaime Casanova

28 October 2004

• 01:41   Re: different io elevators in linux Mark Wong
• 12:01   Re: Performance Anomalies in 7.4.5 Alban Medici (NetCentrex)
• 19:27   Re: Sequential Scan with LIMIT John Meinel
• 19:38   Re: Summary: can't handle large number of INSERT/UPDATEs Anjan Dave
• 20:07   Re: Performance Anomalies in 7.4.5 Josh Berkus
• 20:31   Re: Performance Anomalies in 7.4.5 Tom Lane
• 21:21   Re: Performance Anomalies in 7.4.5 Rod Taylor
• 21:50   Re: Performance Anomalies in 7.4.5 Tom Lane

29 October 2004

• 03:47   Re: Sequential Scan with LIMIT Jim C. Nasby
• 03:49   Re: Sequential Scan with LIMIT Tom Lane
• 03:54   Re: Sequential Scan with LIMIT Jim C. Nasby
• 18:02   determining max_fsm_pages Patrick Hatcher
• 18:29   Re: determining max_fsm_pages Tatsuo Ishii
• 18:37   Re: determining max_fsm_pages Tom Lane

31 October 2004

• 01:13   Re: can't handle large number of INSERT/UPDATEs Markus Bertheau
• 08:24   Re: futex results with dbt-3 Manfred Spraul
• 08:42   psql large RSS (1.6GB) TTK Ciar
• 09:03   Re: psql large RSS (1.6GB) Dustin Sallings
• 13:27   Re: psql large RSS (1.6GB) Markus Bertheau
• 21:39   Thanks Chariot Solutions brew@theMode.com