Re: BUG #13895: Hot Standby locked replaying auto vacuum against pg_catalog.pg_statistics - Mailing list pgsql-bugs

Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> replay process to take some time.  It is strange that it would be locked
> for long enough to allow for manually querying pg_locks and
> pg_stat_activity.

We restarted the standby after maybe 35 mins of application downtime due
to the incident=E2=80=A6 the diagnostic and restart did happen a tad late i=
n the
process on that ocasion, as it sometimes happens.

So the lock has been kept about that long.
--=20
Dimitri Fontaine                                        06 63 07 10 78
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support