Hi All,
Thank you for your support.
Yes, i tried with pg_buffercache, it is giving the information on the hit ratio of shared_buffers. Can we get the dynamic information like in oracle(v$) views. Same as in postgresql buffers(shared,temp,wal) & cache(maintainence_work_me, effective_mem).
Thanks & Regards
Raghavendra
2010/4/13 <tv@xxxxxxxx>
It's not accessible by default, but there is contrib package called> raghavendra t wrote:
>> Hi All,
>>
>> Could please guide me in knowing the Dynamic Catalog views which will
>> tell about the Buffers and Cache information using System Catalogs.
>>
>
> you mean, stuff like
> http://www.postgresql.org/docs/current/static/catalog-pg-statistic.html ?
>
> afaik, data about whats in the cache and buffers is not accessible via
> any pg_catalog schema tables.
'pg_buffercache':
I guess that might provide the information about buffers.
Tomas
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
