Re: Autovacuum Issue

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: J Ramesh Kumar <rameshj1977(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum Issue
Date: 2011-12-02 03:02:48
Message-ID: CAOR=d=2nFVu3E2=ecr5kU4AoFJvB+SHTxc5V_dbvRp-=0BFQkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Nov 22, 2011 at 10:55 PM, J Ramesh Kumar <rameshj1977(at)gmail(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Thiago Godoi 2011-12-02 15:55:11 Intersect/Union X AND/OR
Previous Message Mark Kirkwood 2011-12-01 22:35:20 Re: Autovacuum Issue