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

[Fabien Vallée]

Perfect, thanks a lot!
I do confirm ST_Contains() is fine.

Fabien

________________________________
De : Paul Ramsey <pramsey at cleverelephant.ca>
Envoyé : samedi 23 novembre 2024 03:12
À : Fabien Vallée <fabien.vallee at live.fr>
Cc : PostGIS Users Discussion <postgis-users at 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 <pramsey at 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 <pramsey at 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 <pramsey at cleverelephant.ca> wrote:

Even just a relatively small one should be enough.

On Nov 22, 2024, at 3:34 PM, Paul Ramsey <pramsey at cleverelephant.ca> wrote:



On Nov 22, 2024, at 3:00 PM, Fabien Vallée <fabien.vallee at 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




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20241125/53bcf7bf/attachment.htm>