Perfect, thanks a lot! I do confirm ST_Contains() is fine. Fabien
________________________________ De : Paul Ramsey <[email protected]> Envoyé : samedi 23 novembre 2024 03:12 À : Fabien Vallée <[email protected]> Cc : PostGIS Users Discussion <[email protected]> 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 <[email protected]> wrote: Found and fixed for next release https://trac.osgeo.org/postgis/ticket/5812 On Nov 22, 2024, at 5:43 PM, Paul Ramsey <[email protected]> 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 <[email protected]> wrote: Even just a relatively small one should be enough. On Nov 22, 2024, at 3:34 PM, Paul Ramsey <[email protected]> wrote: On Nov 22, 2024, at 3:00 PM, Fabien Vallée <[email protected]> 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
