Postgres Pro
Downloads
Home   >   mailing lists

Is it good to have toast table for information schema table? - Mailing list pgsql-general

From AI Rumman
Subject Is it good to have toast table for information schema table?
Date
Msg-id CAGoODpesDhSuNdMyi85w+DKMej-+iQsxa2ip2xpZxBhqDUKAfQ@mail.gmail.com
Whole thread Raw
Responses Re: Is it good to have toast table for information schema table?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Using 9.3 as a slave to 9.1 for upgrade purposes
Next
From: Adrian Klaver
Date:
Subject: Re: Is it good to have toast table for information schema table?