From: | Roman Neuhauser <neuhauser(at)chello(dot)cz> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | planner stats |
Date: | 2005-02-02 10:02:46 |
Message-ID: | 20050202100246.GA1859@isis.wad.cz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2005-02-02 17:44:16 | Re: FAQ 4.11.* numbering is off |
Previous Message | Hashem Masoud | 2005-02-01 18:33:43 | Typo in performance-tips.html |