pgsql-performance - February 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 13 14 15 16 17 18 19 20 21 23 24 25 26 27 28

Feb. 1, 2011

Thread Author Time
Re: Questions on query planner, join types, and work_mem 📎 Bruce Momjian 03:17
Re: Configuration for a new server. Greg Smith 11:53
Re: postgres 9 query performance Ross J. Reedstrom 16:42
Re: Configuration for a new server. Benjamin Krajmalnik 16:46
Re: Configuration for a new server. Benjamin Krajmalnik 17:22
Exhaustive list of what takes what locks Nikolas Everett 19:18
Re: Any experience using "shake" defragmenter? Greg Smith 19:24
Re: Any experience using "shake" defragmenter? Jon Nelson 19:38
Re: Questions on query planner, join types, and work_mem Bruce Momjian 20:24
Re: Any experience using "shake" defragmenter? Grant Johnson 20:31
Re: Any experience using "shake" defragmenter? Robert Haas 22:33
Re: [PERFORM] Slow count(*) again... Bruce Momjian 22:47
Re: [PERFORM] Slow count(*) again... Andrew Dunstan 23:03
Re: [PERFORM] Slow count(*) again... Tom Lane 23:12
Re: [PERFORM] Slow count(*) again... Mladen Gogala 23:21
Re: Bloat issue on 8.3; autovac ignores HOT new pages? Mark Kirkwood 23:37
Re: [HACKERS] Slow count(*) again... Mladen Gogala 23:44
Re: Any experience using "shake" defragmenter? Mark Kirkwood 23:50

Feb. 2, 2011

Thread Author Time
Are we in the ballpark? Wayne Conrad 00:23
Re: Configuration for a new server. Greg Smith 01:16
Re: Are we in the ballpark? Greg Smith 01:30
Re: [HACKERS] Slow count(*) again... Samuel Gendler 03:13
Re: [HACKERS] Slow count(*) again... Mladen Gogala 03:40
Re: [HACKERS] Slow count(*) again... Samuel Gendler 04:07
Re: Exhaustive list of what takes what locks Noah Misch 05:20
About pg_stat_activity Cesar Arrieta 15:21
Re: [PERFORM] Slow count(*) again... Bruce Momjian 16:03
monitoring querys Re: About pg_stat_activity Jens Wilke 16:03
Re: Are we in the ballpark? Wayne Conrad 17:06
Re: About pg_stat_activity Maciek Sakrejda 17:15
Re: [HACKERS] Slow count(*) again... Robert Haas 17:19
Re: About pg_stat_activity Greg Smith 17:24
Re: Configuration for a new server. Benjamin Krajmalnik 17:46
Re: [HACKERS] Slow count(*) again... Mladen Gogala 18:11
Server Configuration Cesar Arrieta 18:15
Re: [HACKERS] Slow count(*) again... Jon Nelson 18:19
Re: [HACKERS] Slow count(*) again... Robert Haas 18:20
Re: Configuration for a new server. Greg Smith 18:22
Re: Server Configuration Kenneth Marshall 18:32
Re: [HACKERS] Slow count(*) again... Robert Haas 18:32
Re: [HACKERS] Slow count(*) again... Greg Smith 18:47
Re: Exhaustive list of what takes what locks Greg Smith 18:58
Re: Server Configuration Richard Carnes 19:11
[Fwd: Re: [HACKERS] Slow count(*) again...] Mladen Gogala 19:31
Re: Are we in the ballpark? John Rouillard 19:51
Re: Exhaustive list of what takes what locks Nikolas Everett 19:53
Re: Exhaustive list of what takes what locks Nikolas Everett 20:29
Re: [HACKERS] Slow count(*) again... Mladen Gogala 20:54
Re: [HACKERS] Slow count(*) again... Bruce Momjian 21:11
Re: [HACKERS] Slow count(*) again... Kenneth Marshall 21:14
Re: [HACKERS] Slow count(*) again... Kevin Grittner 21:16
Re: [HACKERS] Slow count(*) again... Robert Haas 21:19
Re: [HACKERS] Slow count(*) again... Justin Pitts 21:25
Re: [HACKERS] Slow count(*) again... Mladen Gogala 21:59
Re: [HACKERS] Slow count(*) again... Mladen Gogala 22:03
Re: Exhaustive list of what takes what locks Nikolas Everett 22:12
Which RAID Controllers to pick/avoid? Dan Birken 23:15

Feb. 3, 2011

Thread Author Time
Re: [HACKERS] Slow count(*) again... Greg Smith 00:03
Re: [HACKERS] Slow count(*) again... Bruce Momjian 00:13
Re: [HACKERS] Slow count(*) again... Greg Smith 00:17
Re: [HACKERS] Slow count(*) again... Andrew Dunstan 00:25
Re: [HACKERS] Slow count(*) again... Justin Pitts 00:29
Re: [HACKERS] Slow count(*) again... Bruce Momjian 01:19
Re: Which RAID Controllers to pick/avoid? Craig Ringer 02:00
Re: [HACKERS] Slow count(*) again... Robert Haas 02:01
Re: Server Configuration Marcos Ortiz 02:19
Re: [HACKERS] Slow count(*) again... Mladen Gogala 02:45
Re: Which RAID Controllers to pick/avoid? Greg Smith 05:46
Re: Which RAID Controllers to pick/avoid? Scott Marlowe 05:58
Re: Which RAID Controllers to pick/avoid? Scott Marlowe 06:02
Re: Which RAID Controllers to pick/avoid? Greg Smith 06:15
Re: [HACKERS] Slow count(*) again... Greg Smith 06:16
Re: Which RAID Controllers to pick/avoid? Dan Birken 06:30
Re: Which RAID Controllers to pick/avoid? Scott Marlowe 06:31
Re: Which RAID Controllers to pick/avoid? Magnus Hagander 06:45
Re: Which RAID Controllers to pick/avoid? Joachim Worringen 08:11
Re: Which RAID Controllers to pick/avoid? Glyn Astill 09:54
Re: [HACKERS] Slow count(*) again... Vitalii Tymchyshyn 09:54
Re: [HACKERS] Slow count(*) again... david 10:11
Get master-detail relationship metadata Laszlo Nagy 11:40
Re: [HACKERS] Slow count(*) again... Kenneth Marshall 13:41
Re: [HACKERS] Slow count(*) again... Jon Nelson 14:20
Re: Which RAID Controllers to pick/avoid? Mario Weilguni 14:57
Re: Which RAID Controllers to pick/avoid? Greg Smith 15:02
getting the most of out multi-core systems for repeated complex SELECT statements Mark Stosberg 15:08
Re: Get master-detail relationship metadata Andy Colson 15:26
Re: [HACKERS] Slow count(*) again... Robert Haas 15:31
Re: [HACKERS] Slow count(*) again... Robert Haas 15:35
Re: [HACKERS] Slow count(*) again... Vitalii Tymchyshyn 15:43
Re: getting the most of out multi-core systems for repeated complex SELECT statements Andy Colson 15:44
Re: getting the most of out multi-core systems for repeated complex SELECT statements Oleg Bartunov 15:54
Re: getting the most of out multi-core systems for repeated complex SELECT statements gnuoytr 15:57
Re: getting the most of out multi-core systems for repeated complex SELECT statements Mark Stosberg 16:16
Re: [HACKERS] Slow count(*) again... Mladen Gogala 16:38
Re: [HACKERS] Slow count(*) again... Bruce Momjian 16:56
Re: [HACKERS] Slow count(*) again... Bruce Momjian 16:57
Re: [HACKERS] Slow count(*) again... Shaun Thomas 17:10
Re: [HACKERS] Slow count(*) again... Tom Lane 17:27
Re: [HACKERS] Slow count(*) again... Robert Haas 17:28
Re: FW: Queries becoming slow under heavy load Anne Rosset 17:40
Re: [HACKERS] Slow count(*) again... Chris Browne 17:44
Re: [HACKERS] Slow count(*) again... Tom Lane 17:46
Re: Exhaustive list of what takes what locks Robert Haas 17:52
Re: getting the most of out multi-core systems for repeated complex SELECT statements Aljoša Mohorović 17:56
Re: High load, Robert Haas 18:04
Re: [HACKERS] Slow count(*) again... Greg Smith 18:17
Re: getting the most of out multi-core systems for repeated complex SELECT statements Scott Marlowe 18:21
Re: FW: Queries becoming slow under heavy load Scott Marlowe 18:22
Re: How to best use 32 15k.7 300GB drives? Robert Haas 18:42
Re: How to best use 32 15k.7 300GB drives? Dave Crooke 19:06
Re: [HACKERS] Slow count(*) again... Mladen Gogala 19:09
Re: getting the most of out multi-core systems for repeated complex SELECT statements gnuoytr 19:21
Re: [HACKERS] Slow count(*) again... Ross J. Reedstrom 19:24
Re: [HACKERS] Slow count(*) again... david 20:54
Re: [HACKERS] Slow count(*) again... Mladen Gogala 21:01
Re: [HACKERS] Slow count(*) again... Chris Browne 21:18
Re: [HACKERS] Slow count(*) again... Kevin Grittner 21:29
Re: [HACKERS] Slow count(*) again... Shaun Thomas 21:34
Re: [HACKERS] Slow count(*) again... Mladen Gogala 21:50
Re: [HACKERS] Slow count(*) again... Mark Kirkwood 21:51
Re: [HACKERS] Slow count(*) again... Mladen Gogala 22:03
Re: [HACKERS] Slow count(*) again... Ben Chobot 22:04
Re: [HACKERS] Slow count(*) again... Pavel Stehule 22:05
Re: [HACKERS] Slow count(*) again... Josh Berkus 22:08
Re: [HACKERS] Slow count(*) again... Maciek Sakrejda 22:09
Re: [HACKERS] Slow count(*) again... Pavel Stehule 22:10
Re: [HACKERS] Slow count(*) again... Mladen Gogala 22:12
Re: [HACKERS] Slow count(*) again... Mladen Gogala 22:13
Re: [HACKERS] Slow count(*) again... Mark Kirkwood 22:17
Re: [HACKERS] Slow count(*) again... Michael Glaesemann 22:19
Re: [HACKERS] Slow count(*) again... Greg Smith 22:35
Re: [HACKERS] Slow count(*) again... Mladen Gogala 22:39
Re: [HACKERS] Slow count(*) again... Mladen Gogala 22:40
Re: getting the most of out multi-core systems for repeated complex SELECT statements Greg Smith 22:56
Re: [HACKERS] Slow count(*) again... Josh Berkus 23:00
Re: [HACKERS] Slow count(*) again... Kevin Grittner 23:00
Re: [HACKERS] Slow count(*) again... Mladen Gogala 23:25
Re: [HACKERS] Slow count(*) again... Robert Haas 23:29
Re: [HACKERS] Slow count(*) again... Mladen Gogala 23:33
Re: [HACKERS] Slow count(*) again... Joshua D. Drake 23:56

Feb. 4, 2011

Thread Author Time
Re: [HACKERS] Slow count(*) again... Craig James 00:08
Re: [HACKERS] Slow count(*) again... Robert Haas 00:08
Re: [HACKERS] Slow count(*) again... Mladen Gogala 00:13
Re: [HACKERS] Slow count(*) again... Jeremy Harris 00:29
Re: [HACKERS] Slow count(*) again... Shaun Thomas 00:30
Re: [HACKERS] Slow count(*) again... david 00:39
Re: [HACKERS] Slow count(*) again... Mladen Gogala 00:39
Re: [HACKERS] Slow count(*) again... Jeremy Harris 00:49
Re: [HACKERS] Slow count(*) again... Grant Johnson 01:18
Re: [HACKERS] Slow count(*) again... Mark Kirkwood 01:28
Re: [HACKERS] Slow count(*) again... Robert Haas 01:29
Re: [HACKERS] Slow count(*) again... Robert Haas 01:36
Re: [HACKERS] Slow count(*) again... david 01:37
Re: [HACKERS] Slow count(*) again... Robert Haas 02:05
Re: [HACKERS] Slow count(*) again... Conor Walsh 02:12
Re: [HACKERS] Slow count(*) again... Joshua D. Drake 02:33
Re: [HACKERS] Slow count(*) again... Conor Walsh 02:45
Re: [HACKERS] Slow count(*) again... Scott Marlowe 02:59
Re: [HACKERS] Slow count(*) again... Jeff Davis 03:01
Re: [HACKERS] Slow count(*) again... Scott Marlowe 03:13
Re: getting the most of out multi-core systems for repeated complex SELECT statements Andy Colson 03:21
Re: [PERFORM] pgbench to the MAXINT Greg Smith 03:28
Does auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...) Mark Mielke 03:31
Re: [HACKERS] Slow count(*) again... Greg Smith 03:40
Re: [HACKERS] Slow count(*) again... Scott Marlowe 03:48
Re: [HACKERS] Slow count(*) again... Greg Smith 03:56
Re: [HACKERS] Slow count(*) again... Scott Marlowe 04:00
Re: getting the most of out multi-core systems for repeated complex SELECT statements Greg Smith 04:00
Re: getting the most of out multi-core systems for repeated complex SELECT statements Scott Marlowe 04:04
Re: [HACKERS] Slow count(*) again... Greg Smith 04:10
Re: getting the most of out multi-core systems for repeated complex SELECT statements Andy Colson 04:19
Re: getting the most of out multi-core systems for repeated complex SELECT statements Scott Marlowe 04:57
Re: [HACKERS] Slow count(*) again... David Wilson 05:06
Re: [HACKERS] Slow count(*) again... Samuel Gendler 06:36
Re: [HACKERS] Slow count(*) again... Віталій Тимчишин 07:08
Re: [HACKERS] Slow count(*) again... Віталій Тимчишин 07:24
Re: [HACKERS] Slow count(*) again... david 07:32
Re: [HACKERS] Slow count(*) again... Віталій Тимчишин 07:39
Re: [HACKERS] Slow count(*) again... Andrew Dunstan 07:59
Talking about optimizer, my long dream Віталій Тимчишин 08:03
Re: [HACKERS] Slow count(*) again... Torsten Zühlsdorff 08:43
Re: How to best use 32 15k.7 300GB drives? Vitalii Tymchyshyn 09:19
Re: getting the most of out multi-core systems for repeated complex SELECT statements Greg Smith 11:33
Query performance with disabled hashjoin and mergejoin Ivan Voras 12:08
Re: [HACKERS] Slow count(*) again... Grant Johnson 13:05
Re: Talking about optimizer, my long dream Mladen Gogala 13:56
Re: Talking about optimizer, my long dream Shaun Thomas 14:02
Re: Talking about optimizer, my long dream Frank Heikens 14:24
Re: Talking about optimizer, my long dream Greg Smith 14:27
Re: [HACKERS] Slow count(*) again... Kenneth Marshall 14:33
Re: Talking about optimizer, my long dream Mladen Gogala 14:36
Re: [HACKERS] Slow count(*) again... Vitalii Tymchyshyn 14:38
Re: Query performance with disabled hashjoin and mergejoin Greg Smith 14:44
Really really slow select count(*) felix 14:46
Re: Really really slow select count(*) hubert depesz lubaczewski 14:49
Re: [HACKERS] Slow count(*) again... Kenneth Marshall 14:52
Re: [HACKERS] Slow count(*) again... Nick Lello 14:55
Re: Really really slow select count(*) Greg Smith 14:56
Re: Really really slow select count(*) Shaun Thomas 15:00
Re: Really really slow select count(*) Shaun Thomas 15:03

Browse Archives

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