Mailing lists [pgsql-performance]

1 February 2003

• 00:10   Re: not using index for select min(...) Bruno Wolff III
• 02:10   Re: not using index for select min(...) Sean Chittenden
• 17:42   Re: not using index for select min(...) Josh Berkus

2 February 2003

• 01:03   Re: One large v. many small Curt Sampson
• 08:41   Re: One large v. many small Bruce Momjian
• 09:00   Re: Postgres 7.3.1 poor insert/update/search performance Bruce Momjian
• 15:01   Re: Postgres 7.3.1 poor insert/update/search performance Neil Conway
• 15:16   Re: Postgres 7.3.1 poor insert/update/search performance Curt Sampson
• 16:09   Re: 1 char in the world alien
• 17:32   Re: Postgres 7.3.1 poor insert/update/search performance Josh Berkus
• 22:41   Re: Postgres 7.3.1 poor insert/update/search performance Bruce Momjian

4 February 2003

• 10:15   SELECT DISTINCT is picky about constants Andreas Pflug
• 12:53   Re: SELECT DISTINCT is picky about constants Rod Taylor
• 13:16   subscribe 
• 13:16   EXPLAIN not helpful for DELETE Andreas Pflug

5 February 2003

• 08:51   how to configure my new server philip johnson
• 14:16   Postgres and SAN performance? Keith Bottner
• 15:59   Re: Postgres and SAN performance? Josh Berkus

6 February 2003

• 14:22   Re: how to configure my new server philip johnson
• 15:05   Re: how to configure my new server Josh Berkus
• 16:14   Re: how to configure my new server philip johnson
• 20:33   Re: how to configure my new server Andreas Pflug
• 21:11   Re: how to configure my new server Josh Berkus
• 21:19   Re: how to configure my new server eric soroos
• 23:01   Re: how to configure my new server Seth Robertson
• 23:17   Re: how to configure my new server Seth Robertson
• 23:27   Re: how to configure my new server eric soroos
• 23:39   Re: how to configure my new server Curt Sampson

7 February 2003

• 01:07   Re: how to configure my new server eric soroos
• 01:23   Re: how to configure my new server Andreas Pflug
• 02:34   Re: how to configure my new server Curt Sampson
• 06:33   Performance jeandre@itvs.co.za
• 06:46   Re: Performance Shridhar Daithankar
• 08:22   postgres on solaris 8 Christian Toepp
• 08:59   Re: postgres on solaris 8 Justin Clift
• 12:55   Re: Performance Tom Lane
• 13:10   Re: Performance jeandre@itvs.co.za
• 13:14   Re: Performance Tom Lane
• 13:47   Re: Performance jeandre@itvs.co.za
• 14:22   Re: how to configure my new server scott.marlowe
• 14:46   Re: how to configure my new server Peter Darley
• 15:17   Re: how to configure my new server Josh Berkus
• 15:21   Re: Performance Josh Berkus
• 15:42   Re: how to configure my new server scott.marlowe
• 16:07   Re: how to configure my new server eric soroos
• 16:42   Re: how to configure my new server Andreas Pflug
• 19:13   Re: how to configure my new server scott.marlowe
• 21:21   Re: how to configure my new server Andreas Pflug

10 February 2003

• 09:15   Re: how to configure my new server philip johnson
• 15:36   Re: how to configure my new server Josh Berkus
• 15:59   Re: how to configure my new server philip johnson

11 February 2003

• 10:27   ... jeandre@itvs.co.za
• 11:29   Re: Andrew Sullivan

12 February 2003

• 03:52   Re: how to configure my new server Bruce Momjian
• 09:52   Re: how to configure my new server Justin Clift

13 February 2003

• 03:16   More benchmarking of wal_buffers Christopher Kings-Lynne
• 03:36   Re: [HACKERS] More benchmarking of wal_buffers Bruce Momjian
• 04:29   Re: [HACKERS] More benchmarking of wal_buffers Neil Conway
• 06:32   JBoss CMP Performance Problems with PostgreSQL 7.2.3 Darryl A. J. Staflund
• 07:20   Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Rafal Kedziorski
• 09:00   Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 pginfo
• 16:06   cost and actual time Chantal Ackermann
• 18:08   Re: cost and actual time Josh Berkus
• 21:19   Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Nick Pavlica

14 February 2003

• 00:29   Re: [HACKERS] More benchmarking of wal_buffers Tom Lane
• 01:04   Re: [HACKERS] More benchmarking of wal_buffers Christopher Kings-Lynne
• 01:04   Re: [HACKERS] More benchmarking of wal_buffers Christopher Kings-Lynne
• 01:10   Re: [HACKERS] More benchmarking of wal_buffers Tom Lane
• 01:15   Re: [HACKERS] More benchmarking of wal_buffers Christopher Kings-Lynne
• 01:46   Re: [HACKERS] More benchmarking of wal_buffers Kevin Brown
• 01:55   Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Darryl A. J. Staflund
• 02:16   Re: [HACKERS] More benchmarking of wal_buffers Tom Lane
• 02:19   Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Tom Lane
• 02:21   Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Josh Berkus
• 02:23   Re: [HACKERS] More benchmarking of wal_buffers Tom Lane
• 03:31   Tuning scenarios (was Changing the default configuration) Kevin Brown
• 04:04   Re: Tuning scenarios (was Changing the default configuration) Tom Lane
• 09:48   Re: Tuning scenarios (was Changing the default configuration) Kevin Brown
• 10:35   Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Bruce Momjian
• 11:12   Re: [HACKERS] Terrible performance on wide selects Bruce Momjian
• 12:30   Re: WAL replay logic (was Re: Mount options for Ext3?) Bruce Momjian
• 13:05   Re: Tuning scenarios (was Changing the default configuration) Tom Lane
• 14:13   Re: Tuning scenarios (was Changing the default configuration) johnnnnnn
• 14:44   performace problem after VACUUM ANALYZE Scott Cain
• 15:00   Re: performace problem after VACUUM ANALYZE Tom Lane
• 15:29   Re: performace problem after VACUUM ANALYZE Scott Cain
• 15:37   Re: Tuning scenarios (was Changing the default configuration) Josh Berkus
• 16:10   Re: Tuning scenarios (was Changing the default configuration) Josh Berkus
• 17:22   Re: [Gmod-schema] Re: performace problem after VACUUM Scott Cain
• 18:02   Re: [Gmod-schema] Re: performace problem after VACUUM ANALYZE ShengQiang Shu
• 21:48   Re: performace problem after VACUUM ANALYZE Tom Lane
• 22:08   Re: [Gmod-schema] Re: performace problem after VACUUM ANALYZE SLetovsky@aol.com
• 22:11   Re: [Gmod-schema] Re: performace problem after VACUUM ANALYZE Tom Lane

15 February 2003

• 06:29   Re: [HACKERS] WAL replay logic (was Re: Mount options for Curt Sampson
• 06:36   Re: [HACKERS] More benchmarking of wal_buffers Curt Sampson
• 18:36   Re: [Gmod-schema] Re: performace problem after VACUUM Scott Cain
• 21:48   Views with unions Mariusz Czułada

16 February 2003

• 01:55   Re: Views with unions Josh Berkus
• 06:19   Re: Views with unions Mariusz Czułada
• 16:05   Re: Views with unions Stephan Szabo
• 16:51   Re: Views with unions Tom Lane
• 18:29   Re: Views with unions Mariusz Czułada
• 21:03   Good performance? Rafal Kedziorski

17 February 2003

• 02:44   Re: [JDBC] Good performance? Barry Lind
• 07:11   Re: [JDBC] Good performance? Rafal Kedziorski
• 08:52   Re: cost and actual time Chantal Ackermann
• 08:59   Re: [JDBC] Good performance? Tomasz Myrta
• 09:23   Re: [JDBC] Good performance? Rafal Kedziorski
• 10:26   Re: [JDBC] Good performance? Justin Clift
• 10:42   Re: [JDBC] Good performance? Rafal Kedziorski
• 14:22   Re: cost and actual time Tom Lane
• 14:49   Re: cost and actual time Manfred Koizar
• 15:50   Re: [JDBC] Good performance? Barry Lind
• 18:04   Re: [JDBC] Good performance? Josh Berkus

18 February 2003

• 03:16   Re: [HACKERS] WAL replay logic (was Re: Mount options for Bruce Momjian
• 08:29   Re: cost and actual time Chantal Ackermann
• 15:32   Re: cost and actual time Manfred Koizar
• 15:38   Re: Questions about indexes? Josh Berkus
• 17:48   Performance Baseline Script Keith Bottner
• 18:43   Re: Performance Baseline Script Josh Berkus
• 19:45   Data write speed Josh Berkus
• 20:22   Re: Data write speed Hannu Krosing
• 20:27   Re: Data write speed Kevin Brown
• 21:51   Re: Data write speed Josh Berkus
• 23:21   Re: Data write speed Justin Clift

19 February 2003

• 02:50   pgsql-hackers-owner, LIVE FROM WALL STREET: VICC Test Results Are In.......... incomingforward@cs.com
• 06:10   Re: Questions about indexes? Ryan Bradetich
• 07:39   Re: cost and actual time Chantal Ackermann
• 08:34   Re: cost and actual time Manfred Koizar
• 13:03   Re: Performance Baseline Script Tom Lane
• 13:14   Re: Performance Baseline Script Justin Clift
• 13:42   Re: Performance Baseline Script Andrew Sullivan
• 15:52   Re: Questions about indexes? Josh Berkus

20 February 2003

• 00:38   Re: Performance Baseline Script Justin Clift
• 04:19   Peluang Usaha yang Luar Biasa Ahmad Abdul Haq
• 06:42   Write ahead logging Matthias Meixner
• 07:19   Re: Write ahead logging Manfred Koizar
• 07:36   Re: Write ahead logging Mario Weilguni
• 08:01   Re: cost and actual time Manfred Koizar
• 08:06   Re: Peluang Usaha yang Luar Biasa Mike Nielsen
• 09:32   Re: Questions about indexes? Curt Sampson
• 21:01   Re: Tuning scenarios (was Changing the default configuration) Josh Berkus
• 21:44   Re: Tuning scenarios (was Changing the default Robert Treat
• 21:55   Re: Tuning scenarios (was Changing the default Andrew Sullivan

21 February 2003

• 05:45   performance issues for processing more then 150000 records / day. Jakab Laszlo
• 06:04   Re: performance issues for processing more then 150000 records / day. Christopher Kings-Lynne
• 06:37   Re: performance issues for processing more then 150000 records / day. Jakab Laszlo
• 06:45   Re: performance issues for processing more then 150000 records / day. Shridhar Daithankar
• 07:16   Re: performance issues for processing more then 150000 Justin Clift
• 07:54   Re: performance issues for processing more then 150000 Jakab Laszlo
• 08:32   Re: performance issues for processing more then 150000 Shridhar Daithankar
• 12:27   Re: Write ahead logging Matthias Meixner
• 13:34   Really bad insert performance: what did I do wrong? Kevin White
• 13:49   Re: Really bad insert performance: what did I do wrong? Kevin White
• 13:49   Re: Really bad insert performance: what did I do wrong? Tom Lane
• 13:53   Re: Really bad insert performance: what did I do wrong? Shridhar Daithankar
• 14:28   slow query Oleg Lebedev
• 14:59   Re: Really bad insert performance: what did I do wrong? Andrew Sullivan
• 15:22   Re: Really bad insert performance: what did I do wrong? Kevin White
• 15:52   Re: Really bad insert performance: what did I do wrong? Andrew Sullivan
• 16:09   Re: Really bad insert performance: what did I do wrong? scott.marlowe
• 17:25   Re: Really bad insert performance: what did I do wrong? Kevin White
• 17:51   Re: cost and actual time Christopher Kings-Lynne

22 February 2003

• 00:47   Re: slow query Tom Lane
• 00:50   Re: Really bad insert performance: what did I do wrong? Tom Lane
• 04:59   Re: Really bad insert performance: what did I do wrong? Tom Lane

23 February 2003

• 18:49   Re: performance issues for processing more then 150000 Josh Berkus
• 18:53   Re: slow query Josh Berkus
• 19:05   Re: slow query Ryan Bradetich
• 19:49   Re: slow query Josh Berkus

24 February 2003

• 00:46   Re: slow query Tom Lane
• 07:59   partitioning os swap data log tempdb Schaefer, Mario
• 08:31   Re: partitioning os swap data log tempdb Shridhar Daithankar
• 10:18   Re: partitioning os swap data log tempdb Andrew Sullivan
• 13:57   Re: slow query Oleg Lebedev
• 15:20   Re: slow query Robert Treat
• 15:26   Re: slow query Oleg Lebedev
• 15:58   Re: slow query Clarence Gardner
• 16:12   Re: slow query Oleg Lebedev
• 16:49   Re: partitioning os swap data log tempdb scott.marlowe
• 16:55   Memory taken by FSM_relations Josh Berkus
• 16:57   Re: slow query Robert Treat
• 17:08   Re: slow query Josh Berkus
• 17:08   Re: slow query Rod Taylor
• 17:14   Re: slow query Andrew Sullivan
• 17:23   Re: partitioning os swap data log tempdb Josh Berkus
• 17:30   Re: Memory taken by FSM_relations Joe Conway
• 17:54   Re: Memory taken by FSM_relations Josh Berkus
• 18:16   Re: Memory taken by FSM_relations Larry Rosenman
• 18:25   Re: Memory taken by FSM_relations scott.marlowe
• 18:43   Re: Memory taken by FSM_relations Josh Berkus
• 19:04   Re: slow query Robert Treat
• 19:33   Re: Memory taken by FSM_relations Tom Lane
• 21:22   Re: slow query Tom Lane

25 February 2003

• 05:56   Superfluous merge/sort Anuradha Ratnaweera
• 08:40   Query not using the index Mark Halliwell
• 10:59   Re: Query not using the index Andrew Sullivan
• 11:49   Re: Query not using the index Bruno Wolff III
• 13:21   Re: Query not using the index Tom Lane
• 13:40   Re: slow query Robert Treat
• 14:10   Re: Superfluous merge/sort Stephan Szabo
• 14:19   Re: slow query Tom Lane
• 14:50   Re: slow query Peter Childs
• 21:06   Faster 'select count(*) from table' ? Matt Mello
• 21:50   Re: Faster 'select count(*) from table' ? scott.marlowe

26 February 2003

• 02:57   Re: Superfluous merge/sort Anuradha Ratnaweera
• 03:40   Re: Superfluous merge/sort Stephan Szabo
• 04:27   Index File growing big. PRAGATI SAVAIKAR
• 05:32   Re: Index File growing big. Rajesh Kumar Mallah
• 10:09   Re: Index File growing big. Andrew Sullivan
• 11:04    daniel alvarez
• 12:02   Re: OIDs as keys Richard Huxton
• 12:59   Re: OIDs as keys daniel alvarez
• 14:01   Re: OIDs as keys Tom Lane
• 14:10   Re: OIDs as keys Tom Lane
• 14:14   Re: OIDs as keys Richard Huxton
• 15:24   Re: OIDs as keys Josh Berkus
• 23:19   Re: Index File growing big. Christopher Kings-Lynne

27 February 2003

• 01:59   Re: OIDs as keys Christopher Kings-Lynne
• 04:47   Re: OIDs as keys Tom Lane
• 04:57   Re: Index File growing big. Tom Lane
• 04:59   Re: OIDs as keys Christopher Kings-Lynne
• 05:09   Re: OIDs as keys Tom Lane
• 05:42   Re: OIDs as keys Tom Lane
• 07:03   Re: Index File growing big. Christopher Kings-Lynne
• 10:19   Daily crash Catalin
• 10:23   Re: Daily crash Shridhar Daithankar
• 10:41   Re: Index File growing big. Jim Buttafuoco
• 10:53   Re: Daily crash Catalin
• 11:04   Re: Daily crash Shridhar Daithankar
• 11:16   Re: Daily crash Bruno Wolff III
• 11:22   tsearch performance Chantal Ackermann
• 12:43   Re: [Performance] Daily Crash Aspire Something
• 12:54   Re: [Performance] Daily Crash Catalin
• 15:22   Re: [Performance] Daily Crash Josh Berkus
• 15:27   Re: Data write speed Josh Berkus
• 16:32   Re: Data write speed scott.marlowe
• 17:27   Re: [Performance] Daily Crash philip johnson
• 18:44   Re: [Performance] Daily Crash Catalin

28 February 2003

• 01:10   Re: OIDs as keys Ron Mayer
• 11:41   ... Jeandre du Toit
• 12:30   Re: [Performance] Daily Crash Catalin
• 22:35   Re: OIDs as keys Christopher Kings-Lynne
• 22:36   Re: OIDs as keys Christopher Kings-Lynne