Re: pg_buffercache - A lot of "unnamed" relfilenodes? - Mailing list pgsql-general

On Sat, 26 Sep 2009, Tom Lane wrote:

> Gerhard Wiesinger <lists@wiesinger.com> writes:
>> Research on the pg_bufferache showed that a lot of pages don't have any
>> assigned relfilenodesin pg_class, even when they are dirty (in this case
>> inserts are done).
>
> There should never be any buffered pages for nonexistent tables.  The
> method you are using will only show relnames for pages belonging to
> tables of the current database ... maybe there are a lot of dirty pages
> for other databases in the cluster?  Or maybe the tables are newly
> created (not committed) and so you can't see their pg_class rows yet?
>

OK, this is a visibility problem of the databases. Is it possible to GRANT
visibility for e.g. one user to all databases for pg_class?

Thnx.

Ciao,
Gerhard

--
http://www.wiesinger.com/