Re: How to add columns faster

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: yudhi s <learnerdatabase99(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to add columns faster
Date: 2024-03-03 20:03:07
Message-ID: 07126364-A1C1-43A4-93E4-9B07E85B960C@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mar 3, 2024, at 12:00, Christophe Pettus <xof(at)thebuild(dot)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).

In response to

Browse pgsql-general by date

  From Date Subject
Next Message veem v 2024-03-03 20:03:54 When manual analyze is needed
Previous Message Christophe Pettus 2024-03-03 20:00:03 Re: How to add columns faster