Could someone please help us share the procedure to troubleshoot the locks on proc issues.

Hi Team, Good Evening, Could someone please help us share the procedure to troubleshoot the locks on proc issues. Environment: 1 pgpool server (Master Pool Node) using Straming replication with load balancing 4 DB nodes (1Master and 3 Slaves). Versions: 1. postgres: 9.5.15 2.

Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues.

Thanks Adrian, will share the details. On Fri, Apr 3, 2020 at 4:30 AM Adrian Klaver wrote: > On 4/2/20 12:37 PM, postgann2020 s wrote: > > Hi Team, > > > > Good Evening, > > > > Could someone please help us share the procedure to troubleshoot the > > lo

Suggestion to improve query performance.

Hi Team, Thanks for your support. We are using below environment: Application : Programming Language : JAVA Geoserver Database Stack: PostgreSQL : 9.5.15 Postgis We have 3 geoserver queries and are getting some performance issues after changing the GeoServer queries.I have posted the queries a

Suggestion on table analyze

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

Suggestion on index creation for TEXT data field

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

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

Re: Suggestion on table analyze

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

Re: Suggestion on index creation for TEXT data field

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 typ

Suggestion to improve query performance of data validation in proc.

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

Suggestion to improve query performance for GIS query.

Hi Team, Thanks for your support. Could you please suggest on below query. EnvironmentPostgreSQL: 9.5.15 Postgis: 2.2.7 The table contains GIS data which is fiber data(underground routes). We are using the below query inside the proc which is taking a long time to complete. **

Re: Suggestion to improve query performance for GIS query.

gt; VACUUM (VERBOSE, ANALYZE) tablename; > > Regards, > Mohammed Afsar > Database engineer > > On Fri, May 22, 2020, 12:30 PM postgann2020 s > wrote: > >> Hi Team, >> >> Thanks for your support. >> >> Could you please suggest on below query. >> &g