2012/1/10 Ondrej Ivanič <ondrej.iva...@gmail.com>: >> One area where the documentation is not very detailed - What are the side >> effects and/or constraints put in place while an index is being moved? I >> assume that the index will not be available to the query planner/engine >> during that time period. Are there other ways in which the table (and other >> indices) are affected or locked? > > yes, you are right there is not too much about "alter index" locking > in the docs. When I did this last time (PG 8.4) 'alter index' acquired > 'ACCESS EXCLUSIVE' lock.
To avoid it I usually do CREATE INDEX ... TABLESPACE ... / DROP INDEX ... / ALTER INDEX ... RENAME ... > > -- > Ondrej Ivanic > (ondrej.iva...@gmail.com) > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com LinkedIn: http://ru.linkedin.com/in/grayhemp JID/GTalk: gray...@gmail.com Skype: gray-hemp -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
