Re: using index "pg_toast_..." despite IgnoreSystemIndexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: using index "pg_toast_..." despite IgnoreSystemIndexes
Дата
Msg-id 2570.1346171082@sss.pgh.pa.us
обсуждение исходный текст
Ответ на using index "pg_toast_..." despite IgnoreSystemIndexes  (lsq@nym.hush.com)
Список pgsql-novice
lsq@nym.hush.com writes:
> After an upgrade to 8.4.12 from 8.4.10 we vacuum/analyzed the db.
> Postgres is running in standalone mode at this point.

Why were you using standalone mode?  And why were you using
ignore_system_indexes?  This whole procedure seems like overkill
for a routine minor-version update.

> 07/31/12 04:09:57    WARNING:  using index "pg_toast_2619_index"
> despite IgnoreSystemIndexes

> I see the warning generated in systable_beginscan_ordered as a
> warning, and then it proceeds to do the work anyway.
> It appears as if this is benign.  Is that the case?

It is unless you have some reason to think that that index is corrupt...

            regards, tom lane


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: pgpool
Следующее
От: Michael Rowan
Дата:
Сообщение: Problem with CREATE TRIGGER