Re: FW: Postgres: VACUUM

lnd(at)hnit(dot)is writes:
>> On heavily used databases (over 100,000 transactions an hour),
>> vacuum is a killer
>
> That's about 27 tx/second - not so many, for some tasks at least.
>
> If VACUUM is rather a killer
> - are any plans from PostgreSQL to deal with that?

Yes. There is a patch available that causes VACUUM to sleep() after
every few pages it processes, which throttles VACUUM's ill effects on
cache. It isn't yet in 7.4.1, but might be in a later 7.4 release.

There is also a major revision taking place (look up "ARC" on the
hackers list) for management of cache that should also be helpful.
--
let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)