"Simon Riggs" <simon(at)2ndquadrant(dot)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

In response to

• Re: VACUUM and spoiling the buffer manager cache at 2007-02-28 16:30:02 from Simon Riggs

Responses

• Re: VACUUM and spoiling the buffer manager cache at 2007-03-01 09:09:01 from Simon Riggs

pgsql-hackers by date

Next:	From: Bruce Momjian	Date: 2007-03-01 02:06:15
	Subject: Re: [HACKERS] Deadlock with pg_dump?
Previous:	From: Takayuki Tsunakawa	Date: 2007-03-01 00:45:53
	Subject: Re: Dead Space Map version 2