MIME-Version: 1.0
References: <CAD=mzVWLN35FHPxN0Ajh2vnDkFLyg9f0vT6EKF9uPm7CYkHS5g@mail.gmail.com>
 <88e5c335-c70e-4973-9b71-6c12e251e5b7@ewie.name> <CAD=mzVWHC8O+fLksgc-uKAcq19xQSVvHz1AsButFmL+xh0_btg@mail.gmail.com>
In-Reply-To: <CAD=mzVWHC8O+fLksgc-uKAcq19xQSVvHz1AsButFmL+xh0_btg@mail.gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Fri, 11 Oct 2024 07:29:15 -0400
Message-ID: <CAKAnmmJW_pmtYLPyO2MONF+L_Wz_8kgPZE881cHPzd7MScrsXA@mail.gmail.com>
Subject: Re: Question on indexes
To: sud <suds1434@gmail.com>
Cc: Erik Wienhold <ewie@ewie.name>, xof@thebuild.com, 
	pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000308516062431ce2e"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmJW_pmtYLPyO2MONF%2BL_Wz_8kgPZE881cHPzd7MScrsXA%40mail.gmail.com>
Precedence: bulk

--000000000000308516062431ce2e
Content-Type: text/plain; charset="UTF-8"

>
> if we have any column with large string/text values and we want it to be
> indexed then there is no choice but to go for a hash index. Please correct
> me if I'm wrong.
>

There are other strategies / solutions, but we would need to learn more
about your use case.

Cheers,
Greg

--000000000000308516062431ce2e
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"><div dir=3D"ltr"><div class=3D"gmail_quote">if we have a=
ny column with large string/text values and we want it to be indexed then t=
here is no choice but to go for a hash index. Please correct me if I&#39;m =
wrong.<br></div></div></blockquote><div><br></div><div>There are other stra=
tegies / solutions, but we would need to learn more about your use case.</d=
iv><div><br></div><div>Cheers,</div><div>Greg</div><div>=C2=A0</div></div><=
/div>

--000000000000308516062431ce2e--