Re: blocking automatic vacuum - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: blocking automatic vacuum
Date
Msg-id 1277998392-sup-5801@alvh.no-ip.org
Whole thread Raw
In response to Re: blocking automatic vacuum  (Uwe Bartels <uwe.bartels@gmail.com>)
List pgsql-admin
Excerpts from Uwe Bartels's message of jue jul 01 04:42:42 -0400 2010:
> Hi Tom,
>
> till now i found more blocking vacuum processes in other databases as well.
> we migrated postgres from 8.3 to 8.4 in april.

Please examine pg_locks to see what's blocking autovacuum.  The key is
WHERE granted=f.

pgsql-admin by date:

Previous
From: Uwe Bartels
Date:
Subject: Re: blocking automatic vacuum
Next
From: uwcssa
Date:
Subject: hello