On Tue, Oct 11, 2022 at 08:31:53PM +0800, jiye wrote:
> But, as follow, if txn1 not commit (just like long term readonly txn), it will block txn2's ddl job, why alt add/drop column can not concurrently with read only access?
> txn1： long term txn not commit access t1.
> txn2 waiting txn1 to commit or abort.
> txn3 wait txn2...
1. Please don't share code as screenshots.
2. If I understand your text above correctly, then the solution is
trivial:
https://www.depesz.com/2019/09/26/how-to-run-short-alter-table-without-long-locking-concurrent-queries/
depesz