[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Seems like a large amount of xlog files
From:       Fujii Masao <masao.fujii () gmail ! com>
Date:       2011-05-26 1:42:08
Message-ID: BANLkTi=5k=cgCVAaB8M4gj_eJSTTAuctLA () mail ! gmail ! com
[Download RAW message or body]

CC to pgsql-admin@postgresql.org

On Wed, May 25, 2011 at 5:10 PM, Michael Holt <michael@aers.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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]