pgsql-performance - February 2003

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Feb. 1, 2003

Thread Author Time
Re: not using index for select min(...) Bruno Wolff III 01:02
Re: [PERFORM] not using index for select min(...) Sean Chittenden 04:09
Re: [PERFORM] not using index for select min(...) Tom Lane 04:35
Re: One large v. many small Curt Sampson 05:07
Re: [PERFORM] not using index for select min(...) Sean Chittenden 05:09
Re: [PERFORM] not using index for select min(...) Kevin Brown 16:43
Re: [PERFORM] not using index for select min(...) Tom Lane 17:03
Re: not using index for select min(...) Josh Berkus 19:41
Re: [PERFORM] not using index for select min(...) Greg Stark 20:21

Feb. 2, 2003

Thread Author Time
Re: [PERFORM] not using index for select min(...) Bruno Wolff III 02:41
Re: One large v. many small Bruce Momjian 10:16
Re: Postgres 7.3.1 poor insert/update/search performance Bruce Momjian 10:39
Re: Postgres 7.3.1 poor insert/update/search performance Neil Conway 17:01
Re: Postgres 7.3.1 poor insert/update/search performance Curt Sampson 17:14
Re: 1 char in the world alien 18:09
Re: Postgres 7.3.1 poor insert/update/search performance Josh Berkus 19:31

Feb. 3, 2003

Thread Author Time
Re: Postgres 7.3.1 poor insert/update/search performance Bruce Momjian 00:41

Feb. 4, 2003

Thread Author Time
SELECT DISTINCT is picky about constants Andreas Pflug 12:15
Re: SELECT DISTINCT is picky about constants Rod Taylor 14:29
subscribe jeandre 14:48
EXPLAIN not helpful for DELETE Andreas Pflug 15:11

Feb. 5, 2003

Thread Author Time
how to configure my new server philip johnson 10:54
Postgres and SAN performance? Keith Bottner 16:16
Re: Postgres and SAN performance? Josh Berkus 18:01

Feb. 6, 2003

Thread Author Time
Re: how to configure my new server philip johnson 16:25
Re: how to configure my new server Josh Berkus 17:04
Re: how to configure my new server philip johnson 18:13
Re: how to configure my new server Andreas Pflug 21:43
Re: how to configure my new server Josh Berkus 22:56
Re: how to configure my new server eric soroos 23:14

Feb. 7, 2003

Thread Author Time
Re: how to configure my new server Seth Robertson 00:07
Re: how to configure my new server Seth Robertson 00:23
Re: how to configure my new server eric soroos 00:33
Re: how to configure my new server Curt Sampson 01:17
Re: how to configure my new server eric soroos 03:07
Re: how to configure my new server Andreas Pflug 03:23
Re: how to configure my new server Curt Sampson 04:34
Performance jeandre 08:11
Re: Performance Shridhar Daithankar 08:40
postgres on solaris 8 Christian Toepp 10:26
Re: postgres on solaris 8 Justin Clift 10:59
Re: Performance Tom Lane 14:55
Re: Performance jeandre 15:04
Re: Performance Tom Lane 15:13
Re: Performance jeandre 15:38
Re: how to configure my new server scott.marlowe 16:13
Re: how to configure my new server Peter Darley 16:47
Re: how to configure my new server Josh Berkus 17:16
Re: Performance Josh Berkus 17:20
Re: how to configure my new server scott.marlowe 17:33
Re: how to configure my new server eric soroos 18:06
Re: how to configure my new server Andreas Pflug 18:42
Re: how to configure my new server scott.marlowe 21:01
Re: how to configure my new server Andreas Pflug 23:21

Feb. 10, 2003

Thread Author Time
Re: how to configure my new server philip johnson 11:18
Re: how to configure my new server Josh Berkus 17:35
Re: how to configure my new server philip johnson 18:02

Feb. 11, 2003

Thread Author Time
[No subject] jeandre 11:10
Re: Andrew Sullivan 13:29
Re: [HACKERS] PostgreSQL Benchmarks Merlin Moncure 15:44
Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks) Tom Lane 16:20
Re: Changing the default configuration (was Re: Greg Copeland 16:42
Re: Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks) Patrick Welche 16:44
Re: Changing the default configuration (was Re: Jason Hihn 17:03
Re: Changing the default configuration (was Re: Justin Clift 17:08
Re: Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks) Steve Crawford 17:10
Re: Changing the default configuration (was Re: mlw 17:12
Re: Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks) Tom Lane 17:18
Re: Changing the default configuration (was Re: Josh Berkus 17:18
Re: Changing the default configuration (was Re: Rod Taylor 17:21
Re: [HACKERS] Changing the default configuration (was Re: mlw 17:23
Re: Changing the default configuration (was Re: Tom Lane 17:26
Re: Changing the default configuration (was Re: [pgsql-advocacy] Kaare Rasmussen 17:26
Re: Changing the default configuration (was Re: Justin Clift 17:29
Re: Changing the default configuration (was Re: Justin Clift 17:34
Re: [HACKERS] Changing the default configuration (was Re: Greg Copeland 17:36
Re: Changing the default configuration (was Re: [pgsql-advocacy] PostgreSQL Benchmarks) Jon Griffin 17:38
Re: Changing the default configuration (was Re: Josh Berkus 17:48
Re: Changing the default configuration (was Re: Tom Lane 17:52
Re: [HACKERS] Changing the default configuration (was Re: Tom Lane 17:54
Re: Changing the default configuration (was Re: [pgsql-advocacy] PostgreSQL Benchmarks) Tom Lane 18:01
Re: Changing the default configuration (was Re: [pgsql-advocacy] Robert Treat 18:03
Re: [HACKERS] Changing the default configuration (was Re: mlw 18:27
Re: Changing the default configuration (was Re: [pgsql-advocacy] scott.marlowe 18:34
Re: Changing the default configuration (was Re: [pgsql-advocacy] Matthew T. O'Connor 18:53
Re: Changing the default configuration (was Re: [pgsql-advocacy] Tom Lane 18:55
Re: Changing the default configuration (was Re: [pgsql-advocacy] PostgreSQL Benchmarks) Tom Lane 19:06
Re: Changing the default configuration (was Re: Greg Copeland 19:16
Re: Changing the default configuration (was Re: [pgsql-advocacy] Jeff Hoffmann 19:36
Re: Changing the default configuration (was Re: [pgsql-advocacy] scott.marlowe 19:54
Re: Changing the default configuration (was Re: scott.marlowe 20:10
Re: Changing the default configuration (was Re: Peter Eisentraut 21:13
Re: Changing the default configuration (was Re: [pgsql-advocacy] Lamar Owen 21:53

Feb. 12, 2003

Thread Author Time
Re: [HACKERS] Changing the default configuration (was Re: Rick Gigger 00:25
Re: Changing the default configuration (was Re: Curt Sampson 00:41
Re: [HACKERS] Changing the default configuration (was Re: scott.marlowe 00:42
Re: [HACKERS] Changing the default configuration (was Re: scott.marlowe 01:02
Re: [HACKERS] Changing the default configuration Tatsuo Ishii 01:10
Re: Changing the default configuration Tatsuo Ishii 01:10
Re: Changing the default configuration Tatsuo Ishii 01:10
Re: Changing the default configuration scott.marlowe 01:23
Re: [HACKERS] Changing the default configuration (was Re: Bruno Wolff III 01:37
Re: Changing the default configuration Tatsuo Ishii 02:00
Re: [HACKERS] PostgreSQL Benchmarks Christopher Kings-Lynne 02:42
Re: [HACKERS] Changing the default configuration (was Re: Christopher Kings-Lynne 02:47
Re: Changing the default configuration (was Re: Tom Lane 04:24
Re: [HACKERS] Changing the default configuration (was Re: Tom Lane 05:27
Re: [HACKERS] Changing the default configuration (was Re: Christopher Kings-Lynne 05:32
Re: [HACKERS] Changing the default configuration (was Re: Christopher Kings-Lynne 05:33
Re: how to configure my new server Bruce Momjian 05:52
Re: Changing the default configuration (was Re: [pgsql-advocacy] Shridhar Daithankar<shridhar_daithankar@persistent.co.in> 06:21
Re: how to configure my new server Justin Clift 11:51
Re: Changing the default configuration Robert Treat 16:36
Re: [HACKERS] Changing the default configuration (was Re: Andrew Sullivan 16:39
Re: Changing the default configuration Greg Copeland 16:43
Re: [HACKERS] Changing the default configuration (was Re: Rod Taylor 16:43
Re: Changing the default configuration Tom Lane 16:48
Re: Changing the default configuration (was Re: scott.marlowe 18:26
Re: Changing the default configuration scott.marlowe 18:30
Re: [HACKERS] Changing the default configuration (was Re: Peter Eisentraut 23:52

Feb. 13, 2003

Thread Author Time
Re: Changing the default configuration Christopher Kings-Lynne 01:43
Re: Changing the default configuration (was Re: Christopher Kings-Lynne 01:47
Re: Changing the default configuration (was Re: Larry Rosenman 01:51
Re: Changing the default configuration (was Re: Bruce Momjian 02:36
Re: [HACKERS] Changing the default configuration (was Re: Tom Lane 03:08
Re: Changing the default configuration (was Re: Tom Lane 03:18
Re: Changing the default configuration (was Re: Curt Sampson 04:32
Re: Changing the default configuration (was Re: Tom Lane 05:15
More benchmarking of wal_buffers 📎 Christopher Kings-Lynne 05:16
Re: [HACKERS] More benchmarking of wal_buffers Bruce Momjian 05:30
Re: [HACKERS] Changing the default configuration (was Re: Bruce Momjian 06:12
Re: [HACKERS] More benchmarking of wal_buffers Neil Conway 06:17
Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Rafal Kedziorski 09:22
Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 pginfo 10:01
Re: [HACKERS] Changing the default configuration (was Re: Tom Lane 15:06
Re: [HACKERS] Changing the default configuration (was Re: Bruce Momjian 17:10
cost and actual time Chantal Ackermann 18:06
Re: Changing the default configuration (was Re: Bruce Momjian 18:49
Re: cost and actual time Josh Berkus 20:08
Re: Changing the default configuration (was Re: Greg Stark 20:47
Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Nick Pavlica 23:19

Feb. 14, 2003

Thread Author Time
Re: [HACKERS] More benchmarking of wal_buffers Tom Lane 02:29
Re: [HACKERS] More benchmarking of wal_buffers Christopher Kings-Lynne 03:04
Re: [HACKERS] More benchmarking of wal_buffers Christopher Kings-Lynne 03:05
Re: [HACKERS] More benchmarking of wal_buffers Tom Lane 03:10
Re: [HACKERS] More benchmarking of wal_buffers Christopher Kings-Lynne 03:16
Re: Changing the default configuration (was Re: Kevin Brown 03:26
Re: [PERFORM] [HACKERS] More benchmarking of wal_buffers Kevin Brown 03:46
Re: [HACKERS] Changing the default configuration Josh Berkus 04:00
Re: [PERFORM] [HACKERS] More benchmarking of wal_buffers Tom Lane 04:14
Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Tom Lane 04:18
Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Josh Berkus 04:20
Re: [HACKERS] More benchmarking of wal_buffers Tom Lane 04:23
Re: [HACKERS] Changing the default configuration (was Re: Kevin Brown 05:06
Tuning scenarios (was Changing the default configuration) Kevin Brown 05:31
Re: Tuning scenarios (was Changing the default configuration) Tom Lane 06:04
Offering tuned config files 📎 Christopher Kings-Lynne 06:12
Re: Tuning scenarios (was Changing the default configuration) Kevin Brown 11:48
Re: Offering tuned config files Manfred Koizar 11:58
Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3 Bruce Momjian 12:35
Re: [HACKERS] Terrible performance on wide selects Bruce Momjian 13:11
Re: WAL replay logic (was Re: Mount options for Ext3?) Bruce Momjian 14:30
Re: Tuning scenarios (was Changing the default configuration) Tom Lane 15:05
Re: Offering tuned config files Tom Lane 15:07
Re: Tuning scenarios (was Changing the default configuration) johnnnnnn 16:33
performace problem after VACUUM ANALYZE Scott Cain 16:44
Re: performace problem after VACUUM ANALYZE Tom Lane 17:00
Re: performace problem after VACUUM ANALYZE Scott Cain 17:29
Re: Tuning scenarios (was Changing the default configuration) Josh Berkus 17:36
Re: Tuning scenarios (was Changing the default configuration) Josh Berkus 18:10
Re: [Gmod-schema] Re: performace problem after VACUUM ANALYZE SLetovsky 19:07
Re: [Gmod-schema] Re: performace problem after VACUUM Scott Cain 19:22
Re: [Gmod-schema] Re: performace problem after VACUUM ANALYZE ShengQiang Shu 21:04
Re: Changing the default configuration (was Re: [pgsql-advocacy] Tilo Schwarz 21:55
Re: performace problem after VACUUM ANALYZE Tom Lane 23:19

Feb. 15, 2003

Thread Author Time
Re: [Gmod-schema] Re: performace problem after VACUUM ANALYZE Tom Lane 00:11
Re: [HACKERS] WAL replay logic (was Re: Mount options for Curt Sampson 08:29
Re: [HACKERS] More benchmarking of wal_buffers Curt Sampson 08:36
Re: Offering tuned config files Christopher Kings-Lynne 14:15
Re: [Gmod-schema] Re: performace problem after VACUUM Scott Cain 20:36
Views with unions Mariusz Czułada 23:48

Feb. 16, 2003

Thread Author Time
Re: Views with unions Josh Berkus 03:54
Re: Views with unions Mariusz Czułada 08:19
Re: Views with unions Stephan Szabo 18:05
Re: Views with unions Tom Lane 18:51
Re: Views with unions Mariusz Czułada 20:27
Good performance? Rafal Kedziorski 23:03
Re: Good performance? John Cavacas 23:23

Feb. 17, 2003

Thread Author Time
Re: Good performance? Rafal Kedziorski 00:23
Re: Good performance? Barry Lind 04:45
Re: Good performance? Rafal Kedziorski 09:12
Re: cost and actual time Chantal Ackermann 10:51
Re: [PERFORM] Good performance? Tomasz Myrta 10:58
Re: [PERFORM] Good performance? Rafal Kedziorski 11:25
Re: [JDBC] Good performance? Justin Clift 12:27
Re: [PERFORM] Good performance? Rafal Kedziorski 12:43
Re: cost and actual time Tom Lane 16:21
Re: cost and actual time Manfred Koizar 16:49
Re: Good performance? Barry Lind 17:50
Re: [PERFORM] Good performance? Josh Berkus 20:03

Browse Archives

Prev | Next