pgsql-performance - May 2007

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

May 1, 2007

Thread Author Time
Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus 16:23
Re: sytem log audit/reporting and psql Andreas Haumer 17:05
Re: index structure for 114-dimension vector 📎 Andrew Lazarus 18:09
Re: index structure for 114-dimension vector Alexander Staubo 20:27
Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno 23:40
Re: Feature Request --- was: PostgreSQL Performance Tuning david 23:48

May 2, 2007

Thread Author Time
Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith 01:52
Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith 02:59
Re: Feature Request --- was: PostgreSQL Performance Tuning david 04:34
Intermitent slow queries Parks, Aaron B. 15:24
Re: Intermitent slow queries Dave Cramer 18:17
Re: Intermitent slow queries Ron 18:55
Re: Intermitent slow queries Steinar H. Gunderson 18:59
Re: Intermitent slow queries Parks, Aaron B. 19:04
Re: Intermitent slow queries Parks, Aaron B. 19:07

May 3, 2007

Thread Author Time
Join vs Subquery Brian Herlihy 06:07
Re: Intermitent slow queries Ron 09:18
Re: Join vs Subquery Gregory Stark 11:46
Re: Join vs Subquery Tom Lane 14:23
pg_stat_* collection Greg Smith 14:45
Re: pg_stat_* collection Alexander Staubo 14:52
Re: Query performance problems with partitioned tables Fei Liu 15:02
Re: pg_stat_* collection Magnus Hagander 15:03
Re: Feature request - have postgresql log warning when new sub-release comes out. Leif B. Kristensen 15:18
Re: pg_stat_* collection Tobias Brox 16:16
Re: pg_stat_* collection Jeff Davis 18:21
Re: Feature Request --- was: PostgreSQL Performance Tuning Ron 19:15
Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus 19:21
Re: Feature Request --- was: PostgreSQL Performance Tunin g Dave Page 19:43
Re: Feature Request --- was: PostgreSQL Performance Tuning david 20:16
Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno 21:06
Re: Feature Request --- was: PostgreSQL Performance Tuning david 21:23
Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno 22:42
Re: Feature Request --- was: PostgreSQL Performance Tuning david 22:49

May 4, 2007

Thread Author Time
Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno 00:23
Re: Feature Request --- was: PostgreSQL Performance Tuning david 00:52
Re: Feature Request --- was: PostgreSQL Performance Tuning Carlos Moreno 01:13
Re: Feature Request --- was: PostgreSQL Performance Tuning david 01:52
Re: Query performance problems with partitioned tables Merlin Moncure 02:37
Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith 04:33
Re: pg_stat_* collection Greg Smith 04:53
Re: pg_stat_* collection Tobias Brox 05:08
Re: Feature Request --- was: PostgreSQL Performance Tuning Michael Stone 12:45
Re: pg_stat_* collection Michael Stone 12:47
Index not being used in sorting of simple table Paul Smith 14:36
Re: Query performance problems with partitioned tables Scott Marlowe 15:11
Re: Index not being used in sorting of simple table Heikki Linnakangas 15:26
Re: Index not being used in sorting of simple table Tom Lane 15:43
Re: Index not being used in sorting of simple table Paul Smith 16:10
Re: Feature Request --- was: PostgreSQL Performance Tuning Sebastian Hennebrueder 16:40
Re: Query performance problems with partitioned tables Merlin Moncure 17:10
Re: Feature Request --- was: PostgreSQL Performance Tuning Josh Berkus 17:11
Re: Feature Request --- was: PostgreSQL Performance Tuning Sebastian Hennebrueder 17:22

May 5, 2007

Thread Author Time
Re: Feature Request --- was: PostgreSQL Performance Tuning Greg Smith 01:07
Re: Feature Request --- was: PostgreSQL Performance Tuning Mark Kirkwood 07:19
Re: Feature Request --- was: PostgreSQL Performance Tuning Steinar H. Gunderson 09:30
Re: Feature Request --- was: PostgreSQL Performance Tuning Sebastian Hennebrueder 15:54
How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu 22:57
Re: How to Find Cause of Long Vacuum Times - NOOB Question Steinar H. Gunderson 23:40

May 6, 2007

Thread Author Time
Re: How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu 04:52
Re: Feature Request --- was: PostgreSQL Performance Tuning Jim Nasby 05:38
Re: Feature Request --- was: PostgreSQL Performance Tuning Andreas Kostyrka 07:06
Re: How to Find Cause of Long Vacuum Times - NOOB Question Heikki Linnakangas 08:15
Re: How to Find Cause of Long Vacuum Times - NOOB Question Steinar H. Gunderson 09:17
Re: How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu 09:35
Re: Index not being used in sorting of simple table Robins 12:37

May 7, 2007

Thread Author Time
Re: Index not being used in sorting of simple table Tom Lane 00:35
Merging large volumes of data Ambrus Wagner (IJ/ETH) 13:05
Re: Merging large volumes of data Andreas Kostyrka 13:44
Re: Merging large volumes of data Gregory Stark 14:24
Re: Merging large volumes of data Tom Lane 15:09
Re: How to Find Cause of Long Vacuum Times - NOOB Question Jim Nasby 15:54
Best OS for Postgres 8.2 David Levy 21:55
Re: Best OS for Postgres 8.2 Joshua D. Drake 21:59
Re: Best OS for Postgres 8.2 Bill Moran 22:04
Re: Best OS for Postgres 8.2 Joshua D. Drake 22:14
Re: Best OS for Postgres 8.2 Steve Atkins 22:57

May 8, 2007

Thread Author Time
Re: Best OS for Postgres 8.2 Chris 00:40
Re: Best OS for Postgres 8.2 david 00:53
Re: Best OS for Postgres 8.2 Chris 01:14
Re: Best OS for Postgres 8.2 Ron 03:41
Re: Best OS for Postgres 8.2 Greg Smith 03:56
Re: How to Find Cause of Long Vacuum Times - NOOB Question Yudhvir Singh Sidhu 04:10
Re: Best OS for Postgres 8.2 Tom Lane 04:37
Re: Best OS for Postgres 8.2 李彦 Ian Li 04:41
Re: Best OS for Postgres 8.2 david 07:59
Re: Best OS for Postgres 8.2 Heikki Linnakangas 08:21
Re: Best OS for Postgres 8.2 Claus Guttesen 08:22
Re: Best OS for Postgres 8.2 david 08:45
Re: Best OS for Postgres 8.2 Trygve Laugstøl 08:49
Re: Best OS for Postgres 8.2 Steinar H. Gunderson 09:35
truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas 09:43
Re: Best OS for Postgres 8.2 Alexander Staubo 09:43
Re: Best OS for Postgres 8.2 Steinar H. Gunderson 09:48
Re: truncate a table instead of vaccum full when count(*) is 0 ismo.tuononen 10:00
Re: truncate a table instead of vaccum full when count(*) is 0 Guillaume Cottenceau 10:02
Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas 10:07
Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas 10:09
Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas 10:13
Re: Best OS for Postgres 8.2 david 10:16
Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas 10:23
Re: Best OS for Postgres 8.2 david 10:27
Re: Best OS for Postgres 8.2 Trygve Laugstøl 10:29
Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas 10:37
Re: truncate a table instead of vaccum full when count(*) is 0 Gregory Stark 10:50
Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas 10:52
Re: [OT] Best OS for Postgres 8.2 C. Bergström 10:55
Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas 10:59
Re: truncate a table instead of vaccum full when count(*) is 0 Guillaume Cottenceau 11:06
Re: truncate a table instead of vaccum full when count(*) is 0 Heikki Linnakangas 11:19
Re: Best OS for Postgres 8.2 Luke Lonergan 12:01
estimating the need for VACUUM FULL and REINDEX Guillaume Cottenceau 12:08
Re: [OT] Best OS for Postgres 8.2 Adam Tauno Williams 12:25
Re: estimating the need for VACUUM FULL and REINDEX Heikki Linnakangas 12:40
Re: estimating the need for VACUUM FULL and REINDEX Bill Moran 12:46
specific query (not all) on Pg8 MUCH slower than Pg7 Susan Russo 14:18
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Tom Lane 14:48
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Steinar H. Gunderson 14:48
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Richard Broersma Jr 14:54
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Alexander Staubo 14:59
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Bill Moran 15:04
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Tom Lane 15:05
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Susan Russo 15:19
Nested loops overpriced Peter Eisentraut 15:22
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Alvaro Herrera 15:34
Re: Nested loops overpriced Tom Lane 15:53
Re: Best OS for Postgres 8.2 Ron 16:08
Re: specific query (not all) on Pg8 MUCH slower than Pg7 Tom Lane 16:09
Re: Best OS for Postgres 8.2 李彦 Ian Li 16:58
Re: truncate a table instead of vaccum full when count(*) is 0 Pomarede Nicolas 17:31
Re: Query performance problems with partitioned tables Fei Liu 18:41
Re: Query performance problems with partitioned tables Scott Marlowe 18:58
DISTINCT Question Y Sidhu 19:52
Re: DISTINCT Question Steinar H. Gunderson 19:55
Re: DISTINCT Question Joshua D. Drake 19:57
Throttling PostgreSQL's CPU usage Daniel Griscom 20:27
Re: DISTINCT Question Scott Marlowe 20:28
Re: Best OS for Postgres 8.2 Charles Sprickman 20:49
Re: Throttling PostgreSQL's CPU usage Steinar H. Gunderson 20:51
Re: Throttling PostgreSQL's CPU usage Bill Moran 20:55
Re: Throttling PostgreSQL's CPU usage david 20:59
Re: Throttling PostgreSQL's CPU usage Mark Lewis 21:10
What's The Difference Between VACUUM and VACUUM ANALYZE? Y Sidhu 21:43
Re: What's The Difference Between VACUUM and VACUUM ANALYZE? david 21:46
Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Alvaro Herrera 21:52
Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Steinar H. Gunderson 22:06
Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Alvaro Herrera 22:21
Re: Throttling PostgreSQL's CPU usage Carlos Moreno 22:32
Re: Throttling PostgreSQL's CPU usage Joshua D. Drake 22:39
Re: Throttling PostgreSQL's CPU usage Steinar H. Gunderson 22:40
Re: Throttling PostgreSQL's CPU usage Carlos Moreno 22:46
[No subject] Orhan Aglagul 22:59
Re: Throttling PostgreSQL's CPU usage Daniel Griscom 23:03
Re: Throttling PostgreSQL's CPU usage Steinar H. Gunderson 23:09
Re: Throttling PostgreSQL's CPU usage david 23:21
Re: Throttling PostgreSQL's CPU usage Carlos Moreno 23:22
Re: Throttling PostgreSQL's CPU usage david 23:24
Re: Dan Harris 23:48

May 9, 2007

Thread Author Time
Re: Joshua D. Drake 00:05
Re: Carlos Moreno 00:20
Re: Scott Marlowe 00:22
Re: Scott Marlowe 00:30
Re: Orhan Aglagul 01:12
FW: Orhan Aglagul 01:13
FW: Orhan Aglagul 01:13
FW: Orhan Aglagul 01:14
Re: FW: david 01:22
Re: Best OS for Postgres 8.2 Greg Smith 03:31
Re: Best OS for Postgres 8.2 Greg Smith 03:51
Re: Throttling PostgreSQL's CPU usage Luke Lonergan 04:09
Re: Greg Smith 04:14
Re: Robert Treat 04:58
Re: Throttling PostgreSQL's CPU usage Magnus Hagander 05:56
Re: Best OS for Postgres 8.2 david 08:57
Re: estimating the need for VACUUM FULL and REINDEX Guillaume Cottenceau 09:18
Re: Best OS for Postgres 8.2 Steinar H. Gunderson 09:38
Re: Best OS for Postgres 8.2 david 09:44
Re: What's The Difference Between VACUUM and VACUUM ANALYZE? Gregory Stark 11:31
Re: FW: Gregory Stark 11:36
Re: Nested loops overpriced Peter Eisentraut 11:58
Apparently useless bitmap scans Peter Eisentraut 12:10
Cannot make GIN intarray index be used by the planner Valentine Gogichashvili 13:12
Poor performance with queries using clause: sth IN (...) Andrzej Zawadzki 13:22
Re: Cannot make GIN intarray index be used by the planner Oleg Bartunov 13:31
Re: Cannot make GIN intarray index be used by the planner Valentine Gogichashvili 13:36
Re: Nested loops overpriced Daniel Cristian Cruz 13:38
Re: Throttling PostgreSQL's CPU usage Daniel Griscom 13:49
Re: Cannot make GIN intarray index be used by the planner Oleg Bartunov 13:49
Re: Nested loops overpriced Tom Lane 14:11
Re: Apparently useless bitmap scans Alvaro Herrera 14:29
Re: Throttling PostgreSQL's CPU usage Carlos Moreno 14:29
Re: Poor performance with queries using clause: sth IN (...) Gregory Stark 14:29
Re: Nested loops overpriced Gregory Stark 14:34
Re: Apparently useless bitmap scans Tom Lane 14:49
Re: Nested loops overpriced Daniel Cristian Cruz 14:51
Re: Apparently useless bitmap scans Peter Eisentraut 15:26
Re: Apparently useless bitmap scans Tom Lane 15:56
Re: Nested loops overpriced Peter Eisentraut 16:17
ZFS and Postgresql - WASRe: Best OS for Postgres 8.2 Jignesh Shah 16:27
Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2 Alvaro Herrera 17:01

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