Re: Buffer Requests Trace

Поиск
Список
Период
Сортировка
От Lucas Lersch
Тема Re: Buffer Requests Trace
Дата
Msg-id CAGR3jZB0kv717YY61bMuoyjKQGymJnnNZ_QT=xwpQ0ZeioyN-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Buffer Requests Trace  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Buffer Requests Trace
Список pgsql-hackers
Дерево обсуждения
I see this... but ReleaseBuffer() simply decrements the reference count of page the buffer currently holds. Assuming that a ReadBuffer() - ReleaseBuffer() pattern is used for interacting with the shared_buffers, there will be a ReleaseBuffer() call for any page (heap or index) "loaded" into the shared_buffers.

On Tue, Oct 14, 2014 at 7:21 PM, Stephen Frost <sfrost@snowman.net> wrote:
* Lucas Lersch (lucaslersch@gmail.com) wrote:
> Aren't heap and index requests supposed to go through the shared buffers
> anyway?

Sure they do, but a given page in shared_buffers can be used over and
over again for different heap and index pages..

        Thanks,

                Stephen



--
Lucas Lersch

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Expose options to explain? (track_io_timing)
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Buffer Requests Trace