[QGIS-Developer] Fwd: My PostgreSQL/PostGIS function to create all missing spatial indexes

kimaidou kimaidou at gmail.com
Sun Dec 3 00:36:38 PST 2017

Hi Jorge

This feature would be good to have in the DB manager, but I do not think we
should create a function in any database without warning the user.

Inside QGIS, we should be less intrusive and only run the SELECT SQL inside
the function to get all missing indexes, show them in a QGIS table view
with checkboxes, and a button to create selected indexes.
I could propose a PR for this if I find time (heavy workload this end of


2017-12-01 17:09 GMT+01:00 Jorge Gustavo Rocha <jgr at di.uminho.pt>:

> Nice contribution, Michaël! Tested and approved :-)
> We might use this query to offer the option "Check missing spatial
> indexes" in DB Manager, with an additional checkbox to "Add missing
> indexes". Initially just for the Postgis provider, but it can be
> implemented for other providers.
> What do you think?
> Regards,
> Jorge Gustavo
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20171203/2ffea8ca/attachment.html>

More information about the QGIS-Developer mailing list