Re: Serious Crash last Friday

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Serious Crash last Friday
Дата
Msg-id 14758.1026370833@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Serious Crash last Friday  ("Henrik Steffen" <steffen@city-map.de>)
Список pgsql-general
"Henrik Steffen" <steffen@city-map.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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Henrik Steffen"
Дата:
Сообщение: Re: Serious Crash last Friday
Следующее
От: frbn
Дата:
Сообщение: Re: XML to Postgres conversion