Perfect, thanks a lot! I do confirm ST_Contains() is fine. Fabien
________________________________ De : Paul Ramsey <pram...@cleverelephant.ca> Envoyé : samedi 23 novembre 2024 03:12 À : Fabien Vallée <fabien.val...@live.fr> Cc : PostGIS Users Discussion <postgis-users@lists.osgeo.org> Objet : Re: postgis 3.5.0: ST_Within huge performance issue (regression?) with specific geometry (multipolygon) Oh, and an easy workaround until release, just use ST_Contains() with the arguments reversed. P On Nov 22, 2024, at 6:10 PM, Paul Ramsey <pram...@cleverelephant.ca> wrote: Found and fixed for next release https://trac.osgeo.org/postgis/ticket/5812 On Nov 22, 2024, at 5:43 PM, Paul Ramsey <pram...@cleverelephant.ca> wrote: I have duplicated your problem locally, I do not need the test data, thanks! On Nov 22, 2024, at 3:52 PM, Paul Ramsey <pram...@cleverelephant.ca> wrote: Even just a relatively small one should be enough. On Nov 22, 2024, at 3:34 PM, Paul Ramsey <pram...@cleverelephant.ca> wrote: On Nov 22, 2024, at 3:00 PM, Fabien Vallée <fabien.val...@live.fr> wrote: Let me know if you find anything, if needed I will provide an extract of the db with enough data to test. Please provide a data extract. Thanks, P
