This question already has an answer here:
I work on QGIS.
Whenever I make a layer (1500 lines) that is stored on a PostgreSQL server editable, a process of reindexing starts and lasts for long minutes!
What is the reason and how could I get around this indexing process?
I think I use PostGIS. My layer is a layer 'points' that I feed with Qgis. It is stored on PostgreSQL (I imported it in PostgreSQL with QGIS's "data manager"). The PostgreSQL server has a PostGIS extension.