RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A23018D11@SECTORBASE1
обсуждение исходный текст
Список pgsql-hackers
> I've tried:
> 
> bin/postgres -O -P -D `pwd`/data horde
> 
> POSTGRES backend interactive interface
> $Revision: 1.155.2.1 $ $Date: 2000/08/30 21:19:32 $
> 
> backend> reindex database horde;
> backend> 
> 
> still get it ...
> 
> I'm either doing something wrong with REINDEXng the system 
> tables, or this isn't what hte problem is :(

I'm not sure how REINDEX works... to restore after some crashes
REINDEX should 1. drop indices; 2. vacuum table(s); 3. create indices
(note - create index *after* table itself is vacuumed).

Vadim


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

Предыдущее
От: "Mikheev, Vadim"
Дата:
Сообщение: RE: pgsql is 75 times faster with my new index scan
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: Damn, pg_proc index corrupted, can't find anythign on REINDEX ...