Re: Buffer Requests Trace - Mailing list pgsql-hackers

From Lucas Lersch
Subject Re: Buffer Requests Trace
Date
Msg-id CAGR3jZBg_idL-7Hmd5xchsc-Lm+k67urx3sRa0bY_wWfi3aecQ@mail.gmail.com
Whole thread Raw
In response to Re: Buffer Requests Trace  (Lucas Lersch <lucaslersch@gmail.com>)
Responses Re: Buffer Requests Trace
List pgsql-hackers
shared_buffers is 128MB and the version of pgsql is 9.3.5

On Tue, Oct 14, 2014 at 6:31 PM, Lucas Lersch <lucaslersch@gmail.com> wrote:
Sorry, I do not understand the question.

But I forgot to give an additional information: I am printing the page id for the trace file in ReleaseBuffer() only if it is a shared buffer, I am not considering local buffers. I assumed that local buffers were used only for temporary tables.

On Tue, Oct 14, 2014 at 6:25 PM, Stephen Frost <sfrost@snowman.net> wrote:
* Lucas Lersch (lucaslersch@gmail.com) wrote:
> Unfortunately, in the generated trace with over 2 million buffer requests,
> only ~14k different pages are being accessed, out of the 800k of the whole
> database. Am I missing something here?

What do you have shared_buffers set to..?

        Thanks,

                Stephen



--
Lucas Lersch



--
Lucas Lersch

pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: CINE in CREATE TABLE AS ... and CREATE MATERIALIZED VIEW ...
Next
From: Robert Haas
Date:
Subject: Re: Expose options to explain? (track_io_timing)