Understanding pg_autovacuum CPU Usage

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Understanding pg_autovacuum CPU Usage
Date: 2004-09-01 20:38:29
Message-ID: E1A65C54-FC56-11D8-A557-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've been using pg_autovacuum on a largish postgres installation
successfully for several weeks, now. I know that pg_autovacuum has no
facility for monitoring the system to know whether any particular time
is a good one for it to do it's thing, but I'm wondering what the
occasional episodes of 99.9% CPU usage (as reported by top) are.

I keep a pg_autovacuum.log, and when the spikes start, often nothing is
written to the log. And what ends up being written has been of varying
amounts of potential strain. Frequently, the tables involved are
smallish. So I'm wondering: does the CPU usage correspond to any time
pg_autovacuum arouses from its sleep state and begins looking for what
it ought to do?

Any thoughts?

-tfo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Esteban Kemp 2004-09-01 21:09:06 materialized view
Previous Message Glen Parker 2004-09-01 18:54:21 Re: PostgreSQL and Fedora?