Re: VACUUM degrades performance significantly. Database

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: VACUUM degrades performance significantly. Database
Date: 2003-10-17 13:42:24
Message-ID: 3F8FF1C0.9040406@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vivek Khera wrote:

>>>>>>"S" == Stephen <jleelim(at)xxxxxx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-10-17 13:49:14 Re: ShmemAlloc errors
Previous Message Bill Nedell 2003-10-17 13:23:16 selecting table at execution with PL/PgSQL