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

Re: pgsql: TODO item not needed anymore now that the buffer cache is

From: Kris Jurka <books(at)ejurka(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: TODO item not needed anymore now that the buffer cache is
Date: 2007-06-02 07:53:01
Message-ID: Pine.BSO.4.64.0706020350070.21888@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-committers

On Fri, 1 Jun 2007, Bruce Momjian wrote:

> Log Message:
> -----------
> TODO item not needed anymore now that the buffer cache is
> scan-resistant:
>
> <
> < * Allow free-behind capability for large sequential scans, perhaps using
> <   posix_fadvise()
> <
> <   Posix_fadvise() can control both sequential/random file caching and
> <   free-behind behavior, but it is unclear how the setting affects other
> <   backends that also have the file open, and the feature is not supported
> <   on all operating systems.
>

This todo item is about telling the OS cache that we don't want these 
buffers kept around, not about pg's own buffer cache.  So I think it's 
still valid.

Kris Jurka

In response to

Responses

pgsql-committers by date

Next:From: Bruce MomjianDate: 2007-06-02 11:28:01
Subject: pgsql: Re-add TODO and clarify it is for the kernel cache: < * Allow
Previous:From: User HinoueDate: 2007-06-02 05:32:19
Subject: psqlodbc - psqlodbc: The version is now 8.2.0402.

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