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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
