Sent from my iPad
On 06-Aug-2013, at 1:57, Tom Lane <t...@sss.pgh.pa.us> wrote: > Atri Sharma <atri.j...@gmail.com> 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 memory,and maintain them there. > > You can't do that; such a copy could easily become stale, leading to wrong > query answers. Perhaps more to the point, long-term pins (as opposed to > locks) aren't that problematic. What problem do you think you're solving? > > Yeah,long term pins are something I was thinking of solving with this.Now that you mention it, I think my main concern wasn't long term pins,rather,anything that doesn't allow for page eviction for a long time. Regards, Atri -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers