From: | "Arnaud L(dot)" <arnaud(dot)listes(at)codata(dot)eu> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | DROP INDEX hangs |
Date: | 2017-11-08 09:19:27 |
Message-ID: | 178bc1ca-4819-9d8f-b9c0-f82623332618@codata.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all
Using PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 32-bit (on
Windows, obviously).
I noticed that my vacuumdb was hanging on a specific index, so I decided
that the easiest path was to create a duplicate of it (CREATE INDEX
CONCURRENTLY myindex_v2 ...), and drop the original one (DROP INDEX
myindex).
Bad idea : the DROP INDEX command is hanging, doing no IO but using a
full CPU core.
It does not look like it is waiting for a lock (pg_locks show very few
locks right now, and absolutely none related to this pid).
The index is not listed anymore in the table description though
(something was definitively wrong with this index).
I tried to nicely cancel the query via pgadmin, but this does not help.
What can I do ? Should I terminate this backend ? What is the risk of
terminating a drop index operation ?
Thanks for your advices !
--
Arnaud
From | Date | Subject | |
---|---|---|---|
Next Message | Arup Rakshit | 2017-11-08 10:32:55 | filter records by substring match of an postgresql array column |
Previous Message | Michael Paquier | 2017-11-08 00:43:18 | Re: Naming conventions for column names |