Re: Suggestion on index creation for TEXT data field

Hi David,

Thanks for your email.

>And what type of data exactly are we talking about. ==> Column is stroing
GIS data.

Regards,
PostgAnn.

On Thu, May 21, 2020 at 8:06 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Thu, May 21, 2020 at 7:28 AM postgann2020 s <postgann2020(at)gmail(dot)com>
> wrote:
>
>> which is having an avg width of 149bytes.
>>
>
> The average is meaningless if your maximum value exceeds a limit.
>
> 2. What type of index is the best suited for this type of data?.
>>
>
> And what type of data exactly are we talking about. "TEXT" is not a
> useful answer.
>
> If the raw data is too large no index is going to be "best" - as the hint
> suggests you either need to drop the idea of indexing the column altogether
> or apply some function to the raw data and then index the result.
>
> David J.
>
>