Re: Wal keep segment - Mailing list pgsql-admin

From John Scalia
Subject Re: Wal keep segment
Date
Msg-id 675BEC19-1A77-4DFC-88DB-42982FA6E922@gmail.com
Whole thread Raw
In response to Wal keep segment  (Raj kumar <rajkumar820999@gmail.com>)
Responses Re: Wal keep segment  (Raj kumar <rajkumar820999@gmail.com>)
List pgsql-admin
Wal_keep_segments is a MINIMUM setting value, meaning the database is guaranteed to keep at least that many WAL
segments.If you have replication setup and it’s fallen behind or broken, then WAL segments can rapidly accumulate on a
fairlybusy server. I suspect without having your details that something of this nature is occurring. 
—
Jay

Sent from my iPad

> On Apr 25, 2020, at 8:09 AM, Raj kumar <rajkumar820999@gmail.com> wrote:
>
> 
> Hi,
>
> I have "wal_keep_segment" set as 256.
> But I could see that around 700 files are present inside pg_wal directory.
>
> I thought after reaching 256, wal writer will start overwriting from 1st.
>
> What is the upper limit of these number of wal files in the directory?
>
> Thanks and regards
> Raj kumar



pgsql-admin by date:

Previous
From: Raj kumar
Date:
Subject: Wal keep segment
Next
From: Raj kumar
Date:
Subject: Startup process in slave