Trying to reduce xlog wal files

From: Steve DeLong <sdelong(at)saucontech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Trying to reduce xlog wal files
Date: 2017-07-06 14:44:15
Message-ID: 24b6c62e-f885-1a29-4806-bdbeb7fe7cd9@saucontech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-07-06 15:00:02 Re: Trying to reduce xlog wal files
Previous Message Tim Uckun 2017-07-06 09:32:00 Re: Is PL-PGSQL interpreted or complied?