Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum firing up during my manual vacuum on same table - Mailing list pgsql-general

From Henry C.
Subject Re: Autovacuum firing up during my manual vacuum on same table
Date
Msg-id abfb4e22e7aaffddb8604ab7a06141ce.squirrel@support.metroweb.co.za
Whole thread Raw
In response to Autovacuum firing up during my manual vacuum on same table  ("Henry C." <henka@cityweb.co.za>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Table lock while adding a column and clients are logged in
Next
From: Jerry Sievers
Date:
Subject: Re: Table lock while adding a column and clients are logged in