Re: Allowing multiple DDL commands to run simultaneously

2018-07-17 Thread Simon Riggs
On 17 July 2018 at 19:47, Robert Haas wrote: > On Mon, Jul 9, 2018 at 6:00 AM, Simon Riggs wrote: >> Proposal would be to add a new lock mode "ShareUpdate", which does not >> conflict with itself and yet conflicts with "ShareUpdateExclusive" or >> higher. (Hence, it is a strong lock type). DDL wo

Re: Allowing multiple DDL commands to run simultaneously

2018-07-17 Thread Robert Haas
On Mon, Jul 9, 2018 at 6:00 AM, Simon Riggs wrote: > Proposal would be to add a new lock mode "ShareUpdate", which does not > conflict with itself and yet conflicts with "ShareUpdateExclusive" or > higher. (Hence, it is a strong lock type). DDL would take a > ShareUpdateLock on the table, then dur

Allowing multiple DDL commands to run simultaneously

2018-07-09 Thread Simon Riggs
We use the word CONCURRENTLY to describe DDL that executes without preventing select, insert, update or delete against a table. That is not the topic discussed here. I've been asked if we could consider allowing more types of DDL to run at the same time as each other. Specifically, that all/most o