On Wed, Apr 21, 2004 at 19:52:15 +0200,
Philipp Buehler <pb-pgsql-g(at)mlsub(dot)buehler(dot)net> wrote:
>
> While running
> UPDATE banner SET counterhalf=counterhalf+1 WHERE BannerID=50
> several thousand times, the return times degrade (somewhat linear).
This is to be expected. Postgres uses MVCC and everytime you do an update
a new row is created.
> A following VACCUM brings back return times to 'start' - but I cannot
> run VACUUM any other minute (?). And it exactly vaccums as many tuples
> as I updated.. sure thing:
Why not? You only have to vacuum this one table. Vacuuming it once a minute
should be doable.