pgsql-performance - October 2002

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

Oct. 1, 2002

Thread Author Time
Re: [pgsql-performance] Deletes from tables with foreign keys taking Stephan Szabo 18:27
Deletes from tables with foreign keys taking too long Adam Siegel 18:28
Re: [pgsql-performance] Deletes from tables with foreign keys taking too long Josh Berkus 21:44
Comparitive UPDATE speed Josh Berkus 21:51
Re: Comparitive UPDATE speed Josh Berkus 23:50

Oct. 2, 2002

Thread Author Time
Re: Comparitive UPDATE speed Ron Johnson 10:48

Oct. 3, 2002

Thread Author Time
Large databases, performance 📎 Shridhar Daithankar 12:36
Re: Large databases, performance Charles H. Woloszynski 12:54
Re: Large databases, performance Nigel J. Andrews 12:56
Re: Large databases, performance Shridhar Daithankar 14:03
Re: Large databases, performance Charles H. Woloszynski 14:26
Re: Large databases, performance Shridhar Daithankar 15:50
Re: Large databases, performance Shridhar Daithankar 15:56
Re: Large databases, performance Robert Treat 15:57
Re: Large databases, performance Shridhar Daithankar 16:07
Re: [HACKERS] Large databases, performance Justin Clift 16:16
Re: Large databases, performance Shridhar Daithankar 16:17
Re: [HACKERS] Large databases, performance Greg Copeland 16:23
Re: Large databases, performance Robert Treat 16:26
subscribe pgsql-performance Mike Benoit 16:29
Re: [HACKERS] Large databases, performance Shridhar Daithankar 16:30
Re: Large databases, performance Shridhar Daithankar 16:35
Re: Large databases, performance Manfred Koizar 16:44
Re: [HACKERS] Large databases, performance Hans-Jürgen Schönig 16:51
Re: [HACKERS] Large databases, performance Manfred Koizar 16:53
unsubscribe Hans-Jürgen Schönig 16:58
Re: Large databases, performance Ron Johnson 17:38
Re: [HACKERS] Large databases, performance Ron Johnson 20:55
Re: [HACKERS] Large databases, performance Andrew Sullivan 21:09
use [PERF] instead of Jean-Luc Lachance 21:12
Re: [GENERAL] Performance while loading data and indexing Mike Benoit 23:09
Re: [GENERAL] Performance while loading data and indexing Greg Copeland 23:35
Re: [GENERAL] Performance while loading data and indexing Bruce Momjian 23:59

Oct. 4, 2002

Thread Author Time
Re: [HACKERS] Large databases, performance Shridhar Daithankar 08:00
Re: Comparitive UPDATE speed Josh Berkus 15:54
Re: [HACKERS] Large databases, performance scott.marlowe 16:05
Re: [HACKERS] Large databases, performance Hans-Jürgen Schönig 16:30
Re: Large databases, performance Michael Paesold 16:38
Re: Comparitive UPDATE speed Andrew Sullivan 16:44
Pinning a table into memory David Blood 16:46
Re: Comparitive UPDATE speed Josh Berkus 18:13
Re: Comparitive UPDATE speed Andrew Sullivan 18:25
Re: Pinning a table into memory Tom Lane 18:47
Re: Comparitive UPDATE speed Josh Berkus 19:09
Re: Comparitive UPDATE speed Andrew Sullivan 19:24
Re: Comparitive UPDATE speed Tom Lane 19:41
Re: Comparitive UPDATE speed Tom Lane 19:45
Re: Comparitive UPDATE speed Josh Berkus 21:01

Oct. 6, 2002

Thread Author Time
Re: [HACKERS] Performance while loading data and indexing Curt Sampson 15:52

Oct. 7, 2002

Thread Author Time
Re: Large databases, performance Curt Sampson 02:27
Re: Large databases, performance Curt Sampson 02:30
cross-posts (was Re: Large databases, performance) Tom Lane 03:20
Re: Large databases, performance Shridhar Daithankar 09:37
Re: [pgsql-performance] Large databases, performance Hans-Jürgen Schönig 10:01
Re: [HACKERS] cross-posts (was Re: Large databases, Larry Rosenman 11:50
Re: [HACKERS] cross-posts (was Re: Large databases, Michael Paesold 12:01
Re: [HACKERS] cross-posts (was Re: Large databases, Larry Rosenman 12:04
Re: Large databases, performance Manfred Koizar 14:10
Re: Large databases, performance Shridhar Daithankar 14:18
Re: [pgsql-performance] Large databases, performance Tom Lane 14:30
Re: [pgsql-performance] Large databases, performance Shridhar Daithankar 14:39
Re: [pgsql-performance] Large databases, performance Tom Lane 15:21
Re: Large databases, performance Manfred Koizar 15:22
Re: [HACKERS] Large databases, performance Zeugswetter Andreas SB SD 15:42
sloooow query Marie G. Tuite 19:22
Re: sloooow query Josh Berkus 19:29
Re: sloooow query Justin Clift 19:30
Re: sloooow query Marie G. Tuite 19:49
Re: sloooow query Marie G. Tuite 19:53
Re: sloooow query Josh Berkus 20:12
Re: sloooow query Justin Clift 20:15
Re: sloooow query Marie G. Tuite 20:34
Re: sloooow query Josh Berkus 20:44
Re: sloooow query Robert Treat 20:50
Re: sloooow query Robert Treat 20:52
Re: sloooow query Tom Lane 20:57
Re: sloooow query Justin Clift 21:00
Re: sloooow query Marie G. Tuite 22:04
Re: sloooow query Marie G. Tuite 22:04
Re: sloooow query Marie G. Tuite 22:05
Re: sloooow query Marie G. Tuite 22:09
Re: sloooow query Marie G. Tuite 22:12

Oct. 8, 2002

Thread Author Time
Re: sloooow query Martijn van Oosterhout 00:03
Re: [pgsql-performance] Large databases, performance Shridhar Daithankar 05:44
Re: [pgsql-performance] Large databases, performance Martijn van Oosterhout 07:20
Re: Pinning a table into memory Jan Wieck 13:32
Re: [GENERAL] Large databases, performance Ron Johnson 13:50
Re: [GENERAL] Large databases, performance Tom Lane 14:38
Re: [GENERAL] Large databases, performance Shridhar Daithankar 14:41
Re: [GENERAL] Large databases, performance Ron Johnson 15:16
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus 15:33
Re: [GENERAL] Large databases, performance Tom Lane 15:51
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Ron Johnson 17:42
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus 22:44
Re: [HACKERS] Large databases, performance Martijn van Oosterhout 22:51
Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus 23:36

Oct. 9, 2002

Thread Author Time
What does this tell me? Josh Berkus 03:46
Re: What does this tell me? Bruce Momjian 03:49
Re: What does this tell me? Sean Chittenden 03:50
Re: What does this tell me? Bruce Momjian 03:55
Re: What does this tell me? Josh Berkus 04:01
Re: What does this tell me? Bruce Momjian 04:07
Re: What does this tell me? Sean Chittenden 04:17
Re: What does this tell me? Josh Berkus 04:33
Re: What does this tell me? Bruce Momjian 04:38
Re: What does this tell me? Joe Conway 04:55
Re: What does this tell me? Tom Lane 05:22
Re: What does this tell me? Josh Berkus 05:22
Re: Large databases, performance 📎 Manfred Koizar 08:00
Re: Large databases, performance Shridhar Daithankar 08:07
Re: Large databases, performance Shridhar Daithankar 08:25
Re: [pgsql-performance] Large databases, performance Tom Lane 13:32
Re: [pgsql-performance] Large databases, performance Shridhar Daithankar 13:41
Re: What does this tell me? Robert Treat 13:57
problem with the Index Jose Antonio Leo 16:56
Re: [SQL] problem with the Index Stephan Szabo 17:31
Re: [pgsql-performance] Large databases, performance Manfred Koizar 18:09
[No subject] Rich Scott 19:32

Oct. 10, 2002

Thread Author Time
contrib/fixchar (Was: Large databases, performance) Manfred Koizar 13:30
Re: contrib/fixchar (Was: Large databases, performance) Shridhar Daithankar 13:49
Info on explain output Adam Witney 15:41
Re: Info on explain output Bruce Momjian 16:44
Re: Info on explain output Josh Berkus 16:59

Oct. 11, 2002

Thread Author Time
number of attributes in page files? Mario Weilguni 07:14
Compile test with gcc 3.2 Mario Weilguni 08:44
Re: [HACKERS] number of attributes in page files? Tom Lane 12:12
Re: [HACKERS] number of attributes in page files? Mario Weilguni 14:00
Re: Compile test with gcc 3.2 Ludwig Lim 14:34
syncronize databases Waruna Geekiyanage 16:02
Re: Compile test with gcc 3.2 Vincent Janelle 19:24

Oct. 15, 2002

Thread Author Time
PG_Autotune 0.1 Josh Berkus 18:00

Oct. 17, 2002

Thread Author Time
Max time queries Chad Thompson 14:45

Oct. 18, 2002

Thread Author Time
Re: Max time queries Tom Lane 01:37

Oct. 21, 2002

Thread Author Time
Self-generating statistics? Mario Weilguni 06:23
Default cost variables in postgresql.conf Ludwig Lim 07:04
Re: Self-generating statistics? Neil Conway 07:34
Re: Self-generating statistics? Andrew Sullivan 13:00
Re: Default cost variables in postgresql.conf Andrew Sullivan 14:16

Oct. 22, 2002

Thread Author Time
Selective usage of index in planner/optimizer (Too conservative?) Ludwig Lim 11:47
Re: Selective usage of index in planner/optimizer (Too conservative?) Tom Lane 14:24

Oct. 23, 2002

Thread Author Time
Re: Selective usage of index in planner/optimizer (Too conservative?) Ludwig Lim 01:48
joining views Tomasz Myrta 07:53
Re: joining views Tom Lane 14:31
Re: joining views Tomasz Myrta 15:02

Oct. 26, 2002

Thread Author Time
Basic question about indexes/explain Terry Yapt 10:27
Re: Basic question about indexes/explain Mario Weilguni 11:40
Re: Basic question about indexes/explain Tom Lane 14:24
Setting shared buffers Carlos Moreno 22:36

Oct. 27, 2002

Thread Author Time
Re: Setting shared buffers Josh Berkus 00:14

Oct. 28, 2002

Thread Author Time
[pgsql-performance] Performance Problems Lars Maschke 11:00
Clusters James Kelty 20:47
Re: Clusters Andrew Sullivan 20:59
Re: Clusters Sean Chittenden 21:18
Re: Clusters Andrew Sullivan 21:32
Low Budget Performance eric soroos 21:56
Re: Setting shared buffers Carlos Moreno 22:07

Oct. 29, 2002

Thread Author Time
Re: Clusters James Kelty 00:00
Re: Clusters Andrew Sullivan 03:27
Re: Low Budget Performance Shridhar Daithankar 06:30
Re: Low Budget Performance Mario Weilguni 07:07
Re: [pgsql-performance] Performance Problems Andrew Sullivan 13:38
Re: Clusters Tom Lane 13:43
Possible OT - Benchmark test for 7.3 Beta 3 Kenny H Klatt 14:26
Re: Possible OT - Benchmark test for 7.3 Beta 3 Andrew Sullivan 15:15
Re: Low Budget Performance Josh Berkus 17:00
Re: Low Budget Performance Josh Berkus 17:10
Re: Low Budget Performance Andrew Sullivan 17:31
Re: Low Budget Performance eric soroos 18:43
Re: Low Budget Performance Andrew Sullivan 20:13
Re: Low Budget Performance Ron Johnson 21:09
Re: Low Budget Performance Robert J. Sanford, Jr. 21:57

Oct. 31, 2002

Thread Author Time
Re: PG_Autotune 0.1 Justin Clift 01:38

Browse Archives

Prev | Next