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