Is it good to have toast table for information schema table?

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Is it good to have toast table for information schema table?
Date: 2014-04-22 23:58:07
Message-ID: CAGoODpesDhSuNdMyi85w+DKMej-+iQsxa2ip2xpZxBhqDUKAfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is it good to have toast table for information schema table? I am using
Postgresql 8.4 and current state is:

*select datname, datfrozenxid from pg_database; *
datname | datfrozenxid
-----------+--------------
template1 | 1462730397
template0 | 1462741467
postgres | 1562754912
jangles | 1459615432
(4 rows)

*select * from pg_class where relfrozenxid = 1459615432;*
relname | reltoastidxid | relhasindex | relfrozenxid
----------------+---------------+-------------+--------------
pg_toast_11447 | 11451 | t | 1459615432
(1 row)

*select 11447::regclass; *
regclass
---------------------------------
information_schema.sql_features
(1 row)

Please advice.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2014-04-23 00:42:57 Re: Is it good to have toast table for information schema table?
Previous Message Adrian Klaver 2014-04-22 23:20:01 Re: Using 9.3 as a slave to 9.1 for upgrade purposes