Joshua D. Drake wrote: > On 02/29/2016 05:31 AM, Stephen Frost wrote: > >Realistically, ANALYZE is a background/maintenance task that autovacuum > >should be handling for you. > > Incorrect. That would be autoanalyze and although they are similar they are > not the same. ANALYZE is used for a number of things, not the least is query > profiling.
I think you are confusing ANALYZE with EXPLAIN ANALYZE. I am not aware of any way in which ANALYZE is different from what you call "autoanalyze" (which is really just an autovacuum-invoked ANALYZE and for which we don't have any specific term). -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
