Re: Add column with default value in big table - splitting of updates can help?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Add column with default value in big table - splitting of updates can help?
Date: 2020-01-30 16:20:21
Message-ID: 20200130162021.GA29421@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-01-30 16:49:54 Re: Exclude constraint on ranges : commutative containment : allow only complete containment
Previous Message Adrian Klaver 2020-01-30 15:56:19 Re: Add column with default value in big table - splitting of updates can help?