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 <t...@fuzzy.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
