Re: Seems like a large amount of xlog files

CC to pgsql-admin(at)postgresql(dot)org

On Wed, May 25, 2011 at 5:10 PM, Michael Holt <michael(at)aers(dot)ca> wrote:
> archive_timeout is not set. The default is to have it off right?

Yes.

My another guess is that those many files were generated by
initial data load and have remained up to now. No?

Anyway, you can check whether your system is still generating
so many WAL files now, by periodically calling
pg_current_xlog_location(). This function returns the current
WAL write location, so if the rate of increase of that location
is small, you don't need to worry about the number of files.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center