Background Let us list databases. Code Outline Access pg_catalog.pg_database pg_catalog.pg_tablespace Default Table space Name pg_database.dattablespace = pg_tablespace.oid pg_catalog.pg_authid Authorizer pg_database.datdba = pg_authid.oid pg_catalog.pg_encoding_to_char Encoding pg_catalog.pg_encoding_to_char(pg_database.encoding ) pg_catalog.pg_stat_file Database Creation Date pg_catalog.pg_stat_file ( 'base' ||'/' ||pg_database.oid ||'/' ||'PG_VERSION' ) SQL Output References PostgreSQL Functions and Operators System Administrative Functions Link
Background Of course, we rarely have enough memory. And, so we have to remain vigilant as to what objects are squabbling over memory. Code Extension :- pg_buffercache Registration Pleas ensure that pg_buffercache is registered. Registration steps are outlined here. Outline Get Buffer Size Object :- pg_settings name => shared_buffers setting => value Get Objects … Continue reading PostgreSQL :- What is in our buffer cache ?