Hi David, Adrian,
Thanks for the information.
Sure, will post on PostGIS community.
Regards,
PostgAnn.
On Thu, May 21, 2020 at 8:21 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, May 21, 2020 at 7:45 AM postgann2020 s
> wrote:
>
>> >And what type of data exactly are we
On Thu, May 21, 2020 at 7:45 AM postgann2020 s
wrote:
> >And what type of data exactly are we talking about. ==> Column is
> stroing GIS data.
>
GIS data isn't really TEXT and isn't a core datatype of PostgreSQL so this
is maybe better posted to the PostGIS community directly...
David J.
On 5/21/20 7:27 AM, postgann2020 s wrote:
Hi Team,
Thanks for your support.
Could you please suggest on below query.
Environment
PostgreSQL: 9.5.15
Postgis: 2.2.7
Mostly table contains GIS data and we are trying to creating an index on
the column which is having an avg width of 149bytes.
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
> wrote:
>
>>
On Thu, May 21, 2020 at 7:28 AM postgann2020 s
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"
Hi Team,
Thanks for your support.
Could you please suggest on below query.
Environment
PostgreSQL: 9.5.15
Postgis: 2.2.7
Mostly table contains GIS data and we are trying to creating an index on
the column which is having an avg width of 149bytes.
CREATE INDEX index_idx
ON SCHEMA.TABLE
