pg_buffercache - A lot of "unnamed" relfilenodes?

From: Gerhard Wiesinger <lists(at)wiesinger(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_buffercache - A lot of "unnamed" relfilenodes?
Date: 2009-09-26 17:53:27
Message-ID: alpine.LFD.2.00.0909261948590.19441@bbs.intern
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

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).

SELECT
relname IS NULL AS relame_is_null,
isdirty,
COUNT(*) AS count
FROM
pg_buffercache b
LEFT OUTER JOIN pg_class c ON b.relfilenode=c.relfilenode
GROUP BY
relame_is_null,
isdirty
;

relame_is_null isdirty count
false false 8914
true false 7347
true true 123

Any ideas of this behavior because inserts should have assigned relnames,
shouldn't they?

Thnx.

Ciao,
Gerhard

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-09-26 17:57:27 Re: Solaris Postgres
Previous Message Zdenek Kotala 2009-09-26 17:34:13 Re: Solaris Postgres