| From: | Alberto Piai <alberto(dot)piai(at)gmail(dot)com> |
|---|---|
| To: | Alberto Piai <alberto(dot)piai(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Adding a stored generated column without long-lived locks |
| Date: | 2026-04-24 09:10:22 |
| Message-ID: | DI19FP3X4VI0.21FO6V1HGJK5P@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue Apr 7, 2026 at 5:02 PM +08, Alberto Piai wrote:
> On Tue Mar 17, 2026 at 5:31 PM +07, Alberto Piai wrote:
>
>> I recently needed to add a stored generated column to a table of
>> nontrivial size, and realized that currently there is no way to do
>> that without rewriting the table under an AccessExclusiveLock.
Attached v3, just a rebase onto current master.
Regards,
Alberto
--
Alberto Piai
Sensational AG
Zürich, Switzerland
| Attachment | Content-Type | Size |
|---|---|---|
| v3-0001-Support-changing-a-column-into-a-stored-generated.patch | text/x-patch | 22.3 KB |
| v3-0002-Try-to-avoid-a-rewrite-when-adding-a-stored-gener.patch | text/x-patch | 23.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vignesh C | 2026-04-24 09:28:23 | Re: StringInfo fixes, v19 edition. Plus a few oddities |
| Previous Message | Chao Li | 2026-04-24 09:05:28 | Re: pgbench: make verbose error messages thread-safe |