"Vilson farias" <vilson.farias@digitro.com.br> writes:
> The problem is realted with "1 | serv_acaoserv | 154406" tuple, wich
> takes 5-10 secs to be updated, whether it's called from this stored
> procedure or from a simple UPDATE clause. All other tuples goes fine,
> update time is about 10-30ms.
Have you updated that particular row many more times than the rest?
If so, you have a lot of dead versions of the row that need to be
cleaned out.
> I did not tried a vacuumdb yet.
You should run vacuum on a regular basis.
regards, tom lane