From: | "For your eyes only(dot)(dot)(dot)" <xzyshnok(at)msn(dot)com> |
---|---|
To: | Jerry Sievers <gsievers19(at)comcast(dot)net>, Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | 答复: Determine which query prevents applying WALs on standby |
Date: | 2018-09-07 03:41:45 |
Message-ID: | MWHPR14MB1421465E13E7C14533ADCFDDCF000@MWHPR14MB1421.namprd14.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi team,
Would please remove me from it.
Beat Regard,
Zhenyu Xu
-----邮件原件-----
发件人: Jerry Sievers <gsievers19(at)comcast(dot)net>
发送时间: Thursday, September 6, 2018 23:35
收件人: Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)com>
抄送: pgsql-admin(at)postgresql(dot)org
主题: Re: Determine which query prevents applying WALs on standby
Andrey Zhidenkov <andrey(dot)zhidenkov(at)gmail(dot)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(dot)consulting(at)comcast(dot)net
p: 312.241.7800
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2018-09-07 07:36:46 | Re: Postgresql jdbc driver for PG version 9.5 |
Previous Message | Mike Broers | 2018-09-06 17:28:18 | root cause of corruption in hot standby |