Moving 'hot' pages from buffer pool to heap

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