pg_buffercache - A lot of "unnamed" relfilenodes?

Поиск
Список
Период
Сортировка
От Gerhard Wiesinger
Тема pg_buffercache - A lot of "unnamed" relfilenodes?
Дата
Msg-id alpine.LFD.2.00.0909261948590.19441@bbs.intern
обсуждение исходный текст
Ответы Re: pg_buffercache - A lot of "unnamed" relfilenodes?  (Tom Lane <tgl@sss.pgh.pa.us>)
psql: FATAL: role "postgres" does not exist  (Martin Gainty <mgainty@hotmail.com>)
Список 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/


В списке pgsql-general по дате отправления:

Предыдущее
От: Zdenek Kotala
Дата:
Сообщение: Re: Solaris Postgres
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Solaris Postgres