Hi team,
Would please remove me from it.
Beat Regard,
Zhenyu Xu
-----邮件原件-----
发件人: Jerry Sievers <gsievers19@comcast.net>
发送时间: Thursday, September 6, 2018 23:35
收件人: Andrey Zhidenkov <andrey.zhidenkov@gmail.com>
抄送: pgsql-admin@postgresql.org
主题: Re: Determine which query prevents applying WALs on standby
Andrey Zhidenkov <andrey.zhidenkov@gmail.com> writes:
> Is there a way to detect which query (or queries) on hot standby holds
> streaming replication? Looked into the sources and found out that
> function ResolveRecoveryConflictWithVirtualXIDs do that job but have
> no idea how to do that with SQL.
The pg_locks view on your standby should reveal something.
>
> --
> With best regards, Andrey Zhidenkov.
>
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800