Vladimir Zamiussky writes:
> When I do UPDATE some_table set value=... where id=...,
> query execution time raises in arithmetic progression!
> After about 50 updates on every row query consumes ~3 sec against 0.3
> sec as it was at the beginning.
> psql takes ~80% of CPU time (acording to top).
> VACUUM helps to restore execution speed, but i think it is not the way out.
>
> Is it BUG or FEATURE?
It's just a fact of how the system works.
--
Peter Eisentraut peter_e(at)gmx(dot)net