View Single Post

   
  #1 (permalink)  
Old 04-15-2008, 10:42 PM
Kevin Grittner
 
Posts: n/a
Default Re: [PATCHES] Better default_statistics_target

>>> On Wed, Jan 30, 2008 at 8:13 PM, in message
<d6d6637f0801301813n64fa58eu76385cf8a621907@mail.g mail.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.

-Kevin




---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote