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