Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Atri Sharma
Sent from my iPad On 06-Aug-2013, at 1:57, Tom Lane wrote: > Atri Sharma writes: >> Just experimenting though.I was thinking of scenarios where a page is pinned >> for long period of time.My concern was that it would lead to blocking of a >> buffer pool slot for that entire duration. The id

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Tom Lane
Atri Sharma writes: > Just experimenting though.I was thinking of scenarios where a page is pinned > for long period of time.My concern was that it would lead to blocking of a > buffer pool slot for that entire duration. The idea is to allocate a separate > data structure for such hot pages in

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Atri Sharma
Sent from my iPad On 06-Aug-2013, at 1:24, Jeff Janes wrote: > On Mon, Aug 5, 2013 at 12:36 PM, Atri Sharma wrote: >> Hi all, >> >> I was experimenting with the idea of moving hot buffer pages from the >> buffer pool to heap, > > Which heap do you mean here? Alas, half the data structures u

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Atri Sharma
Sent from my iPad On 06-Aug-2013, at 1:14, Tom Lane wrote: > Atri Sharma 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 buffe

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Jeff Janes
On Mon, Aug 5, 2013 at 12:36 PM, Atri Sharma wrote: > Hi all, > > I was experimenting with the idea of moving hot buffer pages from the > buffer pool to heap, Which heap do you mean here? Alas, half the data structures used in CS are called "heap". I can't think of any of them that are good cand

Re: [HACKERS] Moving 'hot' pages from buffer pool to heap

2013-08-05 Thread Tom Lane
Atri Sharma 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 forc