| From: | "Sorin N(dot) Ciolofan" <ciolofan(at)ics(dot)forth(dot)gr> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | pg_buffercache view |
| Date: | 2007-04-24 10:04:16 |
| Message-ID: | 20070424100322.7E7EE8E40FC@mailhost.ics.forth.gr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Dear all,
About the pg_buffercache view:
I couldn't find the description for this view in the manual at
http://www.postgresql.org/docs/8.2/interactive/catalogs.html
However I found the readme file provided in the /contrib./pg_buffercache of
the source code for version 8.2.3
Here it's written the following description:
Column | references | Description
----------------+----------------------+------------------------------------
bufferid | | Id, 1..shared_buffers.
relfilenode | pg_class.relfilenode | Refilenode of the relation.
reltablespace | pg_tablespace.oid | Tablespace oid of the relation.
reldatabase | pg_database.oid | Database for the relation.
relblocknumber | | Offset of the page in the
relation.
isdirty | | Is the page dirty?
I've 2 questions:
1)
I was not able to find the field "oid" from pg_database view. Could you
please tell me what is the actual name of the column for which reldatabase
is reffering to?
2)
In readme file is also written:
"Unused buffers are shown with all fields null except buffered".
A "used" buffer means that is used 100% or could it be filled only
partially?
Is there any way to know at a certain moment with precision how much shared
memory expressed in Mb is used?
With best regards,
Sorin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2007-04-24 13:02:54 | Re: [GENERAL] pg_buffercache view |
| Previous Message | Alexander Staubo | 2007-04-24 09:31:11 | Re: [GENERAL] Regarding WAL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pat Maddox | 2007-04-24 10:33:15 | Re: Setting table ids in slony |
| Previous Message | Alexander Staubo | 2007-04-24 09:31:11 | Re: [GENERAL] Regarding WAL |