Re: How to fast the REINDEX

From: Kevin Grittner
Subject: Re: How to fast the REINDEX
Date: ,
Msg-id: 4BB37DAB02000025000302D1@gw.wicourts.gov
(view: Whole thread, Raw)
In response to: Re: How to fast the REINDEX  (raghavendra t)
Responses: Re: How to fast the REINDEX  (raghavendra t)
List: pgsql-performance

Tree view

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 by date:

From: Craig Ringer
Date:
Subject: Re: How to fast the REINDEX
From: Steve Clark
Date:
Subject: Re: How to fast the REINDEX