MIME-Version: 1.0
References: <CAEzWdqd-22B-bpVdT3yzegiOig9zvJnfJvi=GOMFfHT-Jg8CgQ@mail.gmail.com>
 <CA+FnnTxqBu+eM1G-8LQhGXEqSdndUYPEk6rc4zSspCivRf9CZQ@mail.gmail.com> <CAEzWdqdMvMZx26orbRSbNH_uvZLon16R79b23M-H1D8Ky62Hbw@mail.gmail.com>
In-Reply-To: <CAEzWdqdMvMZx26orbRSbNH_uvZLon16R79b23M-H1D8Ky62Hbw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Sat, 14 Sep 2024 10:47:28 -0400
Message-ID: <CANzqJaD-dmM6yi+OL0kcMDyeb4C=KmHeiKPqNThmYFd15NQwug@mail.gmail.com>
Subject: Re: update faster way
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d74d3b0622156be8"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaD-dmM6yi%2BOL0kcMDyeb4C%3DKmHeiKPqNThmYFd15NQwug%40mail.gmail.com>
Precedence: bulk

--000000000000d74d3b0622156be8
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Sep 13, 2024 at 11:59=E2=80=AFPM yudhi s <learnerdatabase99@gmail.c=
om>
wrote:

>
>>
>> Do you have any indexes?
>> If not - you should, if yes - what are they?
>>
>>
>>
> Yes we have a primary key on this table which is on a UUID type column an=
d
> also we have other indexes in other timestamp columns . But how is this
> going to help as we are going to update almost all the rows in the table?
>

But do you have an index on tab_part1.column1?

And how slow is subquery?

--000000000000d74d3b0622156be8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Sep 13, 2024 at 11:59=E2=80=AFPM =
yudhi s &lt;<a href=3D"mailto:learnerdatabase99@gmail.com">learnerdatabase9=
9@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div class=3D"gmail_=
quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;=
border-left:1px solid rgb(204,204,204);padding-left:1ex"><br><br>
Do you have any indexes?<br>
If not - you should, if yes - what are they?<br>
<br><br></blockquote><div><br></div><div>Yes we have a primary key on this =
table which is on a UUID type column and also we have other indexes in othe=
r timestamp columns . But how is this going to help as we are going to upda=
te=C2=A0almost all the rows in the table?</div></div></div>
</blockquote></div><br clear=3D"all"><div>But do you have an index on tab_p=
art1.column1?</div><div><br></div><div>And how slow is subquery?</div><br><=
/div>

--000000000000d74d3b0622156be8--