-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thu, Nov 27, 2008 at 05:15:04PM -0500, Robert Haas wrote: > [...] Maybe > default_statistics_target should vary with the table size? Something > like, 0.1% of the rows to a maximum of 100... and then 0.01% of the > rows after that to some higher maximum.... but always a minimum of at > least 10. I'm guessing that people with really big tables are less > likely to mind longer planning times and more likely to benefit from > finding better plans...
What was the running time of the planner? Quadratic in statistics_target? Take the square root of table size. Exponential? The logarithm. Or something like that. My 1.75 cent - -- tomás -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFJL6HyBcgs9XrR2kYRAqfzAJ47w720VJLHVXeS8WKH6zUjAHkbeACfTtDh rFq512eztVnib1ozjw9sibs= =JXyS -----END PGP SIGNATURE----- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers