Re: Buffer Requests Trace

Поиск
Список
Период
Сортировка
От Lucas Lersch
Тема Re: Buffer Requests Trace
Дата
Msg-id CAGR3jZBprqps-SJuBs8paZCwMQO11exZdgGraXiSvgwuk_pEww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Buffer Requests Trace  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: Buffer Requests Trace
Список 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@snowman.net> wrote:
* Lucas Lersch (lucaslersch@gmail.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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Buffer Requests Trace
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Column Redaction