Re: Buffer pool statistics in Explain Analyze - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject Re: Buffer pool statistics in Explain Analyze
Date
Msg-id 20081013112341.8799.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: Buffer pool statistics in Explain Analyze  ("Vladimir Sitnikov" <sitnikov.vladimir@gmail.com>)
Responses Re: Buffer pool statistics in Explain Analyze
List 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 by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: [PATCH] Extending pg_class info + more flexible TOAST chunk size
Next
From: Tom Lane
Date:
Subject: A small note about the difficulty of managing subprojects