Re: Dynamic Catalog Views

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(at)fuzzy(dot)cz>

> > 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.
>
> It's not accessible by default, but there is contrib package called
> 'pg_buffercache':
>
> http://www.postgresql.org/docs/8.4/interactive/pgbuffercache.html
>
> I guess that might provide the information about buffers.
>
> Tomas
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>