> On Oct 9, 2017, at 13:01, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Hmm. Is it possible that the process is replaying the abort of a > transaction with a lot of subtransactions? That's possible, although we're now talking about an hours-long delay at this point. > Is that number changing at all? Increasing: # select mode, count(*) from pg_locks where pid=5882 group by mode; mode | count ---------------------+------- ExclusiveLock | 1 AccessExclusiveLock | 8810 (2 rows) -- -- Christophe Pettus xof@xxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general