>>>>> "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? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: [EMAIL PROTECTED] Rockville, MD +1-240-453-8497 AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
