pgsql-performance - December 2004

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 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30 31

Dec. 1, 2004

Thread Author Time
Re: Hardware purchase question Josh Berkus 00:26
Re: FW: Index usage BBI Edwin Punzalan 01:50
Re: FW: Index usage gnari 02:07
Re: FW: Index usage BBI Edwin Punzalan 02:33
Re: FW: Index usage Iain 04:00
Re: FW: Index usage BBI Edwin Punzalan 04:05
Using "LIMIT" is much faster even though, searching with PK. 장현성 04:10
Re: FW: Index usage Iain 04:18
Re: Using "LIMIT" is much faster even though, searching with PK. Tom Lane 04:26
Re: Using "LIMIT" is much faster even though, searching Hyun-Sung, Jang 04:38
Re: Using "LIMIT" is much faster even though, searching Josh Berkus 05:03
Re: Using "LIMIT" is much faster even though, searching Hyun-Sung, Jang 06:03
Re: Using "LIMIT" is much faster even though, searching Andrew McMillan 08:23
Re: FW: Index usage gnari 08:24
pg_restore taking 4 hours! Rodrigo Carvalhaes 11:16
Re: Query Performance and IOWait George Woodring 13:29
Re: [PERFORM] pg_restore taking 4 hours! Shridhar Daithankar 14:25
Re: [PERFORM] pg_restore taking 4 hours! Riccardo G. Facchini 15:19
Re: [PERFORM] pg_restore taking 4 hours! Tom Lane 15:38
query with timestamp not using index Brian Hirt 16:46
Re: query with timestamp not using index Richard Huxton 17:38
Re: query with timestamp not using index Tom Lane 20:06
Re: [PERFORM] pg_restore taking 4 hours! Josh Berkus 20:19
Re: Using "LIMIT" is much faster even though, searching Josh Berkus 20:25
Re: query with timestamp not using index Brian Hirt 22:09
Re: query with timestamp not using index Tom Lane 22:16
Alternatives to Dell? Josh Berkus 22:24
Re: Alternatives to Dell? Bruce Momjian 22:25
Re: Alternatives to Dell? Geoffrey 22:38
Re: Alternatives to Dell? Frank Wiles 22:41
Re: Alternatives to Dell? Merlin Moncure 22:43
Re: Alternatives to Dell? Mike Rylander 22:48
Re: Alternatives to Dell? 📎 Joshua D. Drake 23:13
Re: Off-list Re: Alternatives to Dell? Josh Berkus 23:35

Dec. 2, 2004

Thread Author Time
Re: Alternatives to Dell? Steven Rosenstein 00:17
Recommended Specs Hasnul Fadhly bin Hasan 00:20
Re: Alternatives to Dell? Matthew Marlowe 01:35
Re: Alternatives to Dell? Geoffrey 01:58
Re: Alternatives to Dell? Iain 02:10
Re: Alternatives to Dell? 📎 Joshua D. Drake 02:15
Re: Alternatives to Dell? Geoffrey 02:21
Re: Off-list Re: Alternatives to Dell? Sven Willenberger 02:23
Re: Alternatives to Dell? Anjan Dave 03:48
Re: Alternatives to Dell? Geoffrey 03:56
Re: Recommended Specs Josh Berkus 06:15
Re: Alternatives to Dell? Robin Ericsson 08:43
Re: Alternatives to Dell? Steinar H. Gunderson 10:59
Re: Alternatives to Dell? Steinar H. Gunderson 11:00
Re: Alternatives to Dell? Dave Cramer 12:06
Re: Alternatives to Dell? Geoffrey 13:12
pg replication tools? sarlav kumar 14:38
Re: Alternatives to Dell? Joe Conway 14:42
Re: pg_restore taking 4 hours! Thierry Missimilly 15:46
Re: VACUUM ANALYZE downgrades performance Dmitry Karasik 16:07
Re: VACUUM ANALYZE downgrades performance Rod Taylor 16:25
Re: VACUUM ANALYZE downgrades performance Steinar H. Gunderson 16:30
Re: VACUUM ANALYZE downgrades performance Shridhar Daithankar 16:38
Re: Alternatives to Dell? Thomas F.O'Connell 16:47
Re: pg replication tools? 📎 Joshua D. Drake 16:50
Re: pg_restore taking 4 hours! 📎 Joshua D. Drake 16:53
Re: pg replication tools? Darcy Buskermolen 16:58
Normalization or Performance Alvaro Nunes Melo 17:05
Different location or different instance Gabriele Bartolini 17:16
Re: pg_restore taking 4 hours! Andrew McMillan 17:58
Re: Normalization or Performance Richard Huxton 18:34
Re: Alternatives to Dell? Merlin Moncure 18:39
Poor Performance on a table Pallav Kalva 19:11
Re: Poor Performance on a table Frank Wiles 19:20
Re: [PERFORM] scalability issues on win32 Merlin Moncure 19:21
Re: [PERFORM] scalability issues on win32 Bruce Momjian 19:28
Re: Poor Performance on a table Pallav Kalva 19:32
Re: Poor Performance on a table Tom Lane 19:36
Re: Poor Performance on a table Frank Wiles 19:38
Re: [PERFORM] scalability issues on win32 Tom Lane 19:42
Re: Poor Performance on a table Pallav Kalva 19:54
Re: Poor Performance on a table Tom Lane 20:10
Re: Normalization or Performance Jim C. Nasby 23:03

Dec. 3, 2004

Thread Author Time
Re: Normalization or Performance Iain 01:44
Re: pg replication tools? Christopher Browne 02:39
Re: pg replication tools? Vishal Kashyap @ [SaiHertz] 05:16
Re: Poor Performance on a table Josh Berkus 05:57
Re: VACUUM ANALYZE downgrades performance Dmitry Karasik 10:42
Re: Alternatives to Dell? Cott Lang 14:19
Re: Alternatives to Dell? 📎 Joshua D. Drake 14:30
Re: Alternatives to Dell? Cott Lang 14:33
Re: Alternatives to Dell? 📎 Joshua D. Drake 14:38
Re: Alternatives to Dell? Cott Lang 16:55
DB2 feature Pailloncy Jean-Gérard 20:38
Re: DB2 feature Josh Berkus 21:02
Performance difference in similar queries Kiran Mukhyala 22:12
Re: DB2 feature Christopher Browne 22:27
Performance difference in similar queries Kiran Mukhyala 22:31
Re: DB2 feature Pailloncy Jean-Gérard 22:48

Dec. 4, 2004

Thread Author Time
Re: Alternatives to Dell? Mike Rylander 01:53
Overhead of dynamic query in trigger Sven Willenberger 03:46
Improve BULK insertion Grupos 13:39
Re: Improve BULK insertion 📎 Patrick Hatcher 14:47
Re: Improve BULK insertion Christopher Browne 14:48
lock problem sarlav kumar 16:56
Re: Alternatives to Dell? Cott Lang 17:22
Re: lock problem Stephan Szabo 17:34
Re: Improve BULK insertion Josh Berkus 19:14

Dec. 5, 2004

Thread Author Time
Partitioned table performance Stacy White 02:45
Re: pg_restore taking 4 hours! Rodrigo Carvalhaes 19:43
Re: Improve BULK insertion Rodrigo Carvalhaes 19:52
Re: Improve BULK insertion Gregory S. Williamson 22:48
Re: Partitioned table performance Josh Berkus 23:06
Re: Improve BULK insertion Josh Berkus 23:19

Dec. 6, 2004

Thread Author Time
8.0 vs. 7.4 benchmarks Postgres Learner 09:28
TableSpace Design issues on Postgres 8.0 beta 5 Rosny 13:52
Config review Bryan Vest 14:40
Config Check Bryan 14:43
Re: Config Check Pierre-Frédéric Caillaud 15:18
Poor Query Pallav Kalva 15:28
Re: Poor Query Pierre-Frédéric Caillaud 15:48
Re: Poor Query Pallav Kalva 15:52
Re: Config Check Tom Lane 15:56
Re: Poor Query Pierre-Frédéric Caillaud 16:16
Re: Poor Query Pallav Kalva 16:37
Processor optimization compile options? Josh Berkus 17:26
Re: Poor Query Pierre-Frédéric Caillaud 17:34
Re: Poor Query Pallav Kalva 18:00
Re: Alternatives to Dell? Andrew Sullivan 18:57
Re: Poor Query Pierre-Frédéric Caillaud 20:18
Re: TableSpace Design issues on Postgres 8.0 beta 5 Rosny 20:28
Re: Poor Query Pallav Kalva 20:44
scaling beyond 4 processors vogler 22:18

Dec. 7, 2004

Thread Author Time
Re: Config Check Hasnul Fadhly bin Hasan 02:40
Re: scaling beyond 4 processors Jeff 02:52
Re: Config Check John A Meinel 02:54
Re: scaling beyond 4 processors Christopher Browne 04:16
Re: scaling beyond 4 processors Christopher Browne 04:17
Re: TableSpace Design issues on Postgres 8.0 beta 5 Tom Lane 04:44
Re: Config Check Tom Lane 05:03
Re: TableSpace Design issues on Postgres 8.0 beta 5 Rosny 07:58
Re: Config review Greg Stark 08:03
Fwd: 8.0 vs. 7.4 benchmarks Postgres Learner 09:17
Re: pg_restore taking 4 hours! Hannu Krosing 11:08
Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III 14:52
Re: Config review Tom Lane 15:07
Re: Config review Andrew Sullivan 15:19
Re: Fwd: 8.0 vs. 7.4 benchmarks 📎 Joshua D. Drake 16:43
Re: Fwd: 8.0 vs. 7.4 benchmarks Bruno Wolff III 17:43
Re: scaling beyond 4 processors Josh Berkus 17:49
Re: Fwd: 8.0 vs. 7.4 benchmarks 📎 Joshua D. Drake 18:35

Dec. 8, 2004

Thread Author Time
Slow insert Christopher Kings-Lynne 02:42
Re: Partitioned table performance Stacy White 04:32

Dec. 10, 2004

Thread Author Time
Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 11:40
LIMIT causes SEQSCAN in subselect Mike Rylander 18:40

Dec. 11, 2004

Thread Author Time
Re: Slow insert Steinar H. Gunderson 01:45
Re: Query is not using index when it should Stephan Szabo 02:28
Re: LIMIT causes SEQSCAN in subselect Josh Berkus 05:40
Re: Partitioned table performance Josh Berkus 05:52
Re: Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 14:17
Re: [GENERAL] Query is not using index when it should Steinar H. Gunderson 14:32
Re: LIMIT causes SEQSCAN in subselect Mike Rylander 14:37
Re: [GENERAL] Query is not using index when it should Michael Fuhr 16:25
Very different index usage on similar tables 📎 Alvaro Nunes Melo 17:01
Re: LIMIT causes SEQSCAN in subselect Tom Lane 18:06

Dec. 12, 2004

Thread Author Time
Re: [GENERAL] Query is not using index when it should Tomas =?iso-8859-1?q?Sk=E4re?= 08:32

Dec. 13, 2004

Thread Author Time
Re: Query is not using index when it should Josh Berkus 02:48
Using LIMIT changes index used by planner Sven Willenberger 06:13
Re: Using LIMIT changes index used by planner Andrew McMillan 09:56
INSERT question sarlav kumar 16:28
Re: Hardware purchase question Vivek Khera 16:33
Re: pg_restore taking 4 hours! Vivek Khera 16:37
Re: Alternatives to Dell? Vivek Khera 16:47
Re: INSERT question Tom Lane 16:48
Re: INSERT question Bruno Wolff III 16:49
Similar tables, different indexes performance 📎 Alvaro Nunes Melo 17:17
Re: Off-list Re: Alternatives to Dell? Vivek Khera 17:19
Re: Hardware purchase question 📎 Joshua D. Drake 17:23
Re: Similar tables, different indexes performance Bruno Wolff III 18:03
Re: Alternatives to Dell? Bruce Momjian 18:20
Re: pg_restore taking 4 hours! Josh Berkus 18:25
Re: INSERT question sarlav kumar 18:31
Re: Hardware purchase question Josh Berkus 18:31
Re: INSERT question sarlav kumar 18:33
Re: pg_restore taking 4 hours! Josh Berkus 18:43
Re: pg_restore taking 4 hours! Tom Lane 19:21
Re: Similar tables, different indexes performance Alvaro Nunes Melo 19:32
Re: Using LIMIT changes index used by planner Sven Willenberger 22:06
Re: Using LIMIT changes index used by planner Tom Lane 22:43

Dec. 14, 2004

Thread Author Time
Trying to create multi db query in one large queries Hasnul Fadhly bin Hasan 01:44
Re: pg_restore taking 4 hours! Iain 01:54
Re: Trying to create multi db query in one large querie Spiegelberg, Greg 04:07
Re: Similar tables, different indexes performance Bruno Wolff III 05:22
Re: Trying to create multi db query in one large querie Joe Conway 06:59
Re: Trying to create multi db query in one large queries Josh Berkus 07:18
Re: Hardware purchase question Andrew Hood 09:33
Speeding up pg_dump Rod Taylor 17:36
Re: Anything to be gained from a 'Postgres Filesystem'? Markus Schaber 18:20
Re: Using LIMIT changes index used by planner Sven Willenberger 18:28
Re: Using LIMIT changes index used by planner Tom Lane 19:35
Query Optimization sarlav kumar 21:34
Re: Speeding up pg_dump Simon Riggs 23:11

Dec. 15, 2004

Thread Author Time
Re: Partitioned table performance Stacy White 06:09
\d output to a file sarlav kumar 14:38
Re: [despammed] \d output to a file Andreas Kretschmer 15:04
Re: [PERFORM] \d output to a file Gary Cowell 15:12

Browse Archives

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