Re: Buffer Requests Trace

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

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Expose options to explain? (track_io_timing)
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Expose options to explain? (track_io_timing)