Re: [GENERAL] startup process stuck in recovery - Mailing list pgsql-general

> On Oct 9, 2017, at 13:01, Tom Lane <tgl@sss.pgh.pa.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       |     1AccessExclusiveLock |  8810
(2 rows)

--
-- Christophe Pettus  xof@thebuild.com



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general