Re: [GENERAL] VACUUM degrades performance significantly. Database becomes

2003-10-16 Thread Vivek Khera
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

[GENERAL] VACUUM degrades performance significantly. Database becomes unusable!

2003-10-15 Thread Stephen
Hello, Is it normal for plain VACUUM on large table to degrade performance by over 9 times? My database becomes unusable when VACUUM runs. From reading newsgroups, I thought VACUUM should only slow down by 10% to 15%. Other MVCC databases like MySQL InnoDB can even VACUUM discretely (runs

Re: [GENERAL] VACUUM degrades performance significantly. Database becomes unusable!

2003-10-15 Thread Tom Lane
Stephen [EMAIL PROTECTED] writes: Is it normal for plain VACUUM on large table to degrade performance by over 9 times? My database becomes unusable when VACUUM runs. From reading newsgroups, I thought VACUUM should only slow down by 10% to 15%. We have heard reports of very significant