[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Batch update million records in prd DB
From:       Michael Lewis <mlewis () entrata ! com>
Date:       2021-02-26 17:45:59
Message-ID: CAHOFxGqOyhi0XOfTFq-rS=L1H_vBJHzqYW-Y57BJZq_iJae=GA () mail ! gmail ! com
[Download RAW message or body]

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.

>

[Attachment #3 (text/html)]

<div dir="ltr"><div>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.</div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div \
class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> \
</blockquote></div></div> </blockquote></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]