"Vilson farias" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
