| 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: | Whole Thread | Raw Message | 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 |