Re: blocking automatic vacuum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Uwe Bartels <uwe(dot)bartels(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: blocking automatic vacuum
Date: 2010-07-01 15:33:57
Message-ID: 1277998392-sup-5801@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message uwcssa 2010-07-02 01:20:25 hello
Previous Message Uwe Bartels 2010-07-01 08:42:42 Re: blocking automatic vacuum