| From: | Lucas Lersch <lucaslersch(at)gmail(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Buffer Requests Trace |
| Date: | 2014-10-14 16:59:39 |
| Message-ID: | CAGR3jZBg_idL-7Hmd5xchsc-Lm+k67urx3sRa0bY_wWfi3aecQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)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(at)snowman(dot)net> wrote:
>
>> * Lucas Lersch (lucaslersch(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2014-10-14 17:01:24 | Re: Expose options to explain? (track_io_timing) |
| Previous Message | Fabrízio de Royes Mello | 2014-10-14 16:58:45 | Re: CINE in CREATE TABLE AS ... and CREATE MATERIALIZED VIEW ... |