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

Anargyros Tomaras ATomaras at esri.com
Sat Oct 2 19:42:27 PDT 2021

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.

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

More information about the postgis-users mailing list