Postgres Pro
Downloads
Home   >   mailing lists

Re: VACUUM and transactions in different databases - Mailing list pgsql-general

From Ragnar
Subject Re: VACUUM and transactions in different databases
Date
Msg-id 1165523025.379.47.camel@localhost.localdomain
Whole thread Raw
In response to Re: VACUUM and transactions in different databases  (Cornelia Boenigk <poppcorn@cornelia-boenigk.de>)
Responses Re: VACUUM and transactions in different databases  (Cornelia Boenigk <poppcorn@cornelia-boenigk.de>)
List pgsql-general
Tree view 
On fim, 2006-12-07 at 20:04 +0100, Cornelia Boenigk wrote:
> Sorry, i was out
>
> [ snip demonstration of blocked vacuum full]

> running on pg 8.1.4 on Fedora 5

could not duplicate this.

can you show us the contents of pg_locks and
pg_stat_activity while the VACUUM is blocked?

gnari

pgsql-general by date:

Previous
From: Ragnar
Date:
Subject: Re: Online index builds
Next
From: Cornelia Boenigk
Date:
Subject: Re: VACUUM and transactions in different databases