From: Roman Neuhauser <neuhauser@chello.cz>
To: pgsql-docs@postgresql.org
Subject: planner stats
Date: Wed, 2 Feb 2005 11:02:46 +0100
Message-ID: <20050202100246.GA1859@isis.wad.cz> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: neuhauser@chello.cz
Subject: Re: planner stats
In-Reply-To: <20050202100246.GA1859@isis.wad.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox