Postgres Pro
Downloads
Home   >   mailing lists

Limit of WAL LSN value of type pg_lsn - Mailing list pgsql-hackers

From Shubham Shingne
Subject Limit of WAL LSN value of type pg_lsn
Date
Msg-id CAGbTd7CUcx11_hMsU8gSJJHALjFN+P0uZFMNPN8ahCex6rBrGA@mail.gmail.com
Whole thread Raw
Responses Re: Limit of WAL LSN value of type pg_lsn  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
List pgsql-hackers
Tree view
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 

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg15 inherited stats expressions: cache lookup failed for statistics object
Next
From: Michael Paquier
Date:
Subject: Commit fest 2022-11