Re: confusion between max_standby_archive_delay, max_standby_archive_delay and max_standby_archive_delay

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 3/11/23 14:23, Atul Kumar wrote:

Hi,

Could someone help me in telling the difference between these three parameters 

1. max_standby_archive_delay

2. max_standby_streaming_delay

3. recovery_min_apply_delay

My basic motive is to make the standby database server to be delayed to apply the changes on itself,  if any data has been accidentally deleted/updated/ truncated from the primary server.

    What you're looking for is that WAL files be "aggregated and optimized"
    by removing statements which don't have any impact on the final
    state of instance.
    
    That's great for restoring instances with update-heavy
    databases, and can only implemented by backup/restore software, or
    roll-your-own log shipping.  Just as importantly, that
    aggregation-optimization software has it's own costs (time and disk
    space), since it takes time to scan through all the recovery logs,
    keeping track of what must stay, what can be tossed, and the final
    state.

--
Born in Arizona, moved to Babylonia.