Hi,
I would suggest if you can try one of this options:
0- create a new index on " inter "column for grille table and in your WHERE
clause try to limit the number of update rows instead of 2mills for one
the whole transaction , something like :where inter > x and inter < y;
1- drop at least the grille_geom indexes and next
2- disable All the check constraints on grille tables, there are geometry
functions which possible are called every time when you run the updates.
Isabella
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/simple-update-query-too-long-tp4382026p4393874.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.