Vivek Khera wrote:

"S" == Stephen <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

Reply via email to