<div dir="ltr">Hi Carsten,<div><br></div><div>> <span style="color:rgb(0,0,0)">but am just not sure I chose the appropriate milestone/component/version</span></div><div>> <span style="color:rgb(0,0,0)">Could you please give me some guidance here?</span></div><div><span style="color:rgb(0,0,0)"><br></span></div><div style="color:rgb(0,0,0)">( I am a docker-postgis contributor) </div><div style="color:rgb(0,0,0)"><br></div><div style="color:rgb(0,0,0)">I am so sorry, but not "all" docker <font face="monospace">postgis/postgis</font> image updating regularly ( with minor postgres,postgis) patches, bug fixes </div><div style="color:rgb(0,0,0)">Only as in this repo: <a href="https://github.com/postgis/docker-postgis">https://github.com/postgis/docker-postgis</a> (scheduled on every Monday )<br></div><div style="color:rgb(0,0,0)"><br></div><div style="color:rgb(0,0,0)">You can check the "age / created " of the local docker image</div><div style="color:rgb(0,0,0)"><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"><div>$ docker images postgis/postgis</div><div>postgis/postgis 11-2.5-alpine 10c7c19a572c 4 days ago 330MB</div><div>postgis/postgis 11-3.2-alpine 0303403af49f 4 days ago 369MB</div><div>postgis/postgis 11-3.1-alpine f8c3965c17b8 7 weeks ago 328MB <-- too old </div><div>postgis/postgis 11-3.0-alpine 4605eb1b2223 14 months ago 289MB <-- extreme old</div></div></div><div style="color:rgb(0,0,0)"><br>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></div><div style="color:rgb(0,0,0)">This is a technical limitation of the current docker image workflow. ( probably it can be improved in the future )</div><div style="color:rgb(0,0,0)"><br></div><div style="color:rgb(0,0,0)">You can check the actual version with:</div><div style="color:rgb(0,0,0)"><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"><div>SELECT <span style="color:rgb(96,163,101)">version</span>();</div><div>SELECT <span style="color:rgb(96,163,101)">PostGIS_Full_Version</span>();</div></div></div><div><br></div><div><br></div><div>The other important issue for debugging the alpine version ( 3.12 - 3.15 )</div><div>and you can check with <font face="monospace">"cat /etc/os-release"</font></div><div><br></div><div><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"><div>$ docker run -t --rm postgis/postgis:11-3.0-alpine sh -c <span style="color:rgb(248,187,57)">"cat /etc/os-release | grep VERSION"</span></div><div>VERSION_ID=3.12.2</div><div>$ docker run -t --rm postgis/postgis:11-3.2-alpine sh -c <span style="color:rgb(248,187,57)">"cat /etc/os-release | grep VERSION"</span></div><div>VERSION_ID=3.15.0</div><br></div></div><div><br></div><div>So my recommendations:</div><div>- please remove the "older docker" images from your test cases</div><div>- and add postgres / postgis / alpine versions</div><div><br></div><div>It is an interesting issue;</div><div><br></div><div>Regards,</div><div> Imre </div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Carsten Byrman <<a href="mailto:byrman%2Bpostgis@posteo.nl">byrman+postgis@posteo.nl</a>> ezt írta (időpont: 2022. febr. 11., P, 7:41):<br></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;"><span style="color:rgb(0,0,0)">Hello,</span><div style="color:rgb(0,0,0)"><br></div><div style="color:rgb(0,0,0)">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">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="color:rgb(0,0,0)"><br></div><div style="color:rgb(0,0,0)">Thanks, Carsten</div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br>
</blockquote></div>