On Mon, Mar 7, 2011 at 11:55 PM, Mark Kirkwood <mark.kirkw...@catalyst.net.nz> wrote: > stuff | 23957 | 2011-03-08 06:02:02.659159+13 | VACUUM ANALYZE; >
For what it's worth VACUUM ANALYZE does have to take an additional lock to update the statistics. It should rarely cause any problems but it is a possibility. When you do get a good example you might want to take the contents of pg_locks at the same time as pg_stat_activity. That would at least be able to help rule out any real locks and make it clear it's really stuck on waiting for a block to become unpinned. -- greg -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
