Postgres Pro
Downloads
Home   >   mailing lists

Re: Buffer Requests Trace - Mailing list pgsql-hackers

From Lucas Lersch
Subject Re: Buffer Requests Trace
Date
Msg-id CAGR3jZB0kv717YY61bMuoyjKQGymJnnNZ_QT=xwpQ0ZeioyN-w@mail.gmail.com
Whole thread Raw
In response to Re: Buffer Requests Trace  (Stephen Frost <sfrost@snowman.net>)
Responses Re: Buffer Requests Trace
List pgsql-hackers
Tree view
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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Expose options to explain? (track_io_timing)
Next
From: Stephen Frost
Date:
Subject: Re: Buffer Requests Trace