Opened 2 years ago

Closed 2 years ago

Last modified 2 years ago

#3865 closed defect (fixed)

Build Request

Reported by: ravelllott Owned by: robe
Priority: low Milestone: PostGIS 2.3.4
Component: postgis Version: 2.3.x
Keywords: build request Cc:

Description

We have been running 2.1.7 postgis with postgres 9.4.3 for a few years. we upgraded to 9.6 and 2.2.3 respectively. and one of our queries has suffered a 300 percent increase in processing time ~60 seconds to ~180 seconds.

I was hoping to request a windows x64 build of 2.1.9 built against postgres 9.6.X.

Change History (6)

comment:1 Changed 2 years ago by robe

you upgraded to 2.2.3 or 2.3.3?

I can't build a 2.1.9 for PostgreSQL 9.6 because 2.1 only goes thru support of 9.4. Actually doesn't compile against 9.6 as I recall.

See the matrix.

https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS

Now if you can provide a query of what slowed down, we can look at it and perhaps release a fix for 2.3.4.

Would also help if you can show output of:

SELECT version() || ' ' || postgis_full_version();
Last edited 2 years ago by robe (previous) (diff)

comment:2 Changed 2 years ago by robe

Milestone: PostGIS PostgreSQLPostGIS 2.3.4

comment:3 Changed 2 years ago by robe

Owner: changed from pramsey to robe

comment:4 Changed 2 years ago by ravelllott

We did try the 2.4.0 RC2 build and it appears to not have the performance degradation.

Also we believed to have tracked down the issue to ST_Intersects.

comment:5 Changed 2 years ago by ravelllott

Priority: highlow
Resolution: fixed
Status: newclosed

comment:6 Changed 2 years ago by robe

great to hear

Note: See TracTickets for help on using tickets.