Re: Autovacuum Issue - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Autovacuum Issue
Date
Msg-id CAOR=d=2nFVu3E2=ecr5kU4AoFJvB+SHTxc5V_dbvRp-=0BFQkw@mail.gmail.com
Whole thread Raw
In response to Autovacuum Issue  (J Ramesh Kumar <rameshj1977@gmail.com>)
List pgsql-performance
On Tue, Nov 22, 2011 at 10:55 PM, J Ramesh Kumar <rameshj1977@gmail.com> wrote:
> But the autovacuum is running frequently and it impact the performance of my
> system(high CPU). You can see the autovacuum in the pg_stat_activity.

Could you show us the system metrics that led you to believe it was
high CPU usage?  Sometimes people misinterpret the numbers from
utilities like top, iostat, or vmstat, so I'd rather see them myself
if you got them.

pgsql-performance by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Autovacuum Issue
Next
From: Thiago Godoi
Date:
Subject: Intersect/Union X AND/OR