Re: Trying to reduce xlog wal files

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 <sdelong(at)saucontech(dot)com
> <mailto:sdelong(at)saucontech(dot)com>> 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 behind because of hardware being slower
> and tuned postgres to keep over 1000k wal files so it could catch
> up without us manually moving files from the backup server. We
> have since upgraded the slave so it never falls behind and would
> like to reduce the wals files kept in pg_xlog. I have updated
> postgresql.conf checkpoint_segments from 1000 to 250 and
> checkpoint_timeout from 16min to 5min. I ran SELECT
> pg_reload_conf(); and using pg_controldata I have confirmed the
> settings and checkpoints are happening at 5 min intervals.
> However, file count in pg_xlog stays at 1152 and never changes.
> How can I get this to reduce the file count?
>
> Thanks
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
> <http://www.postgresql.org/mailpref/pgsql-general>
>
>
> *>I have updated postgresql.conf checkpoint_segments from 1000 to 250
> *
> *But what is the value of wal_keep_segments?
> *
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.