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 <sdel...@saucontech.com
<mailto:sdel...@saucontech.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@postgresql.org
<mailto:pgsql-general@postgresql.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.
