Needs Suggestion

Поиск
Список
Период
Сортировка
От SUBHAM ROY
Тема Needs Suggestion
Дата
Msg-id BANLkTim2YCN0duhVsDz6rYUrPjLztRfUyw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Needs Suggestion
Список pgsql-general
My output of explain (analyze,buffers) is something like this:

shared hit=3796624 read=46038

So what is meant by read here? Does it indicates number of disk reads?

Does shared hit takes into account only the hit in the pg_buffercache of the postgres or it also takes into account the linux buffers that postgres uses?

--
Thank You,
Subham Roy,
CSE IIT Bombay.

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

Предыдущее
От: Tian Luo
Дата:
Сообщение: "full_page_writes" makes no difference?
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Needs Suggestion