Re: Wal keep segment

Hi John,

Thank you.

On Sat, 25 Apr 2020, 17:45 John Scalia, <jayknowsunix(at)gmail(dot)com> wrote:

> 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 fairly busy 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(at)gmail(dot)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
>