Re: vacuum full problem

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Antonis Antoniou <a(dot)antoniou(at)albourne(dot)com>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Subject: Re: vacuum full problem
Date: 2003-11-11 08:02:52
Message-ID: 20031111000039.L47755@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 11 Nov 2003, Antonis Antoniou wrote:

> Guys, does anyone has any idea?

Are you sure that vacuum is not just waiting on a lock that some other
transaction is holding? I'd suggest checking the contents of pg_locks.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pginfo 2003-11-11 08:23:04 Re: vacuum full problem
Previous Message Oli Sennhauser 2003-11-11 07:59:56 Re: ER diagram tool for PostgresSQL7.3