pgsql-performance - July 2005

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 25 26 27 28 29 30 31

July 1, 2005

Thread Author Time
Re: ported application having performance issues Dennis Bjorklund 08:57
planner picking more expensive plan Sam Mason 13:33
Re: planner picking more expensive plan Tom Lane 14:22
Re: planner picking more expensive plan Sam Mason 14:58
Re: planner picking more expensive plan John A Meinel 15:17
Re: planner picking more expensive plan Sam Mason 15:58

July 2, 2005

Thread Author Time
Re: ported application having performance issues John Mendenhall 00:52
Planner constants for RAM resident databases Emil Briggs 01:59
Re: Planner constants for RAM resident databases Steve Atkins 02:08
Re: Planner constants for RAM resident databases John A Meinel 02:40
Re: Planner constants for RAM resident databases John A Meinel 03:14
B-Tree index not being used Madison Kelly 04:16
Re: planner picking more expensive plan Dennis Bjorklund 05:24
Re: Planner constants for RAM resident databases Emil Briggs 13:44
Re: B-Tree index not being used Tom Lane 13:54
Re: B-Tree index not being used Madison Kelly 15:20

July 3, 2005

Thread Author Time
Re: investigating slow queries through pg_stat_activity Enrico Weigelt 22:28
plain inserts and deletes very slow Enrico Weigelt 22:45
Re: plain inserts and deletes very slow Enrico Weigelt 22:57
Re: plain inserts and deletes very slow Enrico Weigelt 22:57
Re: plain inserts and deletes very slow Steinar H. Gunderson 23:54

July 4, 2005

Thread Author Time
Re: plain inserts and deletes very slow Enrico Weigelt 00:01
Re: plain inserts and deletes very slow Enrico Weigelt 00:17
Re: plain inserts and deletes very slow David Mitchell 00:50
Re: plain inserts and deletes very slow David Mitchell 01:12
Re: plain inserts and deletes very slow Alvaro Herrera 02:57
Re: plain inserts and deletes very slow David Mitchell 03:51
Re: plain inserts and deletes very slow Enrico Weigelt 08:57
Re: plain inserts and deletes very slow Enrico Weigelt 08:59
Re: plain inserts and deletes very slow Alvaro Herrera 14:27
Why the planner is not using the INDEX . David Gagnon 19:57
Re: Why the planner is not using the INDEX . Stephan Szabo 20:27
Re: plain inserts and deletes very slow Klint Gore 23:36

July 5, 2005

Thread Author Time
Re: Why the planner is not using the INDEX . David Gagnon 00:29
Re: Why the planner is not using the INDEX . Christopher Kings-Lynne 01:13
Re: Why the planner is not using the INDEX . Bruno Wolff III 12:32
Re: Why the planner is not using the INDEX . Stephan Szabo 14:02
Re: Why the planner is not using the INDEX . Tom Lane 16:09
Heavy virtual memory usage on production system Alexander Stanier 16:13
Re: Heavy virtual memory usage on production system Tom Lane 16:55
Re: Why the planner is not using the INDEX . David Gagnon 17:53
Re: Planner constants for RAM resident databases Josh Berkus 21:33

July 6, 2005

Thread Author Time
Re: Heavy virtual memory usage on production system Alexander Stanier 12:03
Re: Heavy virtual memory usage on production system Tom Lane 14:15
Re: Heavy virtual memory usage on production system Alexander Stanier 14:49
Re: Heavy virtual memory usage on production system Tom Lane 15:06
Data Warehousing Tuning Paul Johnson 17:15
Storing data and indexes in different disks Alvaro Nunes Melo 17:58
Re: Storing data and indexes in different disks Dmitri Bichko 18:46
ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number Dario 19:49
Re: ALTER TABLE tabla ALTER COLUMN columna SET STATISTICS number Michael Fuhr 20:07
CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci 21:19
Re: CURSOR slowes down a WHERE clause 100 times? John A Meinel 21:29
join and query planner Dario Pudlo 21:54
join and query planner Dario 22:04
Re: join and query planner Stephan Szabo 22:34

July 7, 2005

Thread Author Time
Re: Data Warehousing Tuning Frank Wosczyna 00:02
Re: Data Warehousing Tuning Josh Berkus 00:40
Re: CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci 07:41
Re: CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci 08:13
Re: CURSOR slowes down a WHERE clause 100 times? Richard Huxton 09:14
Re: CURSOR slowes down a WHERE clause 100 times? Niccolo Rigacci 10:06
How to speed up delete Bendik Rognlien Johansen 11:16
[No subject] Jean-Max Reymond 12:42
Surprizing performances for Postgres on Centrino Jean-Max Reymond 12:49
Re: How to speed up delete PFC 12:55
Re: PFC 13:03
Need suggestion high-level suggestion on how to solve a performance problem Madison Kelly 13:13
Re: Surprizing performances for Postgres on Centrino Dawid Kuroczko 13:48
Re: CURSOR slowes down a WHERE clause 100 times? Tom Lane 13:59
Re: How to speed up delete Tom Lane 14:02
Re: Surprizing performances for Postgres on Centrino Steinar H. Gunderson 14:03
Re: Surprizing performances for Postgres on Centrino Alvaro Herrera 14:09
Re: Surprizing performances for Postgres on Centrino Jean-Max Reymond 14:23
Re: Surprizing performances for Postgres on Centrino Richard Huxton 14:52
Re: How to speed up delete Bendik Rognlien Johansen 15:03
Re: Need suggestion high-level suggestion on how to solve a performance problem PFC 22:21
Re: Need suggestion high-level suggestion on how to solve Madison Kelly 23:28
Re: Need suggestion high-level suggestion on how to solve a performance problem PFC 23:58

July 8, 2005

Thread Author Time
Re: Need suggestion high-level suggestion on how to solve a performance problem Josh Berkus 01:04
Mount database on RAM disk? Stuart Bishop 01:32
Re: Mount database on RAM disk? Joshua D. Drake 03:05
Re: Mount database on RAM disk? Chris Browne 03:30
Re: plain inserts and deletes very slow Enrico Weigelt 13:46
Re: Select performance vs. mssql Enrico Weigelt 14:00
Re: Mount database on RAM disk? Rod Taylor 14:03
Re: Need help to decide Mysql vs Postgres Enrico Weigelt 14:43
Re: Why the planner is not using the INDEX . Enrico Weigelt 15:36
Re: Need help to decide Mysql vs Postgres Mark Lewis 16:08
Re: Need help to decide Mysql vs Postgres Moises Alberto Lindo Gutarra 16:22
cost-based vacuum Ian Westmacott 16:25
Re: Mount database on RAM disk? Josh Berkus 17:22
Re: cost-based vacuum Tom Lane 17:48
Re: Mount database on RAM disk? Merlin Moncure 19:21
Re: Select performance vs. mssql Jochem van Dieten 21:47
How to revoke a password Bailey, Larry 23:56

July 9, 2005

Thread Author Time
Re: How to revoke a password Joshua D. Drake 00:09
Re: How to revoke a password Bailey, Larry 00:16
Re: How to revoke a password Alvaro Herrera 00:17
Re: How to revoke a password Joshua D. Drake 00:56
Re: How to revoke a password Michael Fuhr 00:58
Sorting on longer key is faster ? jobapply 18:38
Re: Mount database on RAM disk? Alex Stapleton 21:48

July 10, 2005

Thread Author Time
Re: Mount database on RAM disk? Christopher Browne 04:54
Re: Data Warehousing Tuning Alexander Kirpa 22:07

July 11, 2005

Thread Author Time
Re: cost-based vacuum Simon Riggs 11:31
Question Alejandro Lemus 12:59
Re: cost-based vacuum Ian Westmacott 13:07
Re: cost-based vacuum Tom Lane 13:28
Re: Question Richard Huxton 13:29
Re: Question Magnus Hagander 13:34
Re: cost-based vacuum Simon Riggs 14:51
Re: Question Gregory S. Williamson 23:26
Re: join and query planner John A Meinel 23:39
Re: Sorting on longer key is faster ? John A Meinel 23:42
Re: Sorting on longer key is faster ? Tom Lane 23:47

July 12, 2005

Thread Author Time
Re: Sorting on longer key is faster ? John A Meinel 01:48
Re: Sorting on longer key is faster ? John A Meinel 01:52
General DB Tuning Brent Henry 06:22
Re: cost-based vacuum Simon Riggs 07:45
Re: join and query planner Bruno Wolff III 14:35
Projecting currentdb to more users 📎 Yves Vindevogel 16:21
Re: cost-based vacuum Ian Westmacott 17:50
Re: Projecting currentdb to more users Matthew Nuzum 18:00
Re: [PERFORM] Projecting currentdb to more users Mohan, Ross 18:24
Re: [PERFORM] Projecting currentdb to more users Scott Marlowe 18:41
Re: [PERFORM] Projecting currentdb to more users Mark Rae 20:06
Re: [PERFORM] Projecting currentdb to more users Scott Marlowe 20:11
Re: [PERFORM] Projecting currentdb to more users Mark Rae 20:32
Re: General DB Tuning Tom Arthurs 21:54
Re: General DB Tuning Brent Henry 23:32

July 13, 2005

Thread Author Time
Re: General DB Tuning Tom Arthurs 00:36
Re: General DB Tuning Dennis 01:05
Re: General DB Tuning Christopher Kings-Lynne 01:17
Re: General DB Tuning Tom Arthurs 01:30
Re: General DB Tuning Brent Henry 01:36
Re: General DB Tuning Christopher Kings-Lynne 01:52
Re: General DB Tuning Tom Arthurs 01:53
Re: Projecting currentdb to more users Jean-Max Reymond 05:18
size of cache Jean-Max Reymond 08:20
Re: General DB Tuning 📎 Mark Rae 10:07
large table vs multiple smal tables Nicolas Beaume 10:08
Re: large table vs multiple smal tables Kenneth Marshall 12:33
(pas de sujet) Nicolas Beaume 13:55
Re: cost-based vacuum Simon Riggs 15:55
Re: size of cache Simon Riggs 16:07
Re: General DB Tuning Simon Riggs 16:10
Re: cost-based vacuum Ian Westmacott 18:40
Quad Opteron stuck in the mud Dan Harris 18:54
Re: cost-based vacuum Tom Lane 18:58
Re: Quad Opteron stuck in the mud Dan Harris 19:09
Re: Quad Opteron stuck in the mud John A Meinel 19:11
performance problems ... 100 cpu utilization Dennis 19:13
Re: Quad Opteron stuck in the mud Dan Harris 19:16
Re: Quad Opteron stuck in the mud Stephen Frost 20:17
Re: Quad Opteron stuck in the mud Alvaro Herrera 20:18
Re: Quad Opteron stuck in the mud Dan Harris 20:20
Re: cost-based vacuum Simon Riggs 20:39
Re: Quad Opteron stuck in the mud Vivek Khera 20:49
Re: cost-based vacuum Ian Westmacott 21:46
Functional index is 5 times slower than the basic one jobapply 22:35
Re: Quad Opteron stuck in the mud Simon Riggs 22:51
Indexing Function called on VACUUM and sorting ? jobapply 23:46

July 14, 2005

Thread Author Time
Slow Query Marc McIntyre 00:06
JFS fastest filesystem for PostgreSQL? Jeffrey W. Baker 00:20
Re: performance problems ... 100 cpu utilization Qingqing Zhou 03:11
Re: performance problems ... 100 cpu utilization Dennis 03:28
Re: performance problems ... 100 cpu utilization David Mitchell 05:07
lots of updates on small table Alison Winters 05:08
Profiler for PostgreSQL Agha Asif Raza 05:58
Re: Quad Opteron stuck in the mud Greg Stark 06:12
Re: Profiler for PostgreSQL Bruce Momjian 06:27
Re: Quad Opteron stuck in the mud Dan Harris 06:28
Re: Profiler for PostgreSQL Christopher Kings-Lynne 06:29
JFS fastest filesystem for PostgreSQL? Jeffrey W. Baker 06:33
Indexing Function called on VACUUM and sorting ? jobapply 06:33
Re: performance problems ... 100 cpu utilization Dennis 06:54
Re: JFS fastest filesystem for PostgreSQL? Dmitri Bichko 07:08
PostgresSQL vs. Firebird Relaxin 07:19
Re: JFS fastest filesystem for PostgreSQL? Dawid Kuroczko 08:03
slow joining very large table to smaller ones Dan Harris 08:05
Re: JFS fastest filesystem for PostgreSQL? mudfoot 09:56
Re: JFS fastest filesystem for PostgreSQL? Michael Stone 10:30
Re: Slow Query Ragnar Hafstað 11:22
Re: JFS fastest filesystem for PostgreSQL? Grega Bremec 12:15
Re: JFS fastest filesystem for PostgreSQL? Michael Stone 13:20
Re: JFS fastest filesystem for PostgreSQL? Jeffrey W. Baker 13:27
Re: slow joining very large table to smaller ones John A Meinel 15:42
Re: Quad Opteron stuck in the mud Alvaro Herrera 15:47
Re: Quad Opteron stuck in the mud Dan Harris 16:05
Re: lots of updates on small table Alvaro Herrera 16:21
Re: lots of updates on small table Rod Taylor 16:37
Re: large table vs multiple smal tables Jim C. Nasby 18:26
Re: JFS fastest filesystem for PostgreSQL? Jim C. Nasby 18:29
Re: JFS fastest filesystem for PostgreSQL? Joshua D. Drake 18:37
Re: Quad Opteron stuck in the mud Greg Stark 20:47
Re: Profiler for PostgreSQL Simon Riggs 20:47
Re: slow joining very large table to smaller ones Dan Harris 22:29
Re: slow joining very large table to smaller ones John A Meinel 22:46
Re: slow joining very large table to smaller ones Michael Stone 22:47

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 25 26 27 28 29 30 31