Postgres Pro
Downloads
Home   >   mailing lists

Re: Add column with default value in big table - splitting ofupdates can help? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: Add column with default value in big table - splitting ofupdates can help?
Date
Msg-id 20200130162021.GA29421@depesz.com
Whole thread Raw
In response to Add column with default value in big table - splitting of updates can help?  (Durumdara <durumdara@gmail.com>)
Responses Re: Add column with default value in big table - splitting of updatescan help?
List pgsql-general
Tree view 
On Thu, Jan 30, 2020 at 04:51:02PM +0100, Durumdara wrote:
> Is there any advance when I split updates? I'm in one transaction.

In this case - no. The benefit of split updates is when you're not in
single transaction.

Why would you want to have it all done in single transaction?

Best regards,

depesz

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Add column with default value in big table - splitting of updatescan help?
Next
From: Adrian Klaver
Date:
Subject: Re: Exclude constraint on ranges : commutative containment : allowonly complete containment