Re: Buffer Requests Trace - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Buffer Requests Trace
Date
Msg-id 20141014170212.GW28859@tamriel.snowman.net
Whole thread Raw
In response to Re: Buffer Requests Trace  (Lucas Lersch <lucaslersch@gmail.com>)
Responses Re: Buffer Requests Trace
List pgsql-hackers
* Lucas Lersch (lucaslersch@gmail.com) wrote:
> shared_buffers is 128MB and the version of pgsql is 9.3.5

I suspect you're not tracking what you think you're tracking, which is
why I brought up shared_buffers.

~14k * 8192 (page size) = ~110MB

What it sounds like you're actually tracking are shared buffer requests
and not heap or index requests.

Now, perhaps the test you're running only touched 110MB of the 6G
database, but that seems pretty unlikely.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Expose options to explain? (track_io_timing)
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Expose options to explain? (track_io_timing)