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

From Greg Stark
Subject Re: VACUUM degrades performance significantly. Database becomes
Date
Msg-id 87r81b20bf.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: VACUUM degrades performance significantly. Database becomes  (Vivek Khera <khera@kcilink.com>)
List pgsql-general
Vivek Khera <khera@kcilink.com> writes:

> 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?

I normally look at the bi/bo columns of "vmstat 1".

There does appear to be an iostat command, on debian in the sysstat package.
No idea how good it is.

--
greg

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ShmemAlloc errors
Next
From: Network Administrator
Date:
Subject: Re: connecting to external database tables outside of the postgres database