Re: Bug: Buffer cache is not scan resistant

From: "Marko Kreen" <markokr(at)gmail(dot)com>
To: "Hannu Krosing" <hannu(at)skype(dot)net>
Cc: "Jeff Davis" <pgsql(at)j-davis(dot)com>, "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "Jim Nasby" <decibel(at)decibel(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Luke Lonergan" <LLonergan(at)greenplum(dot)com>, "Grzegorz Jaskiewicz" <gj(at)pointblue(dot)com(dot)pl>, "PGSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>, "Doug Rady" <drady(at)greenplum(dot)com>, "Sherry Moore" <sherry(dot)moore(at)sun(dot)com>
Subject: Re: Bug: Buffer cache is not scan resistant
Date: 2007-03-07 08:49:09
Message-ID: e51f66da0703070049v25d6fbf0ge56ff12a77ec7451@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 3/7/07, Hannu Krosing <hannu(at)skype(dot)net> wrote:
> Do any of you know about a way to READ PAGE ONLY IF IN CACHE in *nix
> systems ?

Supposedly you could mmap() a file and then do mincore() on the
area to see which pages are cached.

But you were talking about postgres cache before, there it should
be easily implementable.

--
marko

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2007-03-07 09:01:21 Re: Auto creation of Partitions
Previous Message Josh Berkus 2007-03-07 08:18:36 Re: PostgreSQL - 'SKYLINE OF' clause added!