| From: | jiye <jiye_sw(at)126(dot)com> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Is there any plan to support online schem change in postgresql? |
| Date: | 2022-10-11 09:43:03 |
| Message-ID: | 176c5286.3c0f.183c66d1d77.Coremail.jiye_sw@126.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
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.
Like what discuss as follow :
https://dba.stackexchange.com/questions/293992/make-alter-table-wait-for-lock-without-blocking-anything-else.
I know that postgres try to avoid rewrite table when alter table happen , and so far, it support serveral ddl using concurrently feature,
Like create indexes. But like alter table add/drop colum, alter column type, it also will trigger rewrtie table . Long term block will make application offline in long times.
So is there any plan to support these ddl online and lock free?if not could you explain the technological difficulty ?
Thanks and wating your respond!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Guo | 2022-10-11 09:49:36 | Re: Remove an unnecessary LSN calculation while validating WAL page header |
| Previous Message | Peter Eisentraut | 2022-10-11 09:02:58 | Re: list of acknowledgments for PG15 |