pgsql-performance since 2004-08-05 00:00

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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 5, 2004

Thread Author Time
Re: Performance Bottleneck Pierre-Frédéric Caillaud 06:40
pg_dump performance? Jesper Krogh 07:08
Re: [GENERAL] Tuning queries on large database Valerie Schneider DSI/DEV 08:16
Re: [GENERAL] Tuning queries on large database Gaetano Mendola 09:53
Re: [GENERAL] Tuning queries on large database Mark Kirkwood 10:09
Re: [GENERAL] Tuning queries on large database Gaetano Mendola 13:07
Re: [GENERAL] Tuning queries on large database Rod Taylor 13:18
Re: [GENERAL] Tuning queries on large database Merlin Moncure 13:20
Re: [GENERAL] Tuning queries on large database Merlin Moncure 13:26
Temporary tables G u i d o B a r o s i o 14:33
Re: Performance Bottleneck Steinar H. Gunderson 15:04
Re: Temporary tables Gaetano Mendola 15:37
Re: Temporary tables Gaetano Mendola 15:41
performance with column orders Jim Thomason 18:10

Aug. 6, 2004

Thread Author Time
Re: pg_dump performance? Christopher Kings-Lynne 04:46
Re: pg_dump performance? Jesper Krogh 05:05
Re: The black art of postgresql.conf tweaking Josh Berkus 16:29
Re: Performance Bottleneck Mike Benoit 17:06
Re: The black art of postgresql.conf tweaking Gaetano Mendola 18:27
Re: Performance Bottleneck Martin Foster 22:58
Re: The black art of postgresql.conf tweaking Josh Berkus 23:18
Re: Performance Bottleneck Martin Foster 23:18
Re: Performance Bottleneck Gaetano Mendola 23:24
Re: The black art of postgresql.conf tweaking Gaetano Mendola 23:41

Aug. 7, 2004

Thread Author Time
Re: Performance Bottleneck Tom Lane 00:00
Question about Generating Possible Plans by the planner/optimizer sandra ruiz 00:28
Re: Performance Bottleneck Scott Marlowe 00:56
Re: Question about Generating Possible Plans by the planner/optimizer Steinar H. Gunderson 01:11
Re: Performance Bottleneck Martin Foster 04:02
Re: Performance Bottleneck Scott Marlowe 04:36
Re: Performance Bottleneck Martin Foster 04:39
Re: Performance Bottleneck Gaetano Mendola 10:03
Re: Performance Bottleneck Gaetano Mendola 10:11
Re: Performance Bottleneck Christopher Kings-Lynne 10:49
Re: Performance Bottleneck Jan Wieck 14:21

Aug. 8, 2004

Thread Author Time
Re: Performance Bottleneck Martin Foster 05:14
Re: Performance Bottleneck Martin Foster 05:29
Re: Performance Bottleneck Mike Benoit 08:21
Re: Performance Bottleneck Jeff 12:10
Re: Performance Bottleneck Jan Wieck 13:52
Re: Performance Bottleneck Matt Clark 14:29
Re: Performance Bottleneck Martin Foster 15:49
Re: Performance Bottleneck Arjen van der Meijden 16:02
Re: Performance Bottleneck Martin Foster 18:18

Aug. 9, 2004

Thread Author Time
Re: Performance Bottleneck Tatsuo Ishii 01:09
Re: Performance Bottleneck Tatsuo Ishii 01:12
Re: The black art of postgresql.conf tweaking CoL 11:16
Re: The black art of postgresql.conf tweaking Paul Serby 14:28
Re: The black art of postgresql.conf tweaking Shridhar Daithankar 14:46
tablespaces and ramdisks Merlin Moncure 15:29
Re: tablespaces and ramdisks Tom Lane 16:35
Slow select, insert, update Paul Langard 16:54
Help specifying new machine Rory Campbell-Lange 16:56
Re: Help specifying new machine Bill Montgomery 20:08

Aug. 10, 2004

Thread Author Time
insert waits for delete with trigger Litao Wu 00:05
Re: insert waits for delete with trigger Tom Lane 00:31
Re: insert waits for delete with trigger Litao Wu 04:35
Re: insert waits for delete with trigger Tom Lane 04:41
Column order performance Bill Montgomery 13:39
Re: Performance Bottleneck Alex Hayward 14:35
Re: insert waits for delete with trigger Litao Wu 14:48
Re: [HACKERS] fsync vs open_sync Merlin Moncure 15:25
Re: [HACKERS] fsync vs open_sync pgsql 15:54
Re: insert waits for delete with trigger Tom Lane 16:53
Re: [HACKERS] fsync vs open_sync Josh Berkus 17:18
Re: Column order performance Josh Berkus 17:23
Re: [HACKERS] fsync vs open_sync pgsql 18:04
Re: Slow select, insert, update Tom Lane 18:18
Re: Column order performance Bill Montgomery 18:49
Re: Slow select, insert, update Bill Montgomery 18:56
Hardware upgrade for a high-traffic database Jason Coene 19:17
Re: Performance Bottleneck matt 20:04
Re: Slow select, insert, update Doug McNaught 20:48
Re: Slow select, insert, update Litao Wu 21:44
Bulk Insert and Index use Rudi Starcevic 23:04
Re: Hardware upgrade for a high-traffic database Rod Taylor 23:06

Aug. 11, 2004

Thread Author Time
Re: Hardware upgrade for a high-traffic database Scott Marlowe 00:00
Re: Hardware upgrade for a high-traffic database Jason Coene 01:06
Re: Bulk Insert and Index use Christopher Browne 02:24
Re: Bulk Insert and Index use Gregory S. Williamson 02:27
Re: Bulk Insert and Index use Jim J 02:31
Re: Bulk Insert and Index use Rudi Starcevic 03:33
Re: Bulk Insert and Index use Gregory S. Williamson 03:53
Re: Bulk Insert and Index use Rudi Starcevic 04:10
NUMERIC x VARCHAR 📎 Er Galvão Abbott 05:42
Re: NUMERIC x VARCHAR Scott Marlowe 06:21
Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud 06:43
Re: NUMERIC x VARCHAR Pierre-Frédéric Caillaud 06:47
Re: NUMERIC x VARCHAR 📎 Er Galvão Abbott 07:27
Re: NUMERIC x VARCHAR Michael Glaesemann 07:41
Re: Hardware upgrade for a high-traffic database Merlin Moncure 12:21
Storing binary data. Jesper Krogh 14:29
Re: Storing binary data. Shridhar Daithankar 15:12
Re: Hardware upgrade for a high-traffic database Sanjay Arora 15:47
Re: Storing binary data. Tom Lane 16:06
Re: How to know which queries are to be optimised? Bruno Wolff III 16:27
Re: Storing binary data. Jesper Krogh 16:29
Re: fsync vs open_sync Merlin Moncure 16:37
Re: Hardware upgrade for a high-traffic database Merlin Moncure 17:04
Re: NUMERIC x VARCHAR 📎 Er Galvão Abbott 17:13
Re: fsync vs open_sync pgsql 17:14
My admin left the job and I am stuck Karam Chand 18:41
Re: Hardware upgrade for a high-traffic database Jason Coene 19:08
Re: NUMERIC x VARCHAR Jan Wieck 19:19
Re: Hardware upgrade for a high-traffic database Brian Hirt 19:39
Re: Hardware upgrade for a high-traffic database Merlin Moncure 19:49
Re: [HACKERS] fsync vs open_sync Steve Bergman 20:51
Re: Hardware upgrade for a high-traffic database Jason Coene 21:18
Re: Hardware upgrade for a high-traffic database Brian Hirt 21:31
Re: Hardware upgrade for a high-traffic database Rod Taylor 21:46
Re: Hardware upgrade for a high-traffic database Rod Taylor 21:50
Re: Hardware upgrade for a high-traffic database Jason Coene 22:03
Re: Hardware upgrade for a high-traffic database Rod Taylor 22:26
Re: Hardware upgrade for a high-traffic database Jason Coene 22:53
Re: Hardware upgrade for a high-traffic database Tom Lane 23:20
Re: Storing binary data. Russell Smith 23:44
Re: Hardware upgrade for a high-traffic database Russell Smith 23:52

Aug. 12, 2004

Thread Author Time
Buld Insert and Index use. Rudi Starcevic 00:00
Re: [HACKERS] fsync vs open_sync Gaetano Mendola 00:06
Re: Buld Insert and Index use. Josh Berkus 00:25
Re: Hardware upgrade for a high-traffic database Jason Coene 00:29
Re: Hardware upgrade for a high-traffic database Tom Lane 02:09
Re: Hardware upgrade for a high-traffic database Pierre-Frédéric Caillaud 06:49
Re: [GENERAL] How to know which queries are to be optimised? Ulrich Wisser 10:37
Re: [GENERAL] How to know which queries are to be optimised? Richard Huxton 11:16
Re: Hardware upgrade for a high-traffic database Merlin Moncure 13:39
Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne 14:07
Re: [GENERAL] How to know which queries are to be optimised? Christopher Kings-Lynne 14:09
Re: Hardware upgrade for a high-traffic database Merlin Moncure 16:58
Re: Hardware upgrade for a high-traffic database Tom Lane 17:09
Re: Hardware upgrade for a high-traffic database Merlin Moncure 17:48
Re: My admin left the job and I am stuck Laura Vance 18:02
Re: Hardware upgrade for a high-traffic database gnari 18:59
Re: Hardware upgrade for a high-traffic database Merlin Moncure 19:27
Performance Problem With Postgresql! Arash Zaryoun 20:09
Re: Help specifying new machine William Yu 22:12
Re: [GENERAL] How to know which queries are to be optimised? Rudi Starcevic 22:50

Aug. 13, 2004

Thread Author Time
Re: Help specifying new machine Raoul Buzziol 06:29
insert Ulrich Wisser 07:47
Re: insert G u i d o B a r o s i o 10:08
Re: insert gnari 10:49
Re: insert G u i d o B a r o s i o 11:16
Re: insert gnari 11:47
Re: insert Ulrich Wisser 12:10
Re: insert Paul Thomas 12:41
Re: insert Rod Taylor 12:57
Weird Database Performance problem! Arash Zaryoun 14:43
Re: insert Bruno Wolff III 15:02
Re: Weird Database Performance problem! Richard Huxton 15:20
Re: fsync vs open_sync Pierre-Frédéric Caillaud 16:06
Reiser4 Pierre-Frédéric Caillaud 16:12
Re: insert Matt Clark 16:17
Re: insert Bruno Wolff III 16:31
Re: [PERFORM] Performance Problem With Postgresql! Josh Berkus 17:19
Re: Reiser4 Josh Berkus 18:01
Re: insert Tom Lane 18:01
Re: Weird Database Performance problem! Richard Huxton 19:23
Re: fsync vs open_sync Merlin Moncure 19:58
REINDEX needed because of index corruption need help ASAP borajetta 21:40
Re: REINDEX needed because of index corruption need help ASAP Josh Berkus 22:18
Re: REINDEX needed because of index corruption need help ASAP Tom Lane 22:23

Aug. 14, 2004

Thread Author Time
Replication: Slony-I vs. Mammoth Replicator vs. ? Chris Cheston 01:27
Re: [PERFORM] Reiser4 Bruce Momjian 01:30
Re: Reiser4 Bruce Momjian 01:31
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? 📎 Joshua D. Drake 01:39
Re: [PERFORM] Reiser4 Peter Eisentraut 10:57
Re: insert Gaetano Mendola 14:24
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Jan Wieck 15:33
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake 16:22
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Jan Wieck 17:56
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Christopher Browne 19:58

Aug. 15, 2004

Thread Author Time
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Joshua D. Drake 00:55
Faster with a sub-query then without Martin Foster 03:03
Re: Faster with a sub-query then without Tom Lane 03:55
Slow joins against set-returning functions Michael Fuhr 16:00
Re: Faster with a sub-query then without Martin Foster 16:01
Re: Slow joins against set-returning functions Tom Lane 17:21
Help interpreting explain analyze output Ole Tange 17:47
Re: Help interpreting explain analyze output Tom Lane 18:13
Re: Help interpreting explain analyze output Richard Poole 18:24
Re: Help interpreting explain analyze output Ole Tange 19:08
Re: Help interpreting explain analyze output Tom Lane 19:40
Re: Help specifying new machine William Yu 20:17

Aug. 16, 2004

Thread Author Time
Strange problems with more memory. Stef 15:12
Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Vivek Khera 15:12
Re: Strange problems with more memory. Tom Lane 15:41
Re: Strange problems with more memory. Stef 16:23
Re: Timestamp-based indexing Josh Berkus 23:09
Re: Index type Josh Berkus 23:16
Re: Timestamp-based indexing Tom Lane 23:25

Aug. 17, 2004

Thread Author Time
Re: Strange problems with more memory. Mark Kirkwood 06:26
General performance problem! olivier HARO 13:30
Re: General performance problem! Gaetano Mendola 13:48
Re: General performance problem! Leeuw van der, Tim 13:57
Re: General performance problem! Richard Huxton 14:16
I could not get postgres to utilizy indexes Igor Artimenko 14:22
Postgres does not utilize indexes. Why? Artimenko Igor 15:35
Re: General performance problem! olivier HARO 15:41
Re: Postgres does not utilize indexes. Why? Michal Taborsky 15:45
Re: General performance problem! Duane Lee - EGOVX 16:58

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31