Re: Batch update million records in prd DB

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Yi Sun <yinan81(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Batch update million records in prd DB
Date: 2021-02-26 17:45:59
Message-ID: CAHOFxGqOyhi0XOfTFq-rS=L1H_vBJHzqYW-Y57BJZq_iJae=GA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It might be a concern, but generally that should be a row level lock and
only block other update/delete options on those rows. It might be helpful
to look at the explain analyze output early on vs later in the process. It
might be that you are getting very few hot updates and indexes are being
updated constantly.

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2021-02-26 18:02:11 Re: PostgreSQL URI
Previous Message Paul Förster 2021-02-26 16:21:42 Re: PostgreSQL URI