ToDo: no blocking (waiting) DDL

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: ToDo: no blocking (waiting) DDL
Date: 2016-12-13 11:44:32
Message-ID: CAFj8pRCJhhw_8y28nEu9MxbZ+=4CofQBqb9XNSfqU6c17YGU=A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I don't remember well, there was maybe similar ToDo.

Yesterday I got a incident on high load system when I executed DROP INDEX
cmd.

This statement waited on a finish of long transaction, but it stopped any
other statements.

Can be nice when waiting on lock statement doesn't block another
statements.

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2016-12-13 12:03:37 Re: ToDo: no blocking (waiting) DDL
Previous Message Ian Jackson 2016-12-13 11:30:28 Re: [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation [and 2 more messages]