On Mon, Mar 22, 2010 at 6:19 PM, Carlo Stonebanks
<stonec.register@sympatico.ca> wrote:
> Thanks for the insight. How much more of a server's resources will be
> consumed by an ANALYZE with default_statistics_target = 100?
I don't think it will be much of a problem, especially since
autovacuum will do only the tables that need it and not all the same
time. But you can certainly try it. Before changing the global
setting, try just changing it for one session with SET:
\timing
ANALYZE <some table>;
SET default_statistics_target = 100;
ANALYZE <same table>;
\q
...Robert