pgsql-performance since 2005-04-16 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

April 16, 2005

Thread Author Time
Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How Ron Mayer 00:10
Re: How to improve db performance with $7K? Kevin Brown 00:53
Re: How to improve db performance with $7K? Kevin Brown 00:58
Re: How to improve db performance with $7K? Kevin Brown 01:33
Re: Query Optimizer Failure / Possible Bug Hannes Dorbath 10:45

April 17, 2005

Thread Author Time
Re: immutable functions vs. join for lookups ? Enrico Weigelt 06:06
Re: immutable functions vs. join for lookups ? Jaime Casanova 08:37
Re: plperl vs plpgsql Alex 12:56
Re: plperl vs plpgsql Stefan Weiss 13:32
Re: plperl vs plpgsql Joshua D. Drake 13:51
refcurosr vs. setof Rdiger Herrmann 20:05
Re: plperl vs plpgsql Christopher Browne 23:17

April 18, 2005

Thread Author Time
Postgresql works too slow Nurlan Mukhanov (AL/EKZ) 04:50
Re: Postgresql works too slow Steve Poe 05:42
Storing Large Objects brew 06:09
Re: Postgresql works too slow Tom Lane 06:11
Re: Storing Large Objects Tom Lane 06:18
Re: Postgresql works too slow Christopher Kings-Lynne 06:40
Re: Storing Large Objects brew 06:47
Re: How to improve db performance with $7K? William Yu 08:05
UNSUBSCRIBE Nick Trainor 08:07
Re: immutable functions vs. join for lookups ? Dawid Kuroczko 09:00
Debian stable, was Re: Storing Large Objects Gordon Haverland 11:12
Re: immutable functions vs. join for lookups ? Merlin Moncure 12:50
Re: Debian stable, was Re: Storing Large Objects brew 12:53
FW: speed of querry? Joel Fradkin 13:00
FW: speed of querry? Joel Fradkin 13:01
FW: speed of querry? Joel Fradkin 13:09
Re: speed of querry? Dave Page 13:18
Re: speed of querry? Joel Fradkin 13:31
Re: immutable functions vs. join for lookups ? Dawid Kuroczko 14:19
Re: FW: speed of querry? Stephan Szabo 14:30
How to improve postgres performace Rodrigo Moreno 14:36
Re: How to improve db performance with $7K? Greg Stark 14:59
Re: How to improve db performance with $7K? Alex Turner 15:17
Re: How to improve db performance with $7K? Dave Held 15:20
Re: Storing Large Objects Bruno Wolff III 15:21
Sort and index Andrei Gaspar 15:36
Re: How to improve db performance with $7K? Greg Stark 15:43
Re: Sort and index Dave Held 15:44
Re: immutable functions vs. join for lookups ? Tom Lane 15:50
Re: How to improve postgres performace Tom Lane 15:58
Re: Sort and index Andrei Gaspar 16:11
RES: How to improve postgres performace Rodrigo Moreno 16:31
Re: How to improve db performance with $7K? Alex Turner 16:56
Re: Sort and index Michael Fuhr 17:10
Re: How to improve db performance with $7K? John A Meinel 17:16
Re: How to improve db performance with $7K? Jacques Caron 17:32
Re: RES: How to improve postgres performace Tom Lane 17:32
Re: How to improve db performance with $7K? Alan Stange 17:34
Re: How to improve db performance with $7K? Jacques Caron 17:41
Re: How to improve db performance with $7K? Steve Poe 17:46
RES: RES: How to improve postgres performace Rodrigo Moreno 17:46
Re: How to improve db performance with $7K? Alex Turner 18:16
Re: How to improve db performance with $7K? Alex Turner 18:18
Re: How to improve db performance with $7K? Alex Turner 18:19
Re: How to improve db performance with $7K? Alex Turner 18:21
Re: How to improve db performance with $7K? Greg Stark 18:24
Re: How to improve db performance with $7K? Jacques Caron 18:24
Re: How to improve db performance with $7K? Joshua D. Drake 18:27
Re: Compressing WAL Bruce Momjian 18:31
Re: immutable functions vs. join for lookups ? Greg Stark 18:33
Re: How to improve db performance with $7K? Mohan, Ross 18:41
Re: How to improve db performance with $7K? Jacques Caron 18:43
Re: How to improve db performance with $7K? Alex Turner 18:50
Question on REINDEX Bill Chandler 19:21
Re: How to improve db performance with $7K? Alex Turner 19:26
Question on vacuumdb Bill Chandler 19:27
Re: Question on REINDEX Josh Berkus 19:33
Re: immutable functions vs. join for lookups ? Tom Lane 19:50
Re: Question on REINDEX Bruno Wolff III 19:53
Re: Question on vacuumdb Bruno Wolff III 19:58
Re: Question on REINDEX Tom Lane 20:13
Re: How to improve db performance with $7K? William Yu 20:37
Re: How to improve db performance with $7K? Bruce Momjian 20:58
Re: How to improve db performance with $7K? Alex Turner 22:49
Re: How to improve db performance with $7K? Alvaro Herrera 22:56

April 19, 2005

Thread Author Time
Re: Storing Large Objects brew 00:44
Re: How to improve db performance with $7K? Bruce Momjian 01:45
Re: Foreign key slows down copy/insert Joshua D. Drake 02:20
Re: refcurosr vs. setof Michael Fuhr 03:10
Re: postgresql faster in Linux than FreeBSD? PriceComparison.com 05:21
Re: Question on REINDEX Tambet Matiisen 08:33
Re: How to improve db performance with $7K? Dave Held 13:34
Re: Question on REINDEX Tom Lane 14:06
Re: How to improve db performance with $7K? Mohan, Ross 14:34
Re: Postgresql works too slow Simon Riggs 14:46
Re: Postgresql works too slow Brad Nicholson 15:06
Re: Question on REINDEX Josh Berkus 15:57
Re: How to improve db performance with $7K? Bruce Momjian 16:10
Re: How to improve db performance with $7K? Mohan, Ross 16:12
Re: How to improve db performance with $7K? Bruce Momjian 16:16
Re: How to improve db performance with $7K? Richard_D_Levine 16:22
Re: Question on REINDEX Tom Lane 16:24
Re: How to improve db performance with $7K? Mohan, Ross 16:25
Re: Question on REINDEX Josh Berkus 17:56
Re: Question on REINDEX Tom Lane 18:02
Re: Question on REINDEX Alvaro Herrera 18:28
Re: Question on REINDEX Tom Lane 18:34
Bad n_distinct estimation; hacks suggested? Josh Berkus 19:09
Re: Bad n_distinct estimation; hacks suggested? Dave Held 20:01
Re: Bad n_distinct estimation; hacks suggested? Tom Lane 20:44
Re: Bad n_distinct estimation; hacks suggested? Josh Berkus 21:33
Re: [HACKERS] PLM pulling from CVS nightly for testing in STP Mark Wong 22:13
Re: How to improve db performance with $7K? Jim C. Nasby 23:08

April 20, 2005

Thread Author Time
Re: How to improve db performance with $7K? Jim C. Nasby 00:03
Re: How to improve db performance with $7K? Jim C. Nasby 00:05
Re: How to improve db performance with $7K? Jim C. Nasby 00:12
Re: How to improve db performance with $7K? Jim C. Nasby 00:15
Re: immutable functions vs. join for lookups ? Jim C. Nasby 00:30
Re: How to improve postgres performace Jim C. Nasby 00:35
Re: Sort and index Jim C. Nasby 00:42
What to do with 6 disks? Jeff Frost 01:00
Re: What to do with 6 disks? Jim C. Nasby 01:55
Slow copy with little CPU/disk usage Jim C. Nasby 02:00
Re: Sort and index Tom Lane 03:01
Re: Slow copy with little CPU/disk usage Tom Lane 03:05
Re: What to do with 6 disks? William Yu 03:06
Re: What to do with 6 disks? Josh Berkus 03:07
Re: Sort and index Jim C. Nasby 03:40
Re: Slow copy with little CPU/disk usage Greg Stark 04:34
Re: Slow copy with little CPU/disk usage Mischa Sandberg 04:37
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Jeff Frost 04:40
How to tell what your postgresql server is doing Jeff Frost 04:44
Re: How to tell what your postgresql server is doing Christopher Kings-Lynne 05:21
Re: Opteron vs Xeon (Was: What to do with 6 disks?) J. Andrew Rogers 06:02
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Jeff Frost 06:21
Re: immutable functions vs. join for lookups ? Dawid Kuroczko 08:35
Re: immutable functions vs. join for lookups ? Christopher Kings-Lynne 08:52
Re: immutable functions vs. join for lookups ? Christopher Kings-Lynne 08:53
Re: How to improve db performance with $7K? Dawid Kuroczko 08:55
When are index scans used over seq scans? Richard van den Berg 14:22
Re: When are index scans used over seq scans? John A Meinel 14:34
Re: When are index scans used over seq scans? Tom Lane 14:39
Re: Opteron vs Xeon (Was: What to do with 6 disks?) William Yu 15:09
Re: When are index scans used over seq scans? Richard van den Berg 15:15
Re: Spend 7K *WHERE*? WAS Intel SRCS16 SATA raid? and How Vivek Khera 15:24
Re: Foreign key slows down copy/insert Vivek Khera 15:27
Re: What to do with 6 disks? Vivek Khera 15:36
Re: When are index scans used over seq scans? John A Meinel 15:37
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Vivek Khera 15:38
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Anjan Dave 15:46
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Bruce Momjian 15:50
Re: When are index scans used over seq scans? Richard van den Berg 15:54
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Christian Sander Røsnes 16:14
Re: How to improve db performance with $7K? Mohan, Ross 16:17
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Anjan Dave 16:33
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Josh Berkus 16:39
Re: How to improve db performance with $7K? Mohan, Ross 16:44
Re: How to improve db performance with $7K? Alex Turner 17:04
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Greg Stark 17:10
Re: Sort and index Andrei Gaspar 17:10
postgres slowdown question Shachindra Agarwal 17:16
Re: How to improve db performance with $7K? Dave Held 17:16
Re: How to improve db performance with $7K? Alex Turner 17:40
Re: Bad n_distinct estimation; hacks suggested? Josh Berkus 17:59
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Rod Taylor 18:01
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Mike Rylander 18:11
Re: Opteron vs Xeon (Was: What to do with 6 disks?) Joel Fradkin 18:15
Re: Joel's Performance Issues WAS : Opteron vs Xeon Josh Berkus 18:53
Re: How to improve db performance with $7K? Mohan, Ross 19:01
Re: How to tell what your postgresql server is doing 📎 Tambet Matiisen 19:27
Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin 19:28
Re: Disk filling, CPU filling, renegade inserts and Rod Taylor 19:36
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin 19:52
Re: Disk filling, CPU filling, renegade inserts and Richard Plotkin 20:05
Re: Joel's Performance Issues WAS : Opteron vs Xeon Anjan Dave 20:22
Re: Joel's Performance Issues WAS : Opteron vs Xeon Josh Berkus 20:22
Re: Joel's Performance Issues WAS : Opteron vs Xeon John A Meinel 20:42
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin 20:43
Re: postgres slowdown question John A Meinel 20:48
Re: Disk filling, CPU filling, renegade inserts and deletes? Tom Lane 20:51
Re: Joel's Performance Issues WAS : Opteron vs Xeon Vivek Khera 21:01
Re: Disk filling, CPU filling, renegade inserts and deletes? Richard Plotkin 21:06
Re: Slow copy with little CPU/disk usage Jim C. Nasby 22:22
Re: Slow copy with little CPU/disk usage Jim C. Nasby 22:23
Re: postgres slowdown question Shachindra Agarwal 23:16
Re: postgres slowdown question John A Meinel 23:35

April 21, 2005

Thread Author Time
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin 00:26
Re: Joel's Performance Issues WAS : Opteron vs Xeon John A Meinel 00:45
Re: Opteron vs Xeon Christopher Browne 01:56
Re: Joel's Performance Issues WAS : Opteron vs Xeon Josh Berkus 03:32
Re: Joel's Performance Issues WAS : Opteron vs Xeon Tom Lane 04:35
Re: How to improve db performance with $7K? William Yu 05:02
Re: When are index scans used over seq scans? Richard van den Berg 08:15
How can an index be larger than a table David Roussel 10:13
two queries and dual cpu (perplexed) Shoaib Burq (VPAC) 11:49
Re: When are index scans used over seq scans? Richard van den Berg 12:14
Re: two queries and dual cpu (perplexed) Daniel Schuchardt 12:19
Re: two queries and dual cpu (perplexed) Jeff 12:24
Re: two queries and dual cpu (perplexed) Gavin Sherry 12:33
Re: two queries and dual cpu (perplexed) Kenneth Marshall 12:36
Re: two queries and dual cpu (perplexed) Shoaib Burq (VPAC) 12:44
Re: Joel's Performance Issues WAS : Opteron vs Xeon Merlin Moncure 12:56
Re: Joel's Performance Issues WAS : Opteron vs Xeon Andreas Pflug 13:05
Re: two queries and dual cpu (perplexed) Russell Smith 13:29
Re: two queries and dual cpu (perplexed) Shoaib Burq (VPAC) 13:32
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin 13:53
Re: When are index scans used over seq scans? Tom Lane 14:25
Re: Joel's Performance Issues WAS : Opteron vs Xeon Joel Fradkin 14:36

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