pgsql-performance - April 2011

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 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 1, 2011

Thread Author Time
index usage on queries on inherited tables Joseph Shraibman 00:41
table contraints checks only happen in planner phase Joseph Shraibman 00:41
Re: good old VACUUM FULL Craig Ringer 03:41
Re: COPY with high # of clients, partitioned table locking issues? Greg Smith 06:50
Re: table contraints checks only happen in planner phase Josh Berkus 17:32

April 2, 2011

Thread Author Time
C on Client versus C on Server Eliot Gable 18:52

April 3, 2011

Thread Author Time
Re: C on Client versus C on Server Heikki Linnakangas 07:01

April 4, 2011

Thread Author Time
Re: very long updates very small tables Lars Feistner 08:11
Postgres Performance Tuning 📎 Adarsh Sharma 09:40
Re: Postgres Performance Tuning tv 10:28
Re: Postgres Performance Tuning Adarsh Sharma 10:39
Re: Postgres Performance Tuning Scott Marlowe 10:43
Re: Postgres Performance Tuning Sethu Prasad 10:52
Re: Postgres Performance Tuning Scott Marlowe 10:54
Re: Postgres Performance Tuning Raghavendra 10:56
Re: Postgres Performance Tuning Adarsh Sharma 11:34
Re: Postgres Performance Tuning Scott Marlowe 11:43
Re: Postgres Performance Tuning Adarsh Sharma 11:51
Re: Postgres Performance Tuning Achilleas Mantzios 12:14
Re: Postgres Performance Tuning Scott Marlowe 12:14
Re: Postgres Performance Tuning tv 12:28
Re: Postgres Performance Tuning Raghavendra 12:30
Re: Postgres Performance Tuning Adarsh Sharma 12:33
Re: very long updates very small tables Kevin Grittner 14:32
Re: Postgres Performance Tuning Scott Marlowe 16:22

April 5, 2011

Thread Author Time
Re: Intel SSDs that may not suck Greg Smith 01:26
Re: Postgres Performance Tuning Adarsh Sharma 07:33
Which is better Index Adarsh Sharma 10:26
Re: Postgres Performance Tuning Ákos Gábriel 12:31
Re: Postgres Performance Tuning Ákos Gábriel 12:38
Re: Postgres Performance Tuning Scott Marlowe 13:08
Re: Postgres Performance Tuning Adarsh Sharma 13:20
Re: Postgres Performance Tuning Scott Marlowe 13:49
Re: Which is better Index Chetan Suttraway 14:07
Re: Intel SSDs that may not suck Merlin Moncure 14:07
help speeding up a query in postgres 8.4.5 Maria L. Wilson 19:25
Partial index slower than regular index Thom Brown 22:35
Re: Partial index slower than regular index Kenneth Marshall 23:02
Re: Partial index slower than regular index Scott Marlowe 23:31
Re: Partial index slower than regular index Mark Kirkwood 23:40

April 6, 2011

Thread Author Time
Re: Partial index slower than regular index Mark Kirkwood 02:03
Re: Partial index slower than regular index Tom Lane 04:44
Re: Which is better Index Greg Smith 06:55
Re: Partial index slower than regular index Thom Brown 08:15
Re: Partial index slower than regular index Thom Brown 08:33
Re: help speeding up a query in postgres 8.4.5 Szymon Guz 11:41
Re: help speeding up a query in postgres 8.4.5 tv 13:16
Re: help speeding up a query in postgres 8.4.5 Maria L. Wilson 13:33
Re: help speeding up a query in postgres 8.4.5 Maria L. Wilson 13:36
Re: help speeding up a query in postgres 8.4.5 Kevin Grittner 15:33
Re: help speeding up a query in postgres 8.4.5 Maria L. Wilson 15:37
Re: help speeding up a query in postgres 8.4.5 Tomas Vondra 18:13
Re: very long updates very small tables Tomas Vondra 18:30
Re: Intel SSDs that may not suck Scott Carey 20:52
Re: Intel SSDs that may not suck Andy 21:11
Background fsck Ireneusz Pluta 22:33
Re: Background fsck Scott Marlowe 22:48
Re: Background fsck Ireneusz Pluta 22:59
Re: Intel SSDs that may not suck gnuoytr 23:03

April 7, 2011

Thread Author Time
Re: Intel SSDs that may not suck Scott Carey 00:05
Re: Intel SSDs that may not suck Scott Carey 00:10
Re: Intel SSDs that may not suck Scott Carey 00:20
Re: Intel SSDs that may not suck Scott Carey 00:22
Re: Intel SSDs that may not suck Scott Carey 00:42
Re: Intel SSDs that may not suck David Rees 01:07
Re: Intel SSDs that may not suck Greg Smith 01:32
Re: Intel SSDs that may not suck Greg Smith 02:21
Re: Intel SSDs that may not suck David Boreham 02:56
Re: Intel SSDs that may not suck gnuoytr 03:19
Re: Intel SSDs that may not suck David Boreham 03:52
Re: Intel SSDs that may not suck Jesper Krogh 04:27
Re: Intel SSDs that may not suck Greg Smith 05:48
Re: Partial index slower than regular index Tom Lane 06:37
Re: Partial index slower than regular index Thom Brown 07:10
Re: Partial index slower than regular index Thom Brown 08:01
Re: Background fsck Ivan Voras 13:31
Re: Background fsck Achilleas Mantzios 14:01
Re: Background fsck Greg Smith 16:16
Re: Intel SSDs that may not suck Scott Carey 16:25

April 8, 2011

Thread Author Time
Re: Background fsck Ireneusz Pluta 05:55
Re: Background fsck Achilleas Mantzios 06:19
Re: Background fsck Scott Marlowe 06:22
Re: Background fsck Ireneusz Pluta 09:34
Re: Background fsck Ivan Voras 10:21
Re: Background fsck Ireneusz Pluta 11:52
Re: Background fsck Ireneusz Pluta 11:53
Re: Background fsck Achilleas Mantzios 12:14
[No subject] Whatever Deep 14:08
Re: Background fsck Jochen Erwied 14:32
postgresql benchmark Radhya sahal 14:44
Re: Why it is using/not using index scan? Merlin Moncure 15:45
Re: Background fsck Ireneusz Pluta 16:12

April 9, 2011

Thread Author Time
Slow query postgres 8.3 Anne Rosset 01:29
Re: Slow query postgres 8.3 tv 10:35
Re: Why it is using/not using index scan? Tomas Vondra 14:59
Multiple index builds on same table - in one sweep? Chris Ruprecht 16:28
Re: Multiple index builds on same table - in one sweep? Tom Lane 17:10
Re: Multiple index builds on same table - in one sweep? Chris Ruprecht 17:23

April 10, 2011

Thread Author Time
optimizer parameters Radhya sahal 18:22
Re: optimizer parameters Tomas Vondra 23:27

April 11, 2011

Thread Author Time
Re: Multiple index builds on same table - in one sweep? Greg Smith 02:29
Re: optimizer parameters Greg Smith 02:40
Re: Multiple index builds on same table - in one sweep? Scott Marlowe 05:35
Re: Multiple index builds on same table - in one sweep? Scott Marlowe 07:31
Re: Multiple index builds on same table - in one sweep? Greg Smith 07:41
Re: Multiple index builds on same table - in one sweep? Scott Marlowe 07:57
Linux: more cores = less concurrency. Glyn Astill 13:04
Postgres 9 slave lagging Saurabh Agrawal 14:10
Re: Multiple index builds on same table - in one sweep? 📎 Shaun Thomas 15:13
Re: Slow query postgres 8.3 Anne Rosset 16:07
Re: Slow query postgres 8.3 Kevin Grittner 16:59
Re: Linux: more cores = less concurrency. Kevin Grittner 18:09
Re: Linux: more cores = less concurrency. Joshua D. Drake 18:12
Re: Linux: more cores = less concurrency. Glyn Astill 18:23
Re: Linux: more cores = less concurrency. Scott Marlowe 18:32
Re: Multiple index builds on same table - in one sweep? Tom Lane 18:39
Re: Multiple index builds on same table - in one sweep? Scott Marlowe 18:39
Re: Linux: more cores = less concurrency. Scott Marlowe 19:29
Re: Linux: more cores = less concurrency. Glyn Astill 19:42
Re: Linux: more cores = less concurrency. Steve Clark 19:51
Re: Linux: more cores = less concurrency. Jesper Krogh 19:56
Re: Linux: more cores = less concurrency. david 20:04
Poor performance when joining against inherited tables Lucas Madar 20:11
Re: Linux: more cores = less concurrency. Glyn Astill 20:17
Re: Linux: more cores = less concurrency. James Cloos 20:39
Re: Linux: more cores = less concurrency. Scott Marlowe 20:52
Re: Linux: more cores = less concurrency. Kevin Grittner 21:06
Re: Linux: more cores = less concurrency. Glyn Astill 21:08
Re: Linux: more cores = less concurrency. Kevin Grittner 21:35
Re: Linux: more cores = less concurrency. David Rees 22:11
Re: Postgres 9 slave lagging Merlin Moncure 22:39
how explain works Radhya sahal 23:02
Re: how explain works Nathan Boley 23:09
Re: how explain works to Mr Nathan Boley Radhya sahal 23:22
Two servers - One Replicated - Same query Ozer, Pam 23:28

April 12, 2011

Thread Author Time
Re: Linux: more cores = less concurrency. mark 00:05
Re: Linux: more cores = less concurrency. Scott Marlowe 00:18
Re: Linux: more cores = less concurrency. Scott Marlowe 00:18
Re: Linux: more cores = less concurrency. mark 00:50
Re: Linux: more cores = less concurrency. Merlin Moncure 01:59
Re: Linux: more cores = less concurrency. Scott Marlowe 02:12
Re: Linux: more cores = less concurrency. Jesper Krogh 05:17
performance problem with LIMIT (order BY in DESC order). Wrong index used? Dieter Rehbein 05:20
Re: Linux: more cores = less concurrency. Scott Marlowe 05:55
Re: Linux: more cores = less concurrency. Arjen van der Meijden 07:31
Re: Slow query postgres 8.3 Claudio Freire 07:33
Re: performance problem with LIMIT (order BY in DESC order). Wrong index used? Claudio Freire 07:42
DBT-5 & Postgres 9.0.3 Sethu Prasad 07:51
Re: Linux: more cores = less concurrency. Glyn Astill 08:54
Re: Linux: more cores = less concurrency. Glyn Astill 08:57
Re: performance problem with LIMIT (order BY in DESC order). Wrong index used? Dieter Rehbein 08:59
Re: performance problem with LIMIT (order BY in DESC order). Wrong index used? Claudio Freire 09:07
Re: performance problem with LIMIT (order BY in DESC order). Wrong index used? tv 09:33
Re: performance problem with LIMIT (order BY in DESC order). Wrong index used? Dieter Rehbein 09:36
Re: Linux: more cores = less concurrency. Glyn Astill 12:35
Re: Poor performance when joining against inherited tables Shaun Thomas 13:22
Re: Linux: more cores = less concurrency. Merlin Moncure 13:23
Re: Linux: more cores = less concurrency. Merlin Moncure 13:24
Re: Two servers - One Replicated - Same query Kevin Grittner 14:32
Re: performance problem with LIMIT (order BY in DESC order). Wrong index used? Tom Lane 14:38
Re: Linux: more cores = less concurrency. Kevin Grittner 14:43
Re: Linux: more cores = less concurrency. Glyn Astill 16:01
Re: Linux: more cores = less concurrency. Glyn Astill 16:07
Re: Linux: more cores = less concurrency. Merlin Moncure 16:12
Performance Ogden 16:36
Re: Linux: more cores = less concurrency. Kevin Grittner 16:40
Re: Linux: more cores = less concurrency. Claudio Freire 16:43
Re: Linux: more cores = less concurrency. F. BROUARD / SQLpro 16:58
Re: Linux: more cores = less concurrency. Greg Smith 17:00
Re: Linux: more cores = less concurrency. Greg Smith 17:10
Re: Linux: more cores = less concurrency. Merlin Moncure 17:14
Re: Performance Andreas Kretschmer 17:18
Re: Performance Ogden 17:23
Re: Performance Tomas Vondra 18:16
Re: Performance Ogden 18:28
Re: Linux: more cores = less concurrency. Strange, John W 18:50
Re: Performance Tomas Vondra 21:09
Re: Performance Ogden 21:19
Re: Performance Tomas Vondra 22:36
poor execution plan because column dependence Václav Ovsík 23:23

April 13, 2011

Thread Author Time
Re: poor execution plan because column dependence Bob Lunney 00:14
Re: poor execution plan because column dependence Tom Lane 00:52
Re: poor execution plan because column dependence Václav Ovsík 07:55
Re: poor execution plan because column dependence Václav Ovsík 08:21
Re: Linux: more cores = less concurrency. Glyn Astill 09:48
Re: Performance Ogden 14:05
Re: Performance tv 14:14
Re: Performance Kevin Grittner 14:32
Re: poor execution plan because column dependence Tom Lane 16:24
Re: Linux: more cores = less concurrency. Scott Carey 16:33
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Scott Carey 17:07
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Scott Carey 17:22
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Tom Lane 17:35
Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? Scott Carey 18:27
Re: Slow query postgres 8.3 Tomas Vondra 20:16
Re: how explain works to Mr Nathan Boley Tomas Vondra 20:19
Re: Performance Claudio Freire 21:17
Re: Slow query postgres 8.3 Claudio Freire 21:37
Re: Performance Tom Lane 21:52
Re: Performance Claudio Freire 21:54

Browse Archives

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