Re: Understanding pg_autovacuum CPU Usage

Thomas F.O'Connell wrote:
>
> On Sep 1, 2004, at 10:27 PM, Matthew T. O'Connor wrote:
>
>> Number of rows is irrelevant, but the number of tables might not be.
>> It could be that the process of checking it's list of tables against
>> the server might be slow when used with lots of tables.  Does this cpu
>> spike happen every other loop?
>
> Is there an easy way to determine if it's happening every other loop?

Yes, if you are running pg_autovacuum with a debug setting >= 1 it will
write out a message at the end of every loop.

>> Try the simple recompile with the larger update interval first and see
>> if that's the problem.
>
> How difficult would it be to make this a command-line argument if it
> turns out to be a run-time issue?

Very Easy.