On Wed, 2021-01-06 at 11:14 +, Li EF Zhang wrote:
> When I restart secondary node, it reported
> "DEBUG: recovery snapshot waiting for non-overflowed snapshot or until
> oldest active xid on standby is at least 4739126 (now 1422751)
> CONTEXT: WAL redo at 4/741941F8 for Standby/RUNNING_XACT
Thanks for your reply. I read it.
When I restart secondary node, it reported "DEBUG: recovery snapshot waiting for non-overflowed snapshot or until oldest active xid on standby is at least 4739126 (now 1422751)#0122020-12-21 00:00:24.415 UTC [146-15455940] CONTEXT: WAL redo at 4/741941F8 for Stan
On Tue, 2021-01-05 at 10:42 +, Li EF Zhang wrote:
> I am new to postgresql and sql. I want to check running transactions whose
> subtransactions exceeds 64. Is there any SQL statement or other method can
> do this? Thanks!
You may want to read
https://www.cybertec-postgresql.com/en/subtransa
I am new to postgresql and sql. I want to check running transactions whose subtransactions exceeds 64. Is there any SQL statement or other method can do this? Thanks!
