Re: How to fast the REINDEX

От: Kevin Grittner
Тема: Re: How to fast the REINDEX
Дата: ,
Msg-id: 4BB37DAB02000025000302D1@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:

> my question is, how to get a performance on the existing indexes.
> You mean to say , drop the existing indexes and create the index
> with CONCURRENTLY. Does this give the performance back.

You would normally want to create first and then drop the old ones,
unless the old ones are hopelessly corrupted.  Since you still
haven't given me any information to suggest you need to reindex
except for the mention of corruption, or any information to help
identify where the performance bottleneck is, I can't see any other
improvements to suggest at this point.

-Kevin


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

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