Vojtech Rylko wrote: > I need to drop some b-tree indexes because they are not used anymore. > Size of indexes vary between 700 MB and 7 GB. I tried common DROP > INDEX... but this query performed so long and blocked table so I had to > interrupt it. Is there any way how to drop large indexes in non-blocking > or /faster/ way?
Unfortunately not (yet). PostgreSQL 9.2 will have DROP INDEX CONCURRENTLY. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
