Jerry Gamache wrote: > Here is the pg_locks output. > > Alvaro Herrera wrote: > >Jerry Gamache wrote:
> >>The logs show that the autovacuum of table_b was canceled 20 minutes > >>ago, but the thread is still alive and blocked. Well, it's clearly locked on table_b, and that autovac is still running ... maybe it was a previous run that was cancelled? Do you have the PID in log_line_prefix? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
