Re: Simple postgresql.conf wizard
От | tomas@tuxteam.de |
---|---|
Тема | Re: Simple postgresql.conf wizard |
Дата | |
Msg-id | 20081128074658.GA26228@tomas обсуждение исходный текст |
Ответ на | Re: Simple postgresql.conf wizard ("Robert Haas" <robertmhaas@gmail.com>) |
Список | pgsql-hackers |
-----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-----
В списке pgsql-hackers по дате отправления: