Re: UPDATE on 20 Million Records Transaction or not?

From: luis(dot)roberto(at)siscobra(dot)com(dot)br
To: Jason Ralph <jralph(at)affinitysolutions(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: UPDATE on 20 Million Records Transaction or not?
Date: 2020-06-23 13:50:12
Message-ID: 552644140.73691855.1592920212865.JavaMail.zimbra@siscobra.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Adrian,
> You could break it down into multiple transactions if there is way to specify ranges of records.
Say I couldn't break it up, would it be faster in or out of the transaction?

It depends whether you have concurrent transactions using the table. If you do, I think it would be better to split the update between smaller transactions.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-06-23 13:56:35 Re: pg_dump empty tables
Previous Message Edu Gargiulo 2020-06-23 13:48:05 Re: pg_dump empty tables