Drop big index

Поиск
Список
Период
Сортировка
От Vojtěch Rylko
Тема Drop big index
Дата
Msg-id 4F3BD96A.9050406@seznam.cz
обсуждение исходный текст
Ответы Re: Drop big index
Re: Drop big index
Список 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 по дате отправления: