Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-performance - February 2011

2011-02-01

• 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)

2011-02-02

• 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)

2011-02-03

• 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)

2011-02-04

• 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)