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.g.johns...@gmail.com> wrote: > On Thu, May 21, 2020 at 7:28 AM postgann2020 s <postgann2...@gmail.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. > >
