Postgres Pro
Downloads
Home   >   mailing lists

[HACKERS] ToDo: no blocking (waiting) DDL - Mailing list pgsql-hackers

From Pavel Stehule
Subject [HACKERS] ToDo: no blocking (waiting) DDL
Date
Msg-id CAFj8pRCJhhw_8y28nEu9MxbZ+=4CofQBqb9XNSfqU6c17YGU=A@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] ToDo: no blocking (waiting) DDL
List pgsql-hackers
Tree view
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

pgsql-hackers by date:

Previous
From: Ian Jackson
Date:
Subject: Re: [HACKERS] [OSSTEST PATCH 0/1] PostgreSQL db: Retry on constraint violation [and 2 more messages]
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] ToDo: no blocking (waiting) DDL