Re: Simple postgresql.conf wizard

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.

I almost fell off the chair because of that comment, but after I stopped 
laughing and actually looked at those values, it doesn't seem that 
unreasonable. Arbitrary, sure, but not insane. Or do I need stronger 
glasses?

A lot of people have suggested raising our default_statistics target, 
and it has been rejected because there's some O(n^2) behavior in the 
planner, and it makes ANALYZE slower, but it's not that crazy.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com