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

From Tom Lane
Subject Re: Moving 'hot' pages from buffer pool to heap
Date
Msg-id 3221.1375731870@sss.pgh.pa.us
Whole thread Raw
In response to Moving 'hot' pages from buffer pool to heap  (Atri Sharma <atri.jiit@gmail.com>)
Responses Re: Moving 'hot' pages from buffer pool to heap  (Atri Sharma <atri.jiit@gmail.com>)
List pgsql-hackers
Atri Sharma <atri.jiit@gmail.com> writes:
> 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.

Uh ... what?  Why in the world would you want to force a hot page out of
shared buffers?  I fail to conceive of any scenario where that'd be a
good idea.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Disabling ALTER SYSTEM SET WAS: Re: ALTER SYSTEM SET command to change postgresql.conf parameters
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum different in 9.2.4?