The intersect function does not utilize indexes

[Dapeng Wang]

Hello everyone,

I have a client with a database developed on PostgreSQL 12, with both
Windows and Linux versions. Everything is normal with the Linux version,
but there are anomalies with the Windows version.

While the Windows database can have the PostGIS extension installed, create
indexes, and execute SQL queries correctly, spatial functions do not
utilize indexes, such as intersection and containment.

Here's what I've investigated so far (using the same DDL):
On the Windows system, PostgreSQL 12 is installed along with PostGIS
versions 3.3.0 to 3.4.1, and everything works fine. Spatial functions can
utilize indexes.
On the Windows system, the client's developed database is installed with
PostGIS versions 3.3.0 to 3.4.1. Queries using the && operator utilize
indexes, but spatial functions (such as st_intersects and ST_Contains) do
not utilize indexes.
Vacuum analyze has been performed, and I've attempted to disable sequential
scans and force index scans, but to no avail.
Do you have any good suggestions?

Thanks,
Dapeng
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240223/4761d6ab/attachment.htm>