From: Kenneth Marshall <ktm@rice.edu>
To: Mladen Gogala <mladen.gogala@vmsinfo.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Bufer cache replacement LRU algorithm?
Date: Wed, 3 Nov 2010 11:52:16 -0500
Message-ID: <20101103165216.GC27429@aart.is.rice.edu> (raw)
In-Reply-To: <4CD18F55.6070100@vmsinfo.com>
References: <4CD18F55.6070100@vmsinfo.com>
Mladen,
You would need to check the mailing lists. The release notes
have it as being a clock sweep algorithm starting in version
8. Then additional changes were added to eliminate the cache
blowout caused by a sequential scan and by vacuum/autovacuum.
I do not believe that there are any parameters available other
than total size of the pool and whether sequential scans are
synchronized.
Regards,
Ken
On Wed, Nov 03, 2010 at 12:35:33PM -0400, Mladen Gogala wrote:
> Where can I find the documentation describing the buffer replacement
> policy? Are there any parameters governing the page replacement policy?
>
> --
> Mladen Gogala Sr. Oracle DBA
> 1500 Broadway
> New York, NY 10036
> (212) 329-5251
> http://www.vmsinfo.com The Leader in Integrated Media Intelligence
> Solutions
>
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ktm@rice.edu, mladen.gogala@vmsinfo.com
Subject: Re: Bufer cache replacement LRU algorithm?
In-Reply-To: <20101103165216.GC27429@aart.is.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox