Re: Buffer pool statistics in Explain Analyze

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: Buffer pool statistics in Explain Analyze
Дата
Msg-id 20081013112341.8799.52131E4D@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: Buffer pool statistics in Explain Analyze  ("Vladimir Sitnikov" <sitnikov.vladimir@gmail.com>)
Ответы Re: Buffer pool statistics in Explain Analyze  ("Vladimir Sitnikov" <sitnikov.vladimir@gmail.com>)
Список pgsql-hackers
"Vladimir Sitnikov" <sitnikov.vladimir@gmail.com> wrote:

> I've tried to use "ReadBufferCount and friends" from
> storage\buffer\buf_init.c, however it is showing zeroes for some unknown yet
> reason. Hope, there is no fundamental problem behind.

I think those vairables are hard to use and have no reliability
for your purpose.

How about adding buffer usage counters into HeapScanDesc and IndexScanDesc?
It requires only changes in ReadBufferWithStrategy and lower layer functions.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




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

Предыдущее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: [PATCH] Extending pg_class info + more flexible TOAST chunk size
Следующее
От: Tom Lane
Дата:
Сообщение: A small note about the difficulty of managing subprojects