Hi, I would like to know for all the entries inside pg_class table (except for shared tables and views), does the relfilenode field always correspond to a physical file on the disk at a given moment? Could there be any inconsistency between the table entry and the actual file? Or this is only true when the database is fresh started up without any active connection? Or there is no guarantee at all? Also, I have seen some posts earlier regarding to can't drop a certain table because of the corrupted database, Tom suggests deleting the entry inside pg_class. Is that enough for 7.2.3? Will vacuum automatically do the actual clean up for those unlinked indexes/physical files? I remember once I have to do something to pg_type or some other tables. If that's not enough, what other tables I should pay attention to as well? http://archives.postgresql.org/pgsql-general/2002-10/msg01371.php Thanks, --muteki ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
