Re: cache lookup failed for index

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: cache lookup failed for index
Дата
Msg-id 4C2B26D10200002500032D97@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: cache lookup failed for index  (Nathan Robertson <nathan.robertson@gmail.com>)
Список pgsql-admin
Nathan Robertson <nathan.robertson@gmail.com> wrote:

> My thinking based on the documentation is I run (as postgres
> user):
> postgres -O -P -D /dbcluster/location

Looks good to me.  In fact, I hadn't remembered the -P option;
definitely a good choice here, and it should obviate the need to try
to disable the index usage using the commands I showed.

> Then I run:
> REINDEX TABLE pg_class_oid_in;

You either need to specify the INDEX keyword or a table name.
Perhaps this would be best:

REINDEX TABLE pg_class;

-Kevin

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

Предыдущее
От: Nathan Robertson
Дата:
Сообщение: Re: cache lookup failed for index
Следующее
От: Tom Lane
Дата:
Сообщение: Re: cache lookup failed for index