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

[HACKERS] archive_timeout behavior for no activity

2010-01-14 Thread Bruce Momjian
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 are archived? -- Bruce Momjian