Re: Question on indexes

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: sud <suds1434(at)gmail(dot)com>
Cc: Erik Wienhold <ewie(at)ewie(dot)name>, xof(at)thebuild(dot)com, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Question on indexes
Date: 2024-10-11 11:29:15
Message-ID: CAKAnmmJW_pmtYLPyO2MONF+L_Wz_8kgPZE881cHPzd7MScrsXA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durgamahesh Manne 2024-10-11 12:31:58 Re: Question on indexes
Previous Message Koen De Groote 2024-10-11 11:08:28 Foreign Data Wrapper behavior?