Drop big index - Mailing list pgsql-general

From Vojtěch Rylko
Subject Drop big index
Date
Msg-id 4F3BD96A.9050406@seznam.cz
Whole thread Raw
Responses Re: Drop big index
Re: Drop big index
List pgsql-general
Hi,

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?

Regards,
Vojta R.

pgsql-general by date:

Previous
From: Raghavendra
Date:
Subject: Re: Dump functions alone
Next
From: "Bob Pawley"
Date:
Subject: DDL Triggers