Suggestion to improve query performance of data validation in proc.

2020-05-21 Thread postgann2020 s
Hi Team, Thanks for your support. Could you please suggest on below query. We have multiple long procs that are having 100s of data validations and currently we have written as below. *** if (SELECT 1 FROM SCHEMA.TABLE WHERE column=data AND column=data) then statements etc.. *

Re: Suggestion on index creation for TEXT data field

2020-05-21 Thread postgann2020 s
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 tal

Re: Suggestion on index creation for TEXT data field

2020-05-21 Thread David G. Johnston
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.

Re: Suggestion on table analyze

2020-05-21 Thread postgann2020 s
Hi Adrian, Thanks, I'll check it out. Regards, PostgAnn. On Thu, May 21, 2020 at 8:11 PM Adrian Klaver wrote: > On 5/21/20 7:18 AM, postgann2020 s wrote: > > Hi Team, > > > > Thanks for your support. > > > > Could you please suggest on below query. > > > > Environment > > PostgreSQL: 9.5.15 >

Re: Suggestion on index creation for TEXT data field

2020-05-21 Thread Adrian Klaver
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.  C

Re: Suggestion on index creation for TEXT data field

2020-05-21 Thread postgann2020 s
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: > >> which

Re: Suggestion on table analyze

2020-05-21 Thread Adrian Klaver
On 5/21/20 7:18 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 contain GIS data. While analyzing the table getting below NOTICE. It seems is pretty understanding, but needs help

Re: Suggestion on index creation for TEXT data field

2020-05-21 Thread David G. Johnston
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" i

Suggestion on index creation for TEXT data field

2020-05-21 Thread postgann2020 s
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 USING

Suggestion on table analyze

2020-05-21 Thread postgann2020 s
Hi Team, Thanks for your support. Could you please suggest on below query. Environment PostgreSQL: 9.5.15 Postgis: 2.2.7 Mostly table contain GIS data. While analyzing the table getting below NOTICE. It seems is pretty understanding, but needs help on the below points. 1 . What might be the r