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