From: | "Sven Haag" <sven-haag(at)gmx(dot)de> |
---|---|
To: | Jens Wilke <jens(at)wilke(dot)org>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Autovacuum firing up during my manual vacuum on same table |
Date: | 2011-04-02 14:06:27 |
Message-ID: | 20110402140627.109700@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-------- Original-Nachricht --------
> Datum: Sat, 2 Apr 2011 14:17:37 +0200
> Von: Jens Wilke <jens(at)wilke(dot)org>
> An: pgsql-general(at)postgresql(dot)org
> Betreff: Re: [GENERAL] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-04-02 14:47:14 | Re: Autovacuum firing up during my manual vacuum on same table |
Previous Message | Jens Wilke | 2011-04-02 12:17:37 | Re: Autovacuum firing up during my manual vacuum on same table |