Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time

Philipp Buehler <pb-pgsql-g@mlsub.buehler.net> writes:
> While running
> UPDATE banner SET counterhalf=counterhalf+1 WHERE BannerID=50
> several thousand times, the return times degrade (somewhat linear).

You need to vacuum occasionally ...

> A following VACCUM brings back return times to 'start' - but I cannot
> run VACUUM any other minute (?).

Sure you can.

            regards, tom lane