PostGIS 3.5.2 ST_Contains() query on gist is slow

[Sebastiaan Couwenberg]

On 9/9/25 6:04 AM, Regina Obe wrote:
> Are you upgrading from 3.5.2 to 3.5.3 or from pre 3.5.1 to 3.5.2?  sounds from your below comment that is what you are doing, but you are showing 3.5.2 output so not clear if that is your new setup or your old setup that was working.

What I'm showing is my new/current setup after the distribution upgrade.

> I am assuming the above is your new setup?  What is the full version output of your old setup?

Debian bookworm had PostgreSQL 15.14 with PostGIS 3.3.2.

gis=# SELECT postgis_full_version();
                                                                         postgis_full_version
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.3.2 4975da8" [EXTENSION] PGSQL="150" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1" LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"
(1 row)

> If the above is your new setup, I was thinking it might be an issue with GEOS.
> 
> Did you upgrade GEOS as well at the same time.  Might be a GEOS issue around the RelateNG work that was done in 3.13.0 and 3.13.1

Everything was upgraded as part of the distribution upgrade from Debian bookworm to trixie.

Kind Regards,

Bas

-- 
  GPG Key ID: 4096R/6750F10AE88D4AF1
Fingerprint: 8182 DE41 7056 408D 6146  50D1 6750 F10A E88D 4AF1