RE: postgis 3.5.0: ST_Within huge performance issue (regression?) with specific geometry (multipolygon)

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