PostGIS 3.5.2 ST_Contains() query on gist is slow

[Sebastiaan Couwenberg]

On 9/9/25 9:07 PM, Regina Obe wrote:
> Can you get us a small dump of the data showing the issue or the recipe you used to load the data?

The script to create the database is attached.

It assumes that the osmosis Debian package is installed and the non-standard /var/tmp/osmosis directory exists.

> I'd like to try this out on a couple of versions of PG/ PostGIS I have loaded.

I should be able to test the bookworm setup tomorrow after the data finished loading in the chroot.

Kind Regards,

Bas

-- 
  GPG Key ID: 4096R/6750F10AE88D4AF1
Fingerprint: 8182 DE41 7056 408D 6146  50D1 6750 F10A E88D 4AF1
-------------- next part --------------
A non-text attachment was scrubbed...
Name: create-db.sh
Type: application/x-shellscript
Size: 952 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250909/0627686e/attachment.bin>