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