[postgis-users] Inconsistent behavior with ST_Within across versions

Imre Samu pella.samu at gmail.com
Fri Feb 11 04:46:15 PST 2022

Hi Carsten,

> but am just not sure I chose the appropriate milestone/component/version
> Could you please give me some guidance here?

( I am a docker-postgis contributor)

I am so sorry,  but not "all" docker postgis/postgis image updating
regularly ( with minor postgres,postgis) patches, bug fixes
Only as in this repo:  https://github.com/postgis/docker-postgis
(scheduled on every Monday )

You can check the "age / created " of the local docker image
$ docker images postgis/postgis
postgis/postgis 11-2.5-alpine 10c7c19a572c 4 days ago 330MB
postgis/postgis 11-3.2-alpine 0303403af49f 4 days ago 369MB
postgis/postgis 11-3.1-alpine f8c3965c17b8 7 weeks ago 328MB <-- too old
postgis/postgis 11-3.0-alpine 4605eb1b2223 14 months ago 289MB <-- extreme

So I am not recommending the current  -3.0; -3.1 docker images  ( or any
images older than 1 month, like "12-2.5-alpine" )
This is a technical limitation of the current docker image workflow. (
probably it can be improved in the future )

You can check the actual version with:
SELECT version();
SELECT PostGIS_Full_Version();

The other important issue for debugging the alpine version ( 3.12 - 3.15 )
and you can  check with "cat /etc/os-release"

$ docker run -t --rm postgis/postgis:11-3.0-alpine sh -c "cat
/etc/os-release | grep VERSION"
$ docker run -t --rm postgis/postgis:11-3.2-alpine sh -c "cat
/etc/os-release | grep VERSION"

So my recommendations:
-  please remove the "older docker" images from your test cases
-  and add postgres / postgis / alpine versions

It is an interesting issue;


Carsten Byrman <byrman+postgis at posteo.nl> ezt írta (időpont: 2022. febr.
11., P, 7:41):

> Hello,
> I noticed inconsistent behavior with ST_Within across different
> PostgreSQL-PostGIS versions. Most notably, the outcome (not performance) of
> my query is determined by the presence of an index, which strikes me as
> odd. I filed my first bug report about 3 months ago and I expect no
> solution any time soon, but am just not sure I chose the appropriate
> milestone/component/version: https://trac.osgeo.org/postgis/ticket/5025.
> Perhaps it’s not even a PostGIS but a PostgreSQL issue. Could you please
> give me some guidance here?
> Thanks, Carsten
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20220211/94966763/attachment.html>

More information about the postgis-users mailing list