Increase of buffers usage count by bgwriter

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)lab(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Increase of buffers usage count by bgwriter
Date: 2005-10-26 05:48:45
Message-ID: 20051026133803.495B.ITAGAKI.TAKAHIRO@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Hackers,

I found that bgwriter increments usage count of buffers when it writes
the buffers. I feel this behavior is strange, because the behavior of
bgwriter will affect buffer management strategy.
When backends write LRU dirty buffers, they are replaced immediately.
However, when bgwriter writes dirty buffer, the replacement is postponed
until the next rotation of CLOCK.

If the behavior is not intended, another UnpinBuffer that doesn't
increase the buffers usage count will be needed.
Otherwise, bgwriter should do behavior that looks like VACUUM,
using StrategyHintVacuum(true).

I'll appreciate any comments.
Thanks,
---
ITAGAKI Takahiro
NTT Cyber Space Laboratories

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-10-26 05:56:01 Re: BUG #1993: Adding/subtracting negative time intervals
Previous Message Christopher Kings-Lynne 2005-10-26 05:45:49 PQescapeIdentifier