Re: PostGIS 3.5.2 ST_Contains() query on gist is slow
Sebastiaan Couwenberg via postgis-users <[email protected]> Thu, 11 Sep 2025 05:48:55 +0200
| Newsgroups | gmane.comp.gis.postgis |
|---|---|
| Message-ID | <[email protected]> |
On 9/11/25 5:36 AM, Sebastiaan Couwenberg via postgis-users wrote: > On 9/10/25 11:36 PM, Regina Obe wrote: >> Never mind the test above I proposed, I tried it and it still decided to use the spatial index instead of the primary key on n.id >> Which I found really surprising as I thought primary keys trump everything. >> >> Anyway Paul traced the commit that caused the issue and it was introduced in 3.4. > > Which commit is that? Nevermind, I'm blind. It's in the ticket: https://trac.osgeo.org/postgis/changeset/31bcb7d414/git Kind Regards, Bas -- GPG Key ID: 4096R/6750F10AE88D4AF1 Fingerprint: 8182 DE41 7056 408D 6146 50D1 6750 F10A E88D 4AF1