Re: [HACKERS] archive_timeout behavior for no activity

2010-02-06 Thread Bruce Momjian
Kevin Grittner wrote: > [resend, because of apparent failure to hit the list] > > Bruce Momjian wrote: > > > I am dismayed that we are using a 16MB file for monitoring archive > > activity. Can't you use pg_current_xlog_location() and only check > > for an archive file when that location chan

Re: [HACKERS] archive_timeout behavior for no activity

2010-02-06 Thread Kevin Grittner
[resend, because of apparent failure to hit the list] Bruce Momjian wrote: > I am dismayed that we are using a 16MB file for monitoring archive > activity. Can't you use pg_current_xlog_location() and only check > for an archive file when that location changes? Hmmm Let me think about

Re: [HACKERS] archive_timeout behavior for no activity

2010-02-05 Thread Bruce Momjian
Kevin Grittner wrote: > Bruce Momjian wrote: > > > Looking at the archive_timeout documentation and > > CheckArchiveTimeout(), it appears we force a new xlog file and > > archive it even if no activity has been recorded in the xlog file. > > Is this correct? Should we document this or fix it so

Re: [HACKERS] archive_timeout behavior for no activity

2010-02-05 Thread Bruce Momjian
Fujii Masao wrote: > On Fri, Jan 15, 2010 at 12:50 AM, Bruce Momjian wrote: > > Looking at the archive_timeout documentation and CheckArchiveTimeout(), > > it appears we force a new xlog file and archive it even if no activity > > has been recorded in the xlog file. ?Is this correct? > > No. Chec

Re: [HACKERS] archive_timeout behavior for no activity

2010-01-14 Thread Fujii Masao
On Fri, Jan 15, 2010 at 12:50 AM, Bruce Momjian wrote: > Looking at the archive_timeout documentation and CheckArchiveTimeout(), > it appears we force a new xlog file and archive it even if no activity > has been recorded in the xlog file.  Is this correct? No. CheckArchiveTimeout() doesn't switc

Re: [HACKERS] archive_timeout behavior for no activity

2010-01-14 Thread Kevin Grittner
Bruce Momjian wrote: > Looking at the archive_timeout documentation and > CheckArchiveTimeout(), it appears we force a new xlog file and > archive it even if no activity has been recorded in the xlog file. > Is this correct? Should we document this or fix it so only xlog > files with contents a