Re: unbalanced indexes -> fixed via dump/restore?

Поиск
Список
Период
Сортировка
От Alfred Perlstein
Тема Re: unbalanced indexes -> fixed via dump/restore?
Дата
Msg-id 20010307234355.C18351@fw.wintelcom.net
обсуждение исходный текст
Ответ на Re: unbalanced indexes -> fixed via dump/restore?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: unbalanced indexes -> fixed via dump/restore?
Список pgsql-general
* Tom Lane <tgl@sss.pgh.pa.us> [010307 14:30] wrote:
> will trillich <will@serensoft.com> writes:
> > A)
> >     pg_dump -c mydb > db.out.sql
> > and then
> >     psql mydb < db.out.sql
> > periodically?
>
> > or is it better to
>
> > B) merely 'reindex' on occasion?
>
> Plain old DROP INDEX / CREATE INDEX is probably the best-trodden path.
> Your (A) seems like vastly more work than is needed.  (B) might be
> marginally easier than DROP/CREATE, but I'm not sure how much I trust
> REINDEX; it's not been around all that long.

Is there a way to do this atomically, meaning so that no one can
get at the table after dropping, but before recreating the index?

lock the table during?

--
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]

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

Предыдущее
От: "chris markiewicz"
Дата:
Сообщение: length of insert stmt?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unbalanced indexes -> fixed via dump/restore?