| From: | Francisco Reyes <lists(at)natserv(dot)net> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Large pg_xlog |
| Date: | 2016-09-29 05:25:59 |
| Message-ID: | a6310892-399c-4b7e-455c-60211fb39d7f@natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-09-29 05:36:04 | Re: Large pg_xlog |
| Previous Message | Thomas Munro | 2016-09-29 02:48:45 | Re: [GENERAL] C++ port of Postgres |