Gregory Stark wrote:
Josh Berkus <[EMAIL PROTECTED]> writes:DW: default_statistics_target = 400 Mixed: default_statistics_target = 100You, 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 -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
