On Mon, Jun 6, 2011 at 5:16 PM, manuel antonio ochoa <manuel8aalf...@gmail.com> 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 (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql