Re: Is there any plan to support online schem change in postgresql?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: jiye <jiye_sw(at)126(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Is there any plan to support online schem change in postgresql?
Date: 2022-10-11 10:05:01
Message-ID: Y0U/zTsvkMtRSUOv@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Junwang Zhao 2022-10-11 10:16:08 Re: Non-decimal integer literals
Previous Message Richard Guo 2022-10-11 09:49:36 Re: Remove an unnecessary LSN calculation while validating WAL page header