Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS)

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS)
Дата
Msg-id 20180430031318.k3skm4gfy7okcsnr@alap3.anarazel.de
обсуждение исходный текст
Ответ на Accounting of zero-filled buffers in EXPLAIN (BUFFERS)  (Thomas Munro <thomas.munro@enterprisedb.com>)
Ответы Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS)  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список pgsql-hackers
On 2018-04-30 14:59:31 +1200, Thomas Munro wrote:
> Hi,
> 
> In EXPLAIN (BUFFERS), there are two kinds of cache misses that show up
> as "reads" when in fact they are not reads at all:
> 
> 1.  Relation extension, which in fact writes a zero-filled block.
> 2.  The RBM_ZERO_* modes, which provoke neither read nor write.

Just for understanding: 2) can never happen for buffers showing up in
EXPLAIN, right?

I'm not saying you shouldn't fix the accounting...

Greetings,

Andres Freund


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

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Accounting of zero-filled buffers in EXPLAIN (BUFFERS)
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Accounting of zero-filled buffers in EXPLAIN (BUFFERS)