Re: How to add columns faster - Mailing list pgsql-general

From Christophe Pettus
Subject Re: How to add columns faster
Date
Msg-id 07126364-A1C1-43A4-93E4-9B07E85B960C@thebuild.com
Whole thread Raw
In response to Re: How to add columns faster  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general

> On Mar 3, 2024, at 12:00, Christophe Pettus <xof@thebuild.com> wrote:
> Remember that dropping the NULL constraint afterwards will require a full table read (although not a rewrite).

Sorry, badly put: Adding a NOT NULl constraint afterwards will require a full table read (although not a rewrite).


pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: How to add columns faster
Next
From: veem v
Date:
Subject: When manual analyze is needed