Re: Understanding pg_autovacuum CPU Usage - Mailing list pgsql-general

From Thomas F.O'Connell
Subject Re: Understanding pg_autovacuum CPU Usage
Date
Msg-id 183F7600-FC94-11D8-9D1E-000D93AE0944@sitening.com
Whole thread Raw
In response to Re: Understanding pg_autovacuum CPU Usage  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-general
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?

> 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?

Thanks for the input.

-tfo


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: The future of built-in geometric data types
Next
From: David Fetter
Date:
Subject: Re: The future of built-in geometric data types