Yves Vindevogel wrote:

I'm trying to update a table that has about 600.000 records.
The update query is very simple : update mytable set pagesdesc = - pages ;

The query takes about half an hour to an hour to execute. I have tried a lot of things.

Half an hour seem a bit long - I would expect less than 5 minutes on reasonable hardware.

You may have dead tuple bloat - can you post the output of 'ANALYZE VERBOSE mytable' ?



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to