<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Thanks for your recommendations, Imre. I’ve updated my Trac ticket accordingly.<div class=""><br class=""><div class="">Kind regards, Carsten</div><div class=""><br class=""><div><br class=""><blockquote type="cite" class=""><div class="">On 11 Feb 2022, at 13:46, Imre Samu <<a href="mailto:pella.samu@gmail.com" class="">pella.samu@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi Carsten,<div class=""><br class=""></div><div class="">> <span style="" class="">but am just not sure I chose the appropriate milestone/component/version</span></div><div class="">> <span style="" class="">Could you please give me some guidance here?</span></div><div class=""><span style="" class=""><br class=""></span></div><div style="" class="">( I am a docker-postgis contributor) </div><div style="" class=""><br class=""></div><div style="" class="">I am so sorry, but not "all" docker <font face="monospace" class="">postgis/postgis</font> image updating regularly ( with minor postgres,postgis) patches, bug fixes </div><div style="" class="">Only as in this repo: <a href="https://github.com/postgis/docker-postgis" class="">https://github.com/postgis/docker-postgis</a> (scheduled on every Monday )<br class=""></div><div style="" class=""><br class=""></div><div style="" class="">You can check the "age / created " of the local docker image</div><div style="" class=""><div style="color:rgb(235,209,183);background-color:rgb(54,49,44);font-family:"Droid Sans Mono","monospace",monospace;font-size:14px;line-height:19px;white-space:pre" class=""><div class="">$ docker images postgis/postgis</div><div class="">postgis/postgis 11-2.5-alpine 10c7c19a572c 4 days ago 330MB</div><div class="">postgis/postgis 11-3.2-alpine 0303403af49f 4 days ago 369MB</div><div class="">postgis/postgis 11-3.1-alpine f8c3965c17b8 7 weeks ago 328MB <-- too old </div><div class="">postgis/postgis 11-3.0-alpine 4605eb1b2223 14 months ago 289MB <-- extreme old</div></div></div><div style="" class=""><br class="">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" )<br class=""></div><div style="" class="">This is a technical limitation of the current docker image workflow. ( probably it can be improved in the future )</div><div style="" class=""><br class=""></div><div style="" class="">You can check the actual version with:</div><div style="" class=""><div style="color:rgb(235,209,183);background-color:rgb(54,49,44);font-family:"Droid Sans Mono","monospace",monospace;font-size:14px;line-height:19px;white-space:pre" class=""><div class="">SELECT <span style="color:rgb(96,163,101)" class="">version</span>();</div><div class="">SELECT <span style="color:rgb(96,163,101)" class="">PostGIS_Full_Version</span>();</div></div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">The other important issue for debugging the alpine version ( 3.12 - 3.15 )</div><div class="">and you can check with <font face="monospace" class="">"cat /etc/os-release"</font></div><div class=""><br class=""></div><div class=""><div style="color:rgb(235,209,183);background-color:rgb(54,49,44);font-family:"Droid Sans Mono","monospace",monospace;font-size:14px;line-height:19px;white-space:pre" class=""><div class="">$ docker run -t --rm postgis/postgis:11-3.0-alpine sh -c <span style="color:rgb(248,187,57)" class="">"cat /etc/os-release | grep VERSION"</span></div><div class="">VERSION_ID=3.12.2</div><div class="">$ docker run -t --rm postgis/postgis:11-3.2-alpine sh -c <span style="color:rgb(248,187,57)" class="">"cat /etc/os-release | grep VERSION"</span></div><div class="">VERSION_ID=3.15.0</div><br class=""></div></div><div class=""><br class=""></div><div class="">So my recommendations:</div><div class="">- please remove the "older docker" images from your test cases</div><div class="">- and add postgres / postgis / alpine versions</div><div class=""><br class=""></div><div class="">It is an interesting issue;</div><div class=""><br class=""></div><div class="">Regards,</div><div class=""> Imre </div><div class=""><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Carsten Byrman <<a href="mailto:byrman%2Bpostgis@posteo.nl" class="">byrman+postgis@posteo.nl</a>> ezt írta (időpont: 2022. febr. 11., P, 7:41):<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div style="overflow-wrap: break-word;" class=""><span style="" class="">Hello,</span><div style="" class=""><br class=""></div><div style="" class="">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: <a href="https://trac.osgeo.org/postgis/ticket/5025" target="_blank" class="">https://trac.osgeo.org/postgis/ticket/5025</a>. Perhaps it’s not even a PostGIS but a PostgreSQL issue. Could you please give me some guidance here?</div><div style="" class=""><br class=""></div><div style="" class="">Thanks, Carsten</div></div>_______________________________________________<br class="">
postgis-users mailing list<br class="">
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" class="">postgis-users@lists.osgeo.org</a><br class="">
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank" class="">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br class="">
</blockquote></div>
_______________________________________________<br class="">postgis-users mailing list<br class=""><a href="mailto:postgis-users@lists.osgeo.org" class="">postgis-users@lists.osgeo.org</a><br class="">https://lists.osgeo.org/mailman/listinfo/postgis-users<br class=""></div></blockquote></div><br class=""></div></div></body></html>