Re: Serious Crash last Friday

"Henrik Steffen" <steffen(at)city-map(dot)de> writes:
> yes, you are right 16584 is the oid of the table altseiten, but the
> reltoastidxid is still 0.

Oh, my mistake --- you have to look at the toast table identified by
reltoastrelid, and then its reltoastidxid fingers the index. For
example:

test72=# create table foo (t text);
CREATE
test72=# select oid,relname,relkind,reltoastrelid,reltoastidxid from pg_class order by oid desc limit 5;
oid | relname | relkind | reltoastrelid | reltoastidxid
--------+---------------------+---------+---------------+---------------
812033 | pg_toast_812029_idx | i | 0 | 0
812031 | pg_toast_812029 | t | 0 | 812033
812029 | foo | r | 812031 | 0
812026 | manufacturer_z_key | i | 0 | 0
812024 | manufacturer | r | 0 | 0
(5 rows)

Here, foo is the base table, pg_toast_812029 is its toast table,
pg_toast_812029_idx is the index.

regards, tom lane