Re: Importance of re-index

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Importance of re-index
Дата
Msg-id 1154703657.7882.96.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Re: Importance of re-index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Thu, 2006-08-03 at 18:03, Tom Lane wrote:
> Scott Marlowe <smarlowe@g2switchworks.com> writes:
> > Reindex was originally
> > designed to fix broken indexes, and, at least in earlier encarnations,
> > should something stop it in the middle of reindexing I believe it is
> > possible to be left with no index.
>
> That was once true but these days reindex is perfectly crash-safe.  The
> only case where it's not is where you want to reindex a shared catalog's
> index (eg one of pg_database's), and we don't let you do that in
> multiuser mode anyway.

Oh cool! nice to know that's since been fixed.

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Create function problem
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: PITR Questions