Kenneth Marshall <ktm@rice.edu> wrote:
> 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?
> 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.
The background writer settings might be considered relevant, too.
Also keep in mind that PostgreSQL goes through the OS cache and
filesystems; the filesystem choice and OS settings will have an
impact on how that level of caching behaves. Since there is often
much more cache at the OS level than in PostgreSQL shared buffers,
you don't want to overlook that aspect of things.
-Kevin