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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
