Re: VACUUM and spoiling the buffer manager cache - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject Re: VACUUM and spoiling the buffer manager cache
Date
Msg-id 20070301105503.5EA4.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: VACUUM and spoiling the buffer manager cache  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: VACUUM and spoiling the buffer manager cache  ("Simon Riggs" <simon@2ndquadrant.com>)
List pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> wrote:

> > > VACUUM's current behaviour is to take blocks it has touched and place
> > > them on the head of the freelist, allowing them to be reused.
> > 
> > No, it puts them at the tail of the freelist.
> 
> That's a minor point because the freelist is mostly empty, so head ==
> tail in 99.9% of cases.

That's correct. Also, even if a VACUUM process collects some unused buffers
into the freelist, other backends comsume all of them in a moment.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: "Takayuki Tsunakawa"
Date:
Subject: Re: Dead Space Map version 2
Next
From: Bruce Momjian
Date:
Subject: Re: What is CheckPoint.undo needed for?