Re: [GENERAL] Trying to reduce xlog wal files

2017-07-06 Thread Steve DeLong
Exactly it!! I had changed that to 1000 also when we needed more. Reduced that and it fixed it immediately. Thank you!! On 07/06/2017 11:00 AM, Melvin Davidson wrote: On Thu, Jul 6, 2017 at 10:44 AM, Steve DeLong > wrote: I am

Re: [GENERAL] Trying to reduce xlog wal files

2017-07-06 Thread Melvin Davidson
On Thu, Jul 6, 2017 at 10:44 AM, Steve DeLong wrote: > I am running Postgresql 9.3.15 and I am trying to reduce the amount of wal > files being recycled in pg_xlog. Archive is set up and working correctly. > A while ago we had problems with the streaming slave falling

[GENERAL] Trying to reduce xlog wal files

2017-07-06 Thread Steve DeLong
I am running Postgresql 9.3.15 and I am trying to reduce the amount of wal files being recycled in pg_xlog. Archive is set up and working correctly. A while ago we had problems with the streaming slave falling behind because of hardware being slower and tuned postgres to keep over 1000k wal