Gerhard Wiesinger <li...@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?
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
