Re: [PATCHES] Better default_statistics_target - Mailing list pgsql-hackers

From Robert Treat
Subject Re: [PATCHES] Better default_statistics_target
Date
Msg-id 200801312319.59723.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: [PATCHES] Better default_statistics_target  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: [PATCHES] Better default_statistics_target  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Thursday 31 January 2008 09:55, Kevin Grittner wrote:
> >>> On Wed, Jan 30, 2008 at  8:13 PM, in message
>
> <d6d6637f0801301813n64fa58eu76385cf8a621907@mail.gmail.com>, "Christopher
>
> Browne" <cbbrowne@gmail.com> wrote:
> > There seems to be *plenty* of evidence out there that the performance
> > penalty would NOT be "essentially zero."
>
> I can confirm that I have had performance tank because of boosting
> the statistics target for selected columns.  It appeared to be time
> spent in the planning phase, not a bad plan choice.  Reducing the
> numbers restored decent performance.
>

Bad plans from boosting to 100 or less? Or something much higher? 


-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL


pgsql-hackers by date:

Previous
From: "Roberts, Jon"
Date:
Subject: Re: timestamp format bug
Next
From: Devrim GÜNDÜZ
Date:
Subject: [Fwd: [COMMITTERS] pgsql: Stamp 8.3 in CVS.]