Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux