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