On Mon, Jun 6, 2011 at 5:16 PM, manuel antonio ochoa
wrote:
> Hello ,
>
> do you know how to find a process that is locking a table ? I try to run a
> vacuum analyze , an it take a state of waiting , I canceled it after 20
> minutes , then
> I try to run an analyze and the same happen, take a state waiting.
Try the queries here: http://wiki.postgresql.org/wiki/Lock_Monitoring
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
