raghavendra t wrote:
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).
The information available in this area includes:
1) Look at buffer cache hit rates using pg_stat_user_tables,
pg_st
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
> 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, dat
On 13 April 2010 05:31, 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.
Look at pg_buffercache contrib.
http://www.postgresql.org/docs/8.4/interactive/pgbuffercache.html
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 i
Hi All,
Could please guide me in knowing the Dynamic Catalog views which will tell
about the Buffers and Cache information using System Catalogs.
Thanks in Advance
Regards
Raghavendra
