Re: Moving 'hot' pages from buffer pool to heap

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Moving 'hot' pages from buffer pool to heap
Дата
Msg-id 4267.1375734459@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Moving 'hot' pages from buffer pool to heap  (Atri Sharma <atri.jiit@gmail.com>)
Ответы Re: Moving 'hot' pages from buffer pool to heap  (Atri Sharma <atri.jiit@gmail.com>)
Список pgsql-hackers
Atri Sharma <atri.jiit@gmail.com> writes:
> Just experimenting though.I was thinking of scenarios where a page is pinned for long period of time.My concern was
thatit would lead to blocking of a buffer pool slot for that entire duration. The idea is to allocate a separate data
structurefor 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Disabling ALTER SYSTEM SET WAS: Re: ALTER SYSTEM SET command to change postgresql.conf parameters
Следующее
От: Rodrigo Gonzalez
Дата:
Сообщение: Re: Disabling ALTER SYSTEM SET WAS: Re: ALTER SYSTEM SET command to change postgresql.conf parameters