Request a Demo
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 [email protected]
Whole thread Raw
In response to Add column with default value in big table - splitting of updates can help?  (Durumdara <[email protected]>)
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