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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers