-------- Original-Nachricht -------- > Datum: Sat, 2 Apr 2011 14:17:37 +0200 > Von: Jens Wilke <jens@xxxxxxxxx> > An: pgsql-general@xxxxxxxxxxxxxx > Betreff: Re: Autovacuum firing up during my manual vacuum on same table > 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 a bit off-topic, but: i'm using pg 9 and always getting messages to vacuum tables in pgadmin. according to your post this souldn't be the case? cheers sven -- GMX DSL Doppel-Flat ab 19,99 Euro/mtl.! Jetzt mit gratis Handy-Flat! http://portal.gmx.net/de/go/dsl -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
