View Single Post

   
  #4 (permalink)  
Old 04-12-2008, 07:28 AM
ITAGAKI Takahiro
 
Posts: n/a
Default Re: VACUUM and spoiling the buffer manager cache


"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



---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Reply With Quote