Thank you for the suggestion. On Thu, Apr 1, 2010 at 3:21 AM, Kevin Grittner <kevin.gritt...@wicourts.gov>wrote:
> raghavendra t <raagavendra....@gmail.com> 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 >