planner stats
От | Roman Neuhauser |
---|---|
Тема | planner stats |
Дата | |
Msg-id | 20050202100246.GA1859@isis.wad.cz обсуждение исходный текст |
Ответы |
Re: planner stats
|
Список | pgsql-docs |
Hello, trying to figure out the right statistics target for a large table, I found the reference manual lacking: the SET STATISTICS description under ALTER TABLE doesn't explain how to choose the right target (is there a formula?), I'm not insisting it should, but: it says "For more information on the use of statistics by the PostgreSQL query planner, refer to Section 13.2.", but that section *doesn't* talk about "the use of statistics by the query planner"; it doesn't hint a method to choose a good target either (the page can be summed up to: "it's there, it influences the planner, you can change it through this mechanism, access it that way"). runtime-config.html#GUC-DEFAULT-STATISTICS-TARGET also misdirects the reader to 13.2. -- FreeBSD 4.10-STABLE 10:48AM up 3:53, 4 users, load averages: 0.00, 0.00, 0.00
В списке pgsql-docs по дате отправления: