Re: Manual vacs 5x faster than autovacs?

> Quoting Scott Marlowe <scott.marlowe@gmail.com>:
>
>>> On Thu, Nov 12, 2009 at 9:14 AM, Wayne Beaver <wayne@acedsl.com> wrote:
>>> I'd seen autovacs running for hours and had mis-attributed this to growing
>>> query times on those tables  - my thought was that "shrinking" the tables
>>> "more quickly" could make them "more-optimized", more often. Sounds like I
>>> could be chasing the wrong symptoms, though.
>>
>> Now it is quite possible that a slow autovac is causing your queries
>> to run slower.  So, if it has a moderate to high cost delay, then
>> it might not be able to keep
>> up with the job and your tables will become bloated.
>>
>> The problem isn't that autovac is stealing too many resources, it's
>> that it's not stealing enough.
>>
>> I see you're technically running 8.3, but you're running RC2
>> for some reason?  I don't usually run 8.x.0 in production.  Let alone
>> RCs.  You should really update before some nasty bug that's been
>> squashed in later releases bites you.


Hahaha. Yes, 8.3RC2 was latest version at time I implemented related
client app. Install is "production-like", more so than production -
non-mission-critical,  but important to some "VIP-like" users at
intervals which are not necessarily predictable. I'm long past my goal
of migrating to 8.4, actually...

My autovac settings are all at default values, so sounds like I can at
least tinker with _workers and _cost_delay. I've not yet gotten to you
iostat inquiry from your previous response...

wb