On Tue, Oct 11, 2022 at 05:43:03PM +0800, jiye wrote: > As we know postgres using high level lock when do alter table or other ddl > commands, > It will block any dml operation, while it also will block by long term dml > operation.
Most of the things can be already done in non-blocking (or almost non-blocking way) if you just do it in a way that takes concurrency into account. Specifically - I have no problem adding/deleting columns. Best regards, depesz
