Re: Simple postgresql.conf wizard - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Simple postgresql.conf wizard
Date
Msg-id 20265.1226603252@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple postgresql.conf wizard  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Simple postgresql.conf wizard
Re: Simple postgresql.conf wizard
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Gregory Stark wrote:
>> Josh Berkus <josh@agliodbs.com> writes:
>>> DW:
>>> default_statistics_target = 400
>>> Mixed:
>>> default_statistics_target = 100
>> 
>> You, my friend, are certifiably insane.

> Hmmm?  Why?  I've used those settings in the field, fairly frequently. 

Even though we all agree default_statistics_target = 10 is too low,
proposing a 40X increase in the default value requires more evidence
than this.  In particular, the prospect of a 1600-fold increase in
the typical cost of eqjoinsel() is a mite scary.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: libpq-events windows gotcha
Next
From: Aidan Van Dyk
Date:
Subject: Re: Block-level CRC checks