Request a Demo
Home   >   mailing lists

Re: Question about different behaviour in pg_wal when archive_mode is set on or off - Mailing list pgsql-general

From David G. Johnston
Subject Re: Question about different behaviour in pg_wal when archive_mode is set on or off
Date
Msg-id CAKFQuwYM+7jw61L0ums6FOVfp8qqEaGbarO7EWQz25EzYry_rg@mail.gmail.com
Whole thread Raw
In response to Question about different behaviour in pg_wal when archive_mode is set on or off  (Arpad Kiss A <arpad.a.kiss@est.tech>)
List pgsql-general
Tree view
On Thursday, June 26, 2025, Arpad Kiss A <arpad.a.kiss@est.tech> wrote:
Can someone explain why the difference in behavior? Does postgres only use the seqno only to differentiate the wal files here? Why does postgres not rotate out files in the former case?

Seems like it is being helpful not throwing away data you may be experimenting with during a point-in-time recovery.

David J.

pgsql-general by date:

Previous
From: Arpad Kiss A
Date:
Subject: Question about different behaviour in pg_wal when archive_mode is set on or off
Next
From: "Zechman, Derek S"
Date:
Subject: analyze-in-stages post upgrade questions