> On Oct 9, 2017, at 13:01, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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(at)thebuild(dot)com