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

[Paul Ramsey]

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/20241122/83ed0a28/attachment.htm>