planner stats

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

Responses

Browse pgsql-docs by date

  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