Re: UPDATE on 20 Million Records Transaction or not? - Mailing list pgsql-general

From luis.roberto@siscobra.com.br
Subject Re: UPDATE on 20 Million Records Transaction or not?
Date
Msg-id 552644140.73691855.1592920212865.JavaMail.zimbra@siscobra.com.br
Whole thread Raw
In response to RE: UPDATE on 20 Million Records Transaction or not?  (Jason Ralph <jralph@affinitysolutions.com>)
List 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
updatebetween smaller transactions.
 



pgsql-general by date:

Previous
From: Edu Gargiulo
Date:
Subject: Re: pg_dump empty tables
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump empty tables