Re: reindex script

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>,<silvio(dot)brandani(at)tech(dot)sdb(dot)it>
Subject: Re: reindex script
Date: 2010-11-10 13:14:01
Message-ID: 4CDA46390200002500037500@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Silvio Brandani wrote:

> Is it possible to use a reindex in a share lock mode ??

Check out the CONCURRENTLY keyword in CREATE INDEX:

http://www.postgresql.org/docs/current/interactive/sql-createindex.html

You could create a duplicate index concurrently, drop the old index,
and rename the new one to the old name.

-Kevin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Silvio Brandani 2010-11-10 15:57:09 Re: reindex script
Previous Message Silvio Brandani 2010-11-10 10:33:03 reindex script