Moving 'hot' pages from buffer pool to heap - Mailing list pgsql-hackers

From Atri Sharma
Subject Moving 'hot' pages from buffer pool to heap
Date
Msg-id CAOeZVie+HUMzNiVkP=aFNTiJRKs947AYkd4K88MzHiw5Ehje4w@mail.gmail.com
Whole thread Raw
Responses Re: Moving 'hot' pages from buffer pool to heap  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Moving 'hot' pages from buffer pool to heap  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Hi all,

I was experimenting with the idea of moving hot buffer pages from the
buffer pool to heap, thus allowing for normal removal of the hot
buffer page from the buffer pool and freeing the corresponding buffer
pool slot.

This shouldnt be too hard to implement, we just need to keep track of
the number of times a page was accessed(or the duration of pins held,
I am not sure).

The point is to not hold a buffer pool slot for more than a fixed
duration of time, to ensure constant flow in the buffer pool.

Has there been discussion about it done previously? I couldnt find an
existing implementation, nor a discussion for the same. If I missed
anything, please point me to it.

Please let me know your feedback and comments.

Thanks and Regards,

Atri

-- 
Regards,

Atri
l'apprenant



pgsql-hackers by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Autovacuum different in 9.2.4?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: don't own lock of type?