Re: Large pg_xlog - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Large pg_xlog
Date
Msg-id a6310892-399c-4b7e-455c-60211fb39d7f@natserv.net
Whole thread Raw
In response to Re: Large pg_xlog  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Large pg_xlog
List pgsql-general
On 09/26/2016 09:05 PM, Michael Paquier wrote:
> What are the files in pg_xlog/archive_status? Do see a lot of .ready
> entries? Perhaps you could de-bloat things by using archive_command =
> '/bin/true' (REM on Windows as far as I recall).


There is no archive_status

  ll 9.3/main/pg_xlog/ |grep arch
postgres@s0pdb03:~$

As for changing archive_command to /bin/true, don't see how that would
help. My archive command is pointing to a completely different folder.


Just try anyway, changed archive_command to bin true. Files in pg_xlog
keep growing. Currently at over 5K files. Isn't wal_keep_segments the
upper limit of how many wal files would be retained in Postgresql 9.3?


wal_keep_segments=300

checkpoint_segments=6


Yet have over 5K files, and more getting created, in my pg_xlog folder.



pgsql-general by date:

Previous
From: Stephen Davies
Date:
Subject: Re: Graphical entity relation model
Next
From: Michael Paquier
Date:
Subject: Re: Large pg_xlog