"Eric Anderson Vianet SAO" <eric@vianet-express.com.br> writes:
> How can I discover which toast table referenced to a phisic table?
Look at the base table's pg_class row. reltoastrelid is the OID of the
corresponding toast table. So, for example, if I thought "text_tbl" had
such a problem:
regression=# select relname from pg_class where
regression-# oid = (select reltoastrelid from pg_class where relname = 'text_tbl'); relname
-----------------pg_toast_163219
(1 row)
regression=# reindex table pg_toast.pg_toast_163219;
REINDEX
regression=#
regards, tom lane
