Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time
Date
Msg-id 14567.1082575128@sss.pgh.pa.us
Whole thread Raw
In response to 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time  (Philipp Buehler <pb-pgsql-g@mlsub.buehler.net>)
Responses Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [OT] Tom's/Marc's spam filters?
Next
From: "Glen Parker"
Date:
Subject: Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly over time