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:31:37 |
Message-ID: | CAGR3jZBprqps-SJuBs8paZCwMQO11exZdgGraXiSvgwuk_pEww@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2014-10-14 16:43:07 | Re: Column Redaction |
Previous Message | Stephen Frost | 2014-10-14 16:25:31 | Re: Buffer Requests Trace |