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' ?
Cheers
Mark