Re: Autovacuum firing up during my manual vacuum on same table

From: "Henry C(dot)" <henka(at)cityweb(dot)co(dot)za>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Autovacuum firing up during my manual vacuum on same table
Date: 2011-04-02 11:36:40
Message-ID: abfb4e22e7aaffddb8604ab7a06141ce.squirrel@support.metroweb.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> Anyway, is that autovac duplicating work or locked out and waiting?

Impolitely responding to my own post: a quick strace confirms the autovac
process is indeed locked out and waiting it's turn to work.

Presumably when my manual vacuum finishes, it will then proceed and
*hopefully* not re-vacuum the table?

Regards
Henry

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2011-04-02 11:44:07 Re: Table lock while adding a column and clients are logged in
Previous Message Henry C. 2011-04-02 11:16:35 Autovacuum firing up during my manual vacuum on same table