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