On Samstag, 2. April 2011, Henry C. wrote: > I just noticed something odd: I'm busy with a manual vacuum on a > table and an autovacuum keeps firing up as well.
Usually a manual vacuum cancels a running autovacuum task. You should find a notice about the cancelation in th logfile. > current_query | vacuum analyze > age | 11:46:57.245568 Where is the age column from? It's not in pg_stat_activity. Is one of the two processes waiting=t in pg_stat_activity? Shure it's the same Table? Do you have one Table named page_citation_text in public and one in anoter sheme? > I'm trying to vacuum the table as quickly as possible so a manual > vacuum seems to be in order as my understanding (and experience) > is that the autovac is a hell of a lot slower to mitigate impact > on general performance. Tune the autovacuum settings, especially the scale factors of the tables in question and the cost limit. Is autovacuum_vacuum_cost_limit != -1 ? This could be one reason, why manual vacuum is faster. Nevertheless since at least 8.4 IMO there's no need to bother with manual vacuum any more. Regards, Jens -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
