Re: simple update query too long

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.