Re: How to fast the REINDEX

От: Kevin Grittner
Тема: Re: How to fast the REINDEX
Дата: ,
Msg-id: 4BB37AE402000025000302C5@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: How to fast the REINDEX  (raghavendra t)
Ответы: Re: How to fast the REINDEX  (raghavendra t)
Список: pgsql-performance

Скрыть дерево обсуждения

How to fast the REINDEX  (raghavendra t, )
 Re: How to fast the REINDEX  ("Kevin Grittner", )
  Re: How to fast the REINDEX  (raghavendra t, )
   Re: How to fast the REINDEX  ("Kevin Grittner", )
    Re: How to fast the REINDEX  (raghavendra t, )
     Re: How to fast the REINDEX  ("Kevin Grittner", )
      Re: How to fast the REINDEX  (raghavendra t, )
       Re: How to fast the REINDEX  ("Kevin Grittner", )
        Re: How to fast the REINDEX  (raghavendra t, )
         Re: How to fast the REINDEX  (Hannu Krosing, )
   Re: How to fast the REINDEX  (Jaime Casanova, )
    Re: How to fast the REINDEX  (Craig Ringer, )
     Re: How to fast the REINDEX  (Steve Clark, )
      Re: How to fast the REINDEX  ("Pierre C", )
       Re: How to fast the REINDEX  (raghavendra t, )
        Re: How to fast the REINDEX  (Brad Nicholson, )
        Re: How to fast the REINDEX  ("Kevin Grittner", )
        Re: How to fast the REINDEX  (Robert Haas, )
 Re: How to fast the REINDEX  (Greg Smith, )

raghavendra t <> wrote:

> overcome with a corrupted index.

If this is a one-time fix for a corrupted index, did you look at
CREATE INDEX CONCURRENTLY?  You could avoid any down time while you
fix things up.

http://www.postgresql.org/docs/8.4/interactive/sql-createindex.html

-Kevin


В списке pgsql-performance по дате сообщения:

От: Craig Ringer
Дата:
Сообщение: Re: How to fast the REINDEX
От: Steve Clark
Дата:
Сообщение: Re: How to fast the REINDEX