Re: Vacuum Issues

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mark M(dot) Huber" <MHuber(at)VMdirect(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum Issues
Date: 2004-03-22 16:39:36
Message-ID: 1589.1079973576@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Mark M. Huber" <MHuber(at)VMdirect(dot)com> writes:
> I was did a normal vacuum and then I did a full which hung on a table,

Sounds to me like some other transaction is holding a lock on that
table.

In recent releases you can look in the pg_locks system view to see
who's got the lock.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Mark M. Huber 2004-03-22 16:39:50 Re: backup and recovery
Previous Message Tom Lane 2004-03-22 16:38:30 Re: what the initial 3 daemon of postmaster process do?