Limit of WAL LSN value of type pg_lsn

From: Shubham Shingne <shubham(dot)s(dot)shingne(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Limit of WAL LSN value of type pg_lsn
Date: 2022-10-31 05:33:59
Message-ID: CAGbTd7CUcx11_hMsU8gSJJHALjFN+P0uZFMNPN8ahCex6rBrGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I am trying to determine optimal standby for automatic failover based on
pg_last_wal_recieve_lsn() value of all slaves.

But what if max_wal_size is reached, is LSN value reset to zero.

Please share some documentation that mentions clarification.

Also suggest if there is any better approach to get node with best RPO out
of all slaves.

Thanks & regards,
Shubham

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2022-10-31 05:42:03 Commit fest 2022-11
Previous Message Michael Paquier 2022-10-31 05:33:50 Re: pg15 inherited stats expressions: cache lookup failed for statistics object