Re: pg_wal lifecycle

2021-07-14 Thread Luca Ferrari
On Tue, Jul 13, 2021 at 3:43 PM Peter Eisentraut wrote: > Recycling in this context just means that instead of creating a new WAL > file for new WAL traffic, it reuses an old file. So if you have WAL > files 5, 6, 7, 8, 9, and you know that you don't need 5 and 6 anymore, > when you need to start

Re: pg_wal lifecycle

2021-07-13 Thread Peter Eisentraut
On 13.07.21 09:07, Luca Ferrari wrote: I'd like to see if I get it right about pg_wal: it grows up to pretty much max_wal_size, at which point a checkpoint is triggered. If the server triggers a timed checkpoint before the pg_wal is at max_wal_size, the system recycles the wals thus keeping the p