Re: Is there any plan to support online schem change in postgresql? - Mailing list pgsql-hackers

From hubert depesz lubaczewski
Subject Re: Is there any plan to support online schem change in postgresql?
Date
Msg-id Y0U/zTsvkMtRSUOv@depesz.com
Whole thread Raw
In response to Is there any plan to support online schem change in postgresql?  (jiye <jiye_sw@126.com>)
Responses Re:Re: Is there any plan to support online schem change in postgresql?  (jiye <jiye_sw@126.com>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Remove an unnecessary LSN calculation while validating WAL page header
Next
From: Junwang Zhao
Date:
Subject: Re: Non-decimal integer literals