Postgres Pro
Downloads
Home   >   mailing lists

About deadlock for drop index command on big size table - Mailing list pgsql-general

From emilu@encs.concordia.ca
Subject About deadlock for drop index command on big size table
Date
Msg-id 20200121091700.jau33xt1nosk8ogc@mail.encs.concordia.ca
Whole thread Raw
List pgsql-general
Tree view 
Hello,

I tried to call drop index on a big table(around 3 million records)  
through non-multi thread script, and got deadlock.

Same drop index command in the same script on a smaller size table no  
deadlock returned.

May I know that may cause the problem please?

Thanks a lot.

[Block info]
  blocking_pid | blocked_pid | blocked_query
--------------+-------------+---------------
          123 | 7298 | DROP index idx1
          123 | 7298 | DROP index idx1

pgsql-general by date:

Previous
From: Ekaterina Amez
Date:
Subject: Re: Questions about how to streaming replication (pg 9.2)
Next
From: Nicola Contu
Date:
Subject: Re: ERROR: too many dynamic shared memory segments