Mailing lists [pgsql-performance]

1 February 2011

• 02:18   Re: Questions on query planner, join types, and work_mem Bruce Momjian
• 10:54   Re: Configuration for a new server. Greg Smith
• 15:08   Re: Any experience using "shake" defragmenter? Lew
• 15:48   Re: Configuration for a new server. Benjamin Krajmalnik
• 16:22   Re: Configuration for a new server. Benjamin Krajmalnik
• 16:24   Re: postgres 9 query performance Ross J. Reedstrom
• 18:19   Exhaustive list of what takes what locks Nikolas Everett
• 18:24   Re: Any experience using "shake" defragmenter? Greg Smith
• 19:02   Re: Any experience using "shake" defragmenter? Jon Nelson
• 19:24   Re: Questions on query planner, join types, and work_mem Bruce Momjian
• 19:32   Re: Any experience using "shake" defragmenter? Grant Johnson
• 21:33   Re: Any experience using "shake" defragmenter? Robert Haas
• 22:39   Re: Bloat issue on 8.3; autovac ignores HOT new pages? Mark Kirkwood
• 22:44   Re: [HACKERS] Slow count(*) again... Mladen Gogala
• 22:50   Re: Any experience using "shake" defragmenter? Mark Kirkwood
• 23:28   Are we in the ballpark? Wayne Conrad

2 February 2011

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

3 February 2011

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

4 February 2011

• 00:18   Re: [HACKERS] Slow count(*) again... Grant Johnson
• 00:28   Re: [HACKERS] Slow count(*) again... Mark Kirkwood
• 00:29   Re: [HACKERS] Slow count(*) again... Robert Haas
• 00:36   Re: [HACKERS] Slow count(*) again... Robert Haas
• 00:37   Re: [HACKERS] Slow count(*) again... david@lang.hm
• 00:46   Re: Why we don't want hints Was: Slow count(*) again... Josh Berkus
• 01:06   Re: [HACKERS] Slow count(*) again... Robert Haas
• 01:13   Re: [HACKERS] Slow count(*) again... Conor Walsh
• 01:33   Re: [HACKERS] Slow count(*) again... Joshua D. Drake
• 01:45   Re: [HACKERS] Slow count(*) again... Conor Walsh
• 01:59   Re: [HACKERS] Slow count(*) again... Scott Marlowe
• 02:08   Re: [HACKERS] Slow count(*) again... Jeff Davis
• 02:13   Re: [HACKERS] Slow count(*) again... Scott Marlowe
• 02:21   Re: getting the most of out multi-core systems for repeated complex SELECT statements Andy Colson
• 02:40   Re: [HACKERS] Slow count(*) again... Greg Smith
• 02:48   Does auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...) Mark Mielke
• 02:48   Re: [HACKERS] Slow count(*) again... Scott Marlowe
• 02:56   Re: [HACKERS] Slow count(*) again... Greg Smith
• 03:00   Re: [HACKERS] Slow count(*) again... Scott Marlowe
• 03:00   Re: getting the most of out multi-core systems for repeated complex SELECT statements Greg Smith
• 03:04   Re: getting the most of out multi-core systems for repeated complex SELECT statements Scott Marlowe
• 03:10   Re: [HACKERS] Slow count(*) again... Greg Smith
• 03:19   Re: getting the most of out multi-core systems for repeated complex SELECT statements Andy Colson
• 03:57   Re: getting the most of out multi-core systems for repeated complex SELECT statements Scott Marlowe
• 04:06   Re: [HACKERS] Slow count(*) again... David Wilson
• 05:36   Re: [HACKERS] Slow count(*) again... Samuel Gendler
• 06:09   Re: [HACKERS] Slow count(*) again... Віталій Тимчишин
• 06:24   Re: [HACKERS] Slow count(*) again... Віталій Тимчишин
• 06:33   Re: [HACKERS] Slow count(*) again... david@lang.hm
• 06:39   Re: [HACKERS] Slow count(*) again... Віталій Тимчишин
• 07:03   Talking about optimizer, my long dream Віталій Тимчишин
• 07:50   Re: [HACKERS] Slow count(*) again... Torsten Zühlsdorff
• 08:20   Re: How to best use 32 15k.7 300GB drives? Vitalii Tymchyshyn
• 10:34   Re: getting the most of out multi-core systems for repeated complex SELECT statements Greg Smith
• 11:08   Query performance with disabled hashjoin and mergejoin Ivan Voras
• 12:06   Re: [HACKERS] Slow count(*) again... Grant Johnson
• 12:56   Re: Talking about optimizer, my long dream Mladen Gogala
• 13:02   Re: Talking about optimizer, my long dream Shaun Thomas
• 13:28   Re: Talking about optimizer, my long dream Greg Smith
• 13:33   Re: [HACKERS] Slow count(*) again... Kenneth Marshall
• 13:36   Re: Talking about optimizer, my long dream Mladen Gogala
• 13:38   Re: [HACKERS] Slow count(*) again... Vitalii Tymchyshyn
• 13:45   Re: Query performance with disabled hashjoin and mergejoin Greg Smith
• 13:46   Really really slow select count(*) felix
• 13:49   Re: Really really slow select count(*) hubert depesz lubaczewski
• 13:52   Re: [HACKERS] Slow count(*) again... Kenneth Marshall
• 13:56   Re: Really really slow select count(*) Greg Smith
• 14:01   Re: Really really slow select count(*) Shaun Thomas
• 14:03   Re: Really really slow select count(*) Shaun Thomas
• 14:25   Re: Talking about optimizer, my long dream Frank Heikens
• 14:47   Re: Talking about optimizer, my long dream Cédric Villemain
• 15:05   Re: [HACKERS] Slow count(*) again... Scott Marlowe
• 15:19   Fwd: Really really slow select count(*) felix
• 15:20   Really really slow select count(*) felix
• 15:27   Re: Really really slow select count(*) Kenneth Marshall
• 15:35   Re: Really really slow select count(*) Shaun Thomas
• 15:35   Re: Really really slow select count(*) Shaun Thomas
• 16:38   Re: Really really slow select count(*) felix
• 16:40   Re: Really really slow select count(*) Scott Marlowe
• 16:45   Re: Really really slow select count(*) felix
• 16:45   Re: Really really slow select count(*) Shaun Thomas
• 17:29   Re: Really really slow select count(*) felix
• 17:35   Re: Really really slow select count(*) Scott Marlowe
• 17:36   Re: Really really slow select count(*) Shaun Thomas
• 17:38   Re: Really really slow select count(*) Greg Smith
• 17:48   Re: [HACKERS] Slow count(*) again... Robert Haas
• 17:49   Re: How to best use 32 15k.7 300GB drives? Robert Haas
• 18:01   Re: Really really slow select count(*) Scott Marlowe
• 18:08   Write-heavy pg_stats_collector on mostly idle server Josh Berkus
• 18:18   Re: Really really slow select count(*) Shaun Thomas
• 18:26   Re: Really really slow select count(*) felix
• 18:35   Re: Really really slow select count(*) Scott Marlowe
• 18:40   Re: Really really slow select count(*) Shaun Thomas
• 18:59   Re: Really really slow select count(*) felix
• 19:00   Re: Really really slow select count(*) Shaun Thomas
• 19:14   Re: Really really slow select count(*) felix
• 19:38   Re: Really really slow select count(*) Shaun Thomas
• 20:18   Re: getting the most of out multi-core systems for repeated complex SELECT statements Mark Stosberg
• 20:22   checkpoint_completion_target and Ext3 Josh Berkus
• 21:58   Re: Re: getting the most of out multi-core systems for repeated complex SELECT statements Scott Marlowe
• 21:59   Re: [HACKERS] Slow count(*) again... Bruce Momjian
• 22:17   Re: [HACKERS] Slow count(*) again... Bruce Momjian
• 22:25   table partitioning and select max(id) Tobias Brox
• 22:44   Re: Talking about optimizer, my long dream Mark Kirkwood
• 23:17   Re: [HACKERS] Slow count(*) again... Bruce Momjian
• 23:20   Re: getting the most of out multi-core systems for repeated complex SELECT statements Chris Browne

5 February 2011

• 00:48   Re: Does auto-analyze work on dirty writes? Mark Mielke
• 01:51   Re: Query performance with disabled hashjoin and mergejoin Ivan Voras
• 02:39   Re: table partitioning and select max(id) Ken Cox
• 03:45   Re: [HACKERS] Slow count(*) again... Scott Marlowe
• 03:54   Re: Talking about optimizer, my long dream Scott Marlowe
• 04:03   Re: table partitioning and select max(id) Greg Smith
• 04:38   Re: Talking about optimizer, my long dream Mark Kirkwood
• 04:46   Re: [HACKERS] Slow count(*) again... david@lang.hm
• 05:38   Re: [HACKERS] Slow count(*) again... Robert Haas
• 06:16   Re: getting the most of out multi-core systems for repeated complex SELECT statements david@lang.hm
• 07:16   Re: table partitioning and select max(id) Tobias Brox
• 07:38   Re: [HACKERS] Slow count(*) again... Scott Marlowe
• 07:49   Re: table partitioning and select max(id) Greg Smith
• 07:50   Re: [HACKERS] Slow count(*) again... Greg Smith
• 08:01   Re: How to best use 32 15k.7 300GB drives? Віталій Тимчишин
• 08:13   Re: Really really slow select count(*) Pierre C
• 21:15   Re: Write-heavy pg_stats_collector on mostly idle server Cédric Villemain

6 February 2011

• 07:04   Need some help analyzing some benchmarks Benjamin Krajmalnik
• 07:09   Re: checkpoint_completion_target and Ext3 Greg Smith
• 08:47   Re: Which RAID Controllers to pick/avoid? Royce Ausburn
• 08:55   Re: Which RAID Controllers to pick/avoid? Scott Marlowe
• 09:49   Re: Really really slow select count(*) felix
• 11:15   Re: Which RAID Controllers to pick/avoid? david@lang.hm
• 12:04   Re: Really really slow select count(*) Ray Stell
• 14:23   Re: Really really slow select count(*) Scott Marlowe
• 17:15   Re: copy command and blobs Greg Spiegelberg
• 17:23   general hardware advice Linos
• 18:02   Re: Really really slow select count(*) Scott Marlowe
• 18:05   Re: general hardware advice Scott Marlowe
• 18:19   Re: Really really slow select count(*) Pierre C
• 18:24   Re: Really really slow select count(*) Scott Marlowe
• 18:24   Re: general hardware advice Pierre C
• 18:32   Re: general hardware advice Linos
• 18:34   Re: general hardware advice Linos
• 19:38   Re: general hardware advice Andy
• 20:13   Re: [HACKERS] Slow count(*) again... Andrew Dunstan
• 20:14   Re: [HACKERS] Slow count(*) again... Nick Lello
• 20:14   Different execution plans for semantically equivalent queries Mikkel Lauritsen
• 20:14   Re: Query performance with disabled hashjoin and mergejoin Ivan Voras
• 20:14   Re: Talking about optimizer, my long dream Mladen Gogala
• 20:14   Re: Does auto-analyze work on dirty writes? (was: Re: [HACKERS] Slow count(*) again...) Tom Lane
• 20:29   Re: Different execution plans for semantically equivalent queries Tom Lane
• 22:35   Re: general hardware advice Linos

7 February 2011

• 00:37   Re: Need some help analyzing some benchmarks Greg Smith
• 00:52   Re: Really really slow select count(*) felix
• 00:56   Re: Really really slow select count(*) felix
• 02:05   Re: Really really slow select count(*) Craig Ringer
• 02:14   Re: Really really slow select count(*) Scott Marlowe
• 03:50   Re: Really really slow select count(*) Shaun Thomas
• 04:05   Re: Really really slow select count(*) Shaun Thomas
• 06:14   Re: Different execution plans for semantically equivalent queries Mikkel Lauritsen
• 06:52   Re: Really really slow select count(*) Greg Smith
• 07:32   Re: High load, Greg Smith
• 09:02   Re: getting the most of out multi-core systems for repeated complex SELECT statements Vitalii Tymchyshyn
• 09:37   Re: Really really slow select count(*) Marti Raudsepp
• 09:48   Re: Different execution plans for semantically equivalent queries Marti Raudsepp
• 14:05   Re: Really really slow select count(*) felix
• 17:42   Re: Really really slow select count(*) Scott Marlowe
• 18:06   Re: Really really slow select count(*) Greg Smith
• 21:59   Re: Write-heavy pg_stats_collector on mostly idle server Josh Berkus
• 22:13   Re: Write-heavy pg_stats_collector on mostly idle server Joshua D. Drake
• 22:25   Re: Write-heavy pg_stats_collector on mostly idle server Cédric Villemain
• 22:49   Re: Really really slow select count(*) Craig Ringer
• 22:56   Re: Really really slow select count(*) Craig Ringer
• 23:15   Indexes with condition using immutable functions applied to column not used Sylvain Rabot

8 February 2011

• 00:40   Re: Write-heavy pg_stats_collector on mostly idle server Josh Berkus
• 02:17   Re: Really really slow select count(*) felix
• 03:25   Re: Really really slow select count(*) Scott Marlowe
• 04:21   Re: Indexes with condition using immutable functions applied to column not used Jesper Krogh
• 06:26   Re: Talking about optimizer, my long dream Achilleas Mantzios
• 08:10   Re: Write-heavy pg_stats_collector on mostly idle server Jakub Ouhrabka
• 09:35   compare languages pasman pasmański
• 09:46   Re: compare languages Pavel Stehule
• 13:23   Re: Really really slow select count(*) Shaun Thomas
• 13:24   Bad query plan when the wrong data type is used Laszlo Nagy
• 15:23   Re: Really really slow select count(*) Maciek Sakrejda
• 15:36   Re: Really really slow select count(*) Kevin Grittner
• 15:58   Re: Really really slow select count(*) Marti Raudsepp
• 16:30   Re: Indexes with condition using immutable functions applied to column not used Sylvain Rabot
• 16:31   Re: Really really slow select count(*) Scott Marlowe
• 16:58   Re: Really really slow select count(*) Maciek Sakrejda
• 18:00   Re: Really really slow select count(*) Kevin Grittner
• 19:09   Re: Indexes with condition using immutable functions applied to column not used Sylvain Rabot
• 19:09   Re: Really really slow select count(*) Greg Smith
• 20:10   Re: Really really slow select count(*) Marti Raudsepp
• 20:20   Re: Really really slow select count(*) Kevin Grittner
• 20:41   Re: Really really slow select count(*) Scott Marlowe
• 20:52   Re: Really really slow select count(*) Kevin Grittner
• 21:05   Re: Bad query plan when the wrong data type is used Josh Berkus
• 21:08   Re: Really really slow select count(*) Greg Smith
• 21:14   Re: Really really slow select count(*) Scott Marlowe
• 22:14   Re: Bad query plan when the wrong data type is used Dave Crooke
• 22:50   Query Core Dumping Sam Stearns
• 22:58   Re: Query Core Dumping Tom Lane

9 February 2011

• 08:52   Re: Bad query plan when the wrong data type is used Vitalii Tymchyshyn
• 21:54   Re: Really really slow select count(*) felix

10 February 2011

• 00:58   Re: [HACKERS] Slow count(*) again... Gorshkov
• 14:50   Re: Why we don't want hints Was: Slow count(*) again... Robert Haas
• 15:45   Re: Why we don't want hints Was: Slow count(*) again... Kevin Grittner
• 16:02   Re: Why we don't want hints Was: Slow count(*) again... Tom Lane
• 16:03   Re: Why we don't want hints Was: Slow count(*) again... Robert Haas
• 16:06   Re: Why we don't want hints Was: Slow count(*) again... Shaun Thomas
• 16:09   Re: Why we don't want hints Was: Slow count(*) again... Shaun Thomas
• 16:19   Re: Why we don't want hints Was: Slow count(*) again... Robert Haas
• 16:22   Re: Why we don't want hints Was: Slow count(*) again... Kevin Grittner
• 16:27   Re: Why we don't want hints Was: Slow count(*) again... Kevin Grittner
• 16:30   Re: Why we don't want hints Was: Slow count(*) again... Shaun Thomas
• 16:44   Re: Why we don't want hints Was: Slow count(*) again... Kevin Grittner
• 16:51   Re: Does auto-analyze work on dirty writes? Robert Haas
• 16:56   Re: Why we don't want hints Was: Slow count(*) again... Greg Smith
• 17:21   Re: Why we don't want hints Chris Browne
• 17:26   Re: Why we don't want hints Was: Slow count(*) again... Kevin Grittner
• 18:03   Re: Why we don't want hints Was: Slow count(*) again... Craig James
• 19:55   Re: Why we don't want hints Was: Slow count(*) again... Tobias Brox
• 20:12   Re: Why we don't want hints Was: Slow count(*) again... Tom Lane

11 February 2011

• 07:19   Re: Why we don't want hints Was: Slow count(*) again... Віталій Тимчишин
• 08:29   Re: Why we don't want hints Was: Slow count(*) again... Tobias Brox
• 08:44   Re: Why we don't want hints Was: Slow count(*) again... Vitalii Tymchyshyn
• 10:26   Re: Why we don't want hints Was: Slow count(*) again... Tobias Brox
• 13:21   Re: Re: Indexes with condition using immutable functions applied to column not used Nick Lello
• 13:21   Re: Why we don't want hints Was: Slow count(*) again... Andrea Suisani
• 16:05   Re: High load, Jignesh Shah
• 17:35   Unblock tables Cesar Arrieta
• 17:51   Re: Why we don't want hints Was: Slow count(*) again... Pierre C
• 18:20   Re: Unblock tables Scott Marlowe

13 February 2011

• 19:40   Re: Why we don't want hints Rob Wultsch
• 21:29   Re: Why we don't want hints Josh Berkus
• 21:51   choosing the right RAID level for PostgresQL database sergey
• 21:52   Re: Why we don't want hints Scott Marlowe
• 21:54   Re: choosing the right RAID level for PostgresQL database Scott Marlowe
• 21:59   Re: choosing the right RAID level for PostgresQL database Scott Marlowe
• 22:23   Re: choosing the right RAID level for PostgresQL database Greg Smith

14 February 2011

• 00:54   Re: choosing the right RAID level for PostgresQL database Dave Crooke
• 00:57   comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Mark Rostron
• 01:12   Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Scott Marlowe
• 01:33   Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Greg Smith
• 03:17   Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Mark Rostron
• 03:40   Re: comparison of 8.3.10 to 8.3.14 reveals unexpected difference in explain plan Mark Rostron
• 06:01   Re: Why we don't want hints Scott Marlowe
• 06:03   How to boost performance of queries containing pattern matching characters Gnanakumar
• 06:19   Re: How to boost performance of queries containing pattern matching characters Richard Huxton
• 06:31   Re: How to boost performance of queries containing pattern matching characters Gnanakumar
• 06:39   Re: How to boost performance of queries containing pattern matching characters Richard Huxton
• 06:49   Re: How to boost performance of queries containing pattern matching characters Gnanakumar
• 06:50   Re: How to boost performance of queries containing pattern matching characters Richard Huxton
• 06:57   Re: How to boost performance of queries containing pattern matching characters Richard Huxton
• 07:02   Re: choosing the right RAID level for PostgresQL database david@lang.hm
• 07:05   Re: How to boost performance of queries containing pattern matching characters Artur Zając
• 07:06   Re: How to boost performance of queries containing pattern matching characters Gnanakumar
• 07:10   Re: How to boost performance of queries containing pattern matching characters Artur Zając
• 10:33   performance issue in the fields. dba
• 10:37   Re: performance issue in the fields. Pavel Stehule
• 11:06   Field wise checking the performance. dba
• 11:30   Re: Field wise checking the performance. Heikki Linnakangas
• 12:55   Re: How to boost performance of queries containing pattern matching characters Shaun Thomas
• 14:16   Re: How to boost performance of queries containing pattern matching characters Greg Smith
• 15:53   Re: How to boost performance of queries containing pattern matching characters Steve Atkins

15 February 2011

• 10:52   Checkpointing question Strange, John W
• 13:30   LIMIT on partitioned-table!? Kim A. Brandt
• 13:49   Re: LIMIT on partitioned-table!? Shaun Thomas
• 16:51   Re: Checkpointing question Kevin Grittner
• 16:56   high user cpu, massive SELECTs, no io waiting problem Thomas Pöhler
• 17:02   Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe
• 17:07   Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner
• 17:41   pg_dumpall affecting performance Mark Mikulec
• 17:52   Re: pg_dumpall affecting performance Plugge, Joe R.
• 17:56   Re: pg_dumpall affecting performance Steve Crawford
• 18:09   Re: high user cpu, massive SELECTs, no io waiting problem Strange, John W
• 18:13   Re: pg_dumpall affecting performance Kevin Grittner
• 18:33   Re: LIMIT on partitioned-table!? Kim A. Brandt
• 18:56   Re: high user cpu, massive SELECTs, no io waiting problem marcin mank
• 20:20   Re: LIMIT on partitioned-table!? Marti Raudsepp

16 February 2011

• 00:00   Re: high user cpu, massive SELECTs, no io waiting problem Ivan Voras
• 00:19   Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe
• 06:24   Re: LIMIT on partitioned-table!? Kim A. Brandt
• 06:33   Re: high user cpu, massive SELECTs, no io waiting problem Greg Smith
• 12:52   Re: high user cpu, massive SELECTs, no io waiting problem Marti Raudsepp
• 13:37   Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner
• 13:56   Re: high user cpu, massive SELECTs, no io waiting problem Greg Smith
• 14:43   Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe
• 15:02   Re: high user cpu, massive SELECTs, no io waiting problem Scott Marlowe
• 15:09   Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner
• 15:28   Re: Really really slow select count(*) Ross J. Reedstrom
• 16:11   Re: high user cpu, massive SELECTs, no io waiting problem Thomas Pöhler
• 16:58   Re: high user cpu, massive SELECTs, no io waiting problem Cédric Villemain
• 18:20   Re: Really really slow select count(*) Bob Lunney
• 18:22   Re: high user cpu, massive SELECTs, no io waiting problem Kevin Grittner
• 19:36   Re: high user cpu, massive SELECTs, no io waiting problem Greg Smith
• 19:51   Estimating hot data size Chris Hoover
• 20:14   Re: Estimating hot data size Tomas Vondra
• 20:22   Re: Why we don't want hints Was: Slow count(*) again... Bruce Momjian
• 21:02   Re: Estimating hot data size Greg Smith

17 February 2011

• 04:14   Does exclusive locking improve performance? Jeremy Palmer
• 04:18   Re: Does exclusive locking improve performance? Stephen Frost
• 09:17   Re: high user cpu, massive SELECTs, no io waiting problem Pierre C
• 13:41   application of KNN code to US zipcode searches? Mark Stosberg
• 13:49   Re: application of KNN code to US zipcode searches? Kevin Grittner
• 14:21   Re: application of KNN code to US zipcode searches? Mark Stosberg
• 14:22   Re: Really really slow select count(*) Merlin Moncure
• 14:24   Re: application of KNN code to US zipcode searches? Stephen Frost
• 14:56   Re: application of KNN code to US zipcode searches? Mark Stosberg
• 15:41   Re: application of KNN code to US zipcode searches? Heikki Linnakangas
• 15:42   Re: application of KNN code to US zipcode searches? Mark Stosberg
• 18:13   Re: application of KNN code to US zipcode searches? Tom Lane
• 18:17   Re: application of KNN code to US zipcode searches? Tom Lane
• 19:18   Re: application of KNN code to US zipcode searches? Oleg Bartunov
• 19:38   Re: application of KNN code to US zipcode searches? Mark Stosberg
• 22:26   Re: application of KNN code to US zipcode searches? bricklen

18 February 2011

• 06:13   Re: high user cpu, massive SELECTs, no io waiting problem Justin Pitts
• 06:13   Re: high user cpu, massive SELECTs, no io waiting problem Strange, John W
• 13:29   different clients, different query plans Uwe Bartels
• 13:58   Re: different clients, different query plans Kevin Grittner
• 14:06   Re: different clients, different query plans Uwe Bartels

19 February 2011

• 09:30   Slow query execution over high latency network Clemens Eisserer
• 11:30   Re: Slow query execution over high latency network Pierre C
• 12:05   Re: Slow query execution over high latency network Clemens Eisserer

20 February 2011

• 16:03   Re: Slow query execution over high latency network Andrej

21 February 2011

• 20:08   Re: Slow query execution over high latency network Clemens Eisserer

23 February 2011

• 01:22   Re: Why we don't want hints Was: Slow count(*) again... Robert Haas
• 02:07   Re: Query performance with disabled hashjoin and mergejoin Robert Haas
• 02:23   Re: Exhaustive list of what takes what locks Robert Haas
• 02:34   Re: Exhaustive list of what takes what locks Tom Lane
• 03:21   Re: Exhaustive list of what takes what locks Noah Misch
• 16:21   Re: Exhaustive list of what takes what locks Robert Haas
• 16:31   Re: Exhaustive list of what takes what locks Tom Lane
• 16:59   Re: Exhaustive list of what takes what locks Robert Haas
• 18:14   Unused indices Benjamin Krajmalnik
• 18:27   NULLS LAST performance Mathieu De Zutter
• 18:48   Re: NULLS LAST performance Merlin Moncure
• 18:59   Re: performance issue in the fields. Merlin Moncure
• 20:19   Re: Unused indices Greg Smith
• 20:39   Re: NULLS LAST performance Tom Lane

24 February 2011

• 07:23   Re: performance issue in the fields. Pierre C
• 08:47   Re: NULLS LAST performance Mathieu De Zutter
• 08:56   Function execution consuming lot of memory and eventually making server unresponsive Gnanakumar
• 09:30   Re: Function execution consuming lot of memory and eventually making server unresponsive Pavel Stehule
• 11:29   Re: Function execution consuming lot of memory and eventually making server unresponsive Kevin Grittner
• 13:25   Re: Unused indices Shaun Thomas
• 14:14   Pushing IN (subquery) down through UNION ALL? Dave Johansen
• 14:14   Re: Function execution consuming lot of memory and eventually making server unresponsive Merlin Moncure
• 14:59   Re: Function execution consuming lot of memory and eventually making server unresponsive Tom Lane
• 15:58   Re: Pushing IN (subquery) down through UNION ALL? Dave Johansen
• 17:13   Re: Unused indices Greg Smith
• 18:34   Re: Pushing IN (subquery) down through UNION ALL? Vik Reykja
• 18:36   Re: Unused indices Shaun Thomas
• 18:55   Picking out the most recent row using a time stamp column Dave Crooke
• 18:56   Re: Pushing IN (subquery) down through UNION ALL? Dave Johansen
• 19:00   Re: Pushing IN (subquery) down through UNION ALL? Vik Reykja
• 19:11   Re: Picking out the most recent row using a time stamp column Merlin Moncure
• 19:19   Re: Picking out the most recent row using a time stamp column Kevin Grittner
• 19:22   Re: Picking out the most recent row using a time stamp column Michael Glaesemann
• 19:24   Re: Picking out the most recent row using a time stamp column Kevin Grittner
• 19:50   Pushing IN (subquery) down through UNION ALL? Dave Johansen
• 19:52   Re: Pushing IN (subquery) down through UNION ALL? Dave Johansen
• 20:20   Re: Picking out the most recent row using a time stamp column Merlin Moncure
• 22:38   Re: Picking out the most recent row using a time stamp column Dave Crooke
• 22:53   Possible parser bug? .... Re: Picking out the most recent row using a time stamp column Dave Crooke
• 23:20   Re: Picking out the most recent row using a time stamp column Josh Berkus
• 23:23   Re: Possible parser bug? .... Re: Picking out the most recent row using a time stamp column Jochen Erwied
• 23:58   Re: Picking out the most recent row using a time stamp column Shaun Thomas

25 February 2011

• 00:52   Re: Picking out the most recent row using a time stamp column Josh Berkus
• 07:30   Perl Binding affects speed? Sam Wong
• 11:26   Re: Perl Binding affects speed? Marti Raudsepp
• 12:09   Re: Perl Binding affects speed? Martin Kjeldsen
• 12:24   Re: Perl Binding affects speed? Sam Wong
• 12:31   Index use difference betweer LIKE, LIKE ANY? Sam Wong
• 15:50   Re: Picking out the most recent row using a time stamp column Dave Johansen
• 19:52   Re: Picking out the most recent row using a time stamp column Dave Crooke

26 February 2011

• 06:07   Vacuum problem due to temp tables Bhakti Ghatkar
• 12:44   Re: Picking out the most recent row using a time stamp column Dave Johansen
• 16:25   Re: Vacuum problem due to temp tables Tom Lane
• 20:06   Re: Picking out the most recent row using a time stamp column Josh Berkus
• 20:14   Re: Index use difference betweer LIKE, LIKE ANY? Josh Berkus
• 20:38   Re: Picking out the most recent row using a time stamp column Dave Johansen
• 20:39   Re: Picking out the most recent row using a time stamp column Florian Weimer
• 20:53   Re: Picking out the most recent row using a time stamp column Kevin Grittner

27 February 2011

• 16:59   Re: Talking about optimizer, my long dream Robert Haas
• 17:17   Re: Bad query plan when the wrong data type is used Robert Haas
• 17:21   Re: Indexes with condition using immutable functions applied to column not used Robert Haas
• 17:40   Re: Bad query plan when the wrong data type is used Tom Lane
• 21:21   Re: Talking about optimizer, my long dream Віталій Тимчишин

28 February 2011

• 02:26   Performance Test for PostgreSQL9 Selva manickaraja
• 03:18   Re: Performance Test for PostgreSQL9 Mark Kirkwood
• 04:09   Re: Performance Test for PostgreSQL9 Selva manickaraja
• 04:14   Re: Vacuum problem due to temp tables Bhakti Ghatkar
• 04:53   Re: Performance Test for PostgreSQL9 Mark Kirkwood
• 05:39   Re: Performance Test for PostgreSQL9 Selva manickaraja
• 05:43   Re: Performance Test for PostgreSQL9 Jochen Erwied
• 05:51   Re: Performance Test for PostgreSQL9 Melton Low
• 05:57   Re: Performance Test for PostgreSQL9 Melton Low
• 06:18   Is Query need to be optimized Adarsh Sharma
• 08:11   Re: Performance Test for PostgreSQL9 Selva manickaraja
• 08:38   inheritance: planning time vs children number vs column number Marc Cousin
• 08:44   optimization croolyc
• 10:37   Re: Performance Test for PostgreSQL9 Heikki Linnakangas
• 11:58   Re: inheritance: planning time vs children number vs column number Heikki Linnakangas
• 12:10   Re: inheritance: planning time vs children number vs column number Marc Cousin
• 13:57   Re: optimization Kevin Grittner
• 14:35   Re: inheritance: planning time vs children number vs column number Tom Lane
• 15:26   Load and Stress on PostgreSQL 9.0 Selva manickaraja
• 16:50   optimalization croolyc
• 17:32   Re: optimalization Andreas Kretschmer
• 17:34   Query on view radically slower than query on underlying table Craig James
• 17:36   Re: Load and Stress on PostgreSQL 9.0 Josh Berkus
• 17:47   Re: inheritance: planning time vs children number vs column number Marc Cousin
• 17:57   Re: Query on view radically slower than query on underlying table Tom Lane
• 18:05   Re: Bad query plan when the wrong data type is used Robert Haas
• 18:09   Re: Talking about optimizer, my long dream Robert Haas
• 18:10   Anyone tried Flashcache with PostgreSQL? Josh Berkus
• 18:24   Re: Query on view radically slower than query on underlying table Craig James
• 18:58   Re: Query on view radically slower than query on underlying table Tom Lane