Postgres Pro
Downloads
Home   >   mailing lists

Re: How to fast the REINDEX - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: How to fast the REINDEX
Date
Msg-id 4BB37AE402000025000302C5@gw.wicourts.gov
Whole thread Raw
In response to Re: How to fast the REINDEX  (raghavendra t <raagavendra.rao@gmail.com>)
Responses Re: How to fast the REINDEX  (raghavendra t <raagavendra.rao@gmail.com>)
List pgsql-performance
Tree view 
raghavendra t <raagavendra.rao@gmail.com> 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 by date:

Previous
From: raghavendra t
Date:
Subject: Re: How to fast the REINDEX
Next
From: raghavendra t
Date:
Subject: Re: How to fast the REINDEX