Re: Simple postgresql.conf wizard

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