Re: Buffer Requests Trace

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Lucas Lersch <lucaslersch(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Buffer Requests Trace
Date: 2014-10-14 17:02:12
Message-ID: 20141014170212.GW28859@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

* Lucas Lersch (lucaslersch(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2014-10-14 17:04:00 Re: Expose options to explain? (track_io_timing)
Previous Message Robert Haas 2014-10-14 17:01:24 Re: Expose options to explain? (track_io_timing)