Re: VACUUM degrades performance significantly. Database - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: VACUUM degrades performance significantly. Database
Date
Msg-id 3F8FF1C0.9040406@persistent.co.in
Whole thread Raw
In response to Re: VACUUM degrades performance significantly. Database becomes  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
Vivek Khera wrote:

>>>>>>"S" == Stephen  <jleelim@xxxxxx.com> writes:
>
>
> S> The system is actually idling when I ran the tests (load average: 0.01,
> S> 0.02, 0.00). When VACUUM runs, load average increases quickly (load average:
> S> 1.77, 0.60, 0.21) just by running psql on command line and issuing 2
> S> queries. I've been running PostgreSQL for over 3 years now and IIRC VACUUM
>
> Your CPU usage is irrelevent here.  What's your *disk* utilization.
> Does linux have systat and/or iostat to tell you how busy your disks
> are?

It has a rather verbose vmstat which gives everything.

  Shridhar


pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: XOR logical operator
Next
From: Tom Lane
Date:
Subject: Re: ShmemAlloc errors