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