MIME-Version: 1.0
References: <CAEzWdqd-22B-bpVdT3yzegiOig9zvJnfJvi=GOMFfHT-Jg8CgQ@mail.gmail.com>
 <CA+FnnTxqBu+eM1G-8LQhGXEqSdndUYPEk6rc4zSspCivRf9CZQ@mail.gmail.com>
In-Reply-To: <CA+FnnTxqBu+eM1G-8LQhGXEqSdndUYPEk6rc4zSspCivRf9CZQ@mail.gmail.com>
From: yudhi s <learnerdatabase99@gmail.com>
Date: Sat, 14 Sep 2024 09:28:52 +0530
Message-ID: <CAEzWdqdMvMZx26orbRSbNH_uvZLon16R79b23M-H1D8Ky62Hbw@mail.gmail.com>
Subject: Re: update faster way
To: Igor Korot <ikorot01@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000054c03006220c5c1c"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqdMvMZx26orbRSbNH_uvZLon16R79b23M-H1D8Ky62Hbw%40mail.gmail.com>
Precedence: bulk

--00000000000054c03006220c5c1c
Content-Type: text/plain; charset="UTF-8"

>
>
>
> 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 and
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?

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

<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quot=
e" 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>

--00000000000054c03006220c5c1c--