Alban Hertroys wrote: > "In the default PostgreSQL configuration, The Autovacuum Daemon takes > care of automatic analyzing of tables when they are first loaded with > data, and as they change throughout regular operation. When autovacuum > is disabled, it is a good idea to run ANALYZE periodically, or just > after making major changes in the contents of a table." > > That last line isn't explicit about temporary tables, but the reason > for running ANALYZE in both cases is the same.
Actually, autovacuum doesn't process temp tables at all because it cannot get to them; they might live solely in the creating process' private memory area. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
