[postgis-users] Are covering indexes (index-only scans) possible with PostGIS?

[Anargyros Tomaras]

Performance for my workload could be substantially improved by the use of covering indexes<https://www.postgresql.org/docs/11/indexes-index-only-scans.html>.
I have tried but I have been unable to make them work with my GiST geometry indexes (points).
The latest versions I have tried against were PostgreSQL v13 and PostGIS v3.1.1.

I am pretty sure there must be a good reason behind this limitation and I was wondering what that reason is.


Thank you.
Anargyros

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20211003/ee51cdfd/attachment.html>