Skip site navigation (1) Skip section navigation (2)

BUG #3674: Unnecessary checkpoints by WAL Writer

From: "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3674: Unnecessary checkpoints by WAL Writer
Date: 2007-10-12 14:56:16
Message-ID: 200710121456.l9CEuGTv059859@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3674
Logged by:          ITAGAKI Takahiro
Email address:      itagaki(dot)takahiro(at)gmail(dot)com
PostgreSQL version: 8.3beta1
Operating system:   independent
Description:        Unnecessary checkpoints by WAL Writer
Details: 

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.

Though bgwriter also does not call XLogInsert(), but it would be OK because
bgwriter updates RedoRecPtr in CreateCheckPoint().

Responses

pgsql-bugs by date

Next:From: Martin PittDate: 2007-10-12 15:14:46
Subject: Re: libpq5 8.3 breaks 8.2 compatibility with encodings
Previous:From: Martin PittDate: 2007-10-12 14:33:38
Subject: libpq5 8.3 breaks 8.2 compatibility with encodings

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group