On Mon, Mar 22, 2010 at 6:19 PM, Carlo Stonebanks <stonec.register@xxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
