Skip site navigation (1) Skip section navigation (2)

Re: How to fast the REINDEX

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "raghavendra t" <raagavendra(dot)rao(at)gmail(dot)com>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to fast the REINDEX
Date: 2010-03-31 21:40:04
Message-ID: 4BB37AE402000025000302C5@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-performance
raghavendra t <raagavendra(dot)rao(at)gmail(dot)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

In response to

Responses

pgsql-performance by date

Next:From: raghavendra tDate: 2010-03-31 21:47:22
Subject: Re: How to fast the REINDEX
Previous:From: raghavendra tDate: 2010-03-31 21:33:48
Subject: Re: How to fast the REINDEX

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group