Merlin Moncure <mmonc...@gmail.com> writes: > Yes, it is pg_class is coming from LockBufferForCleanup (). As you > can see above, it has a shorter runtime. So it was killed off once > about a half hour ago which did not free up the logjam. However, AV > spawned it again and now it does not respond to cancel.
Interesting. That seems like there might be two separate issues at play. It's plausible that LockBufferForCleanup might be interfering with other attempts to scan the index, but then why wouldn't killing the AV have unstuck things? Anyway it's now seeming that Peter may have the right idea about where to look. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers