Re: [GENERAL] How to reduce WAL files in Point in time recovery

2016-09-02 Thread Venkata B Nagothi
On Fri, Sep 2, 2016 at 2:58 PM, Amee Sankhesara - Quipment India < amee.sankhes...@quipment.nl> wrote: > Hi, > > > > I have setup PITR in PostgreSQL. I am taking base backup at every specific > interval and also kept WAL files of size 16 MB each. > > > > Now the situation is that even there is no

[GENERAL] How to reduce WAL files in Point in time recovery

2016-09-02 Thread Amee Sankhesara - Quipment India
Hi, I have setup PITR in PostgreSQL. I am taking base backup at every specific interval and also kept WAL files of size 16 MB each. Now the situation is that even there is no any major change in database, it suddenly started creating too many WAL files. I have gathered statistics with c