Re: [BUGS] BUG #3674: Unnecessary checkpoints by WAL Writer

2007-10-15 Thread Simon Riggs
On Fri, 2007-10-12 at 13:06 -0400, Tom Lane wrote: > "ITAGAKI Takahiro" <[EMAIL PROTECTED]> writes: > > WAL Writer requests unnecessary checkpoints with CHECKPOINT_CAUSE_XLOG. > > RedoRecPtr, declared in xlog.c, is initialized at StartupXLOG() but never > > updated in WAL Writer because it never ca

Re: [BUGS] BUG #3674: Unnecessary checkpoints by WAL Writer

2007-10-12 Thread Tom Lane
"ITAGAKI Takahiro" <[EMAIL PROTECTED]> writes: > WAL Writer requests unnecessary checkpoints with CHECKPOINT_CAUSE_XLOG. > RedoRecPtr, declared in xlog.c, is initialized at StartupXLOG() but never > updated in WAL Writer because it never calls XLogInsert(). It judges excess > of segments wrongly.

[BUGS] BUG #3674: Unnecessary checkpoints by WAL Writer

2007-10-12 Thread ITAGAKI Takahiro
The following bug has been logged online: Bug reference: 3674 Logged by: ITAGAKI Takahiro Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta1 Operating system: independent Description:Unnecessary checkpoints by WAL Writer Details: WAL Writer requests unnec