Drop big index

From: Vojtěch Rylko <vojta(dot)rylko(at)seznam(dot)cz>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Drop big index
Date: 2012-02-15 16:12:26
Message-ID: 4F3BD96A.9050406@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajan, Pavithra 2012-02-15 16:12:44 Re: Dump functions alone
Previous Message Raghavendra 2012-02-15 16:05:24 Re: Dump functions alone