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 s

[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 internal