Hi, I have a pretty "live" table: rows being inserted and updated more than once 1 per second, though far, far more inserts than updates. There are currently over 3 million rows. It has not been vacuumed for months. Now a vacuum on that table takes hours, and I have not let it complete because it stays running into our daily busy time... but I've been told its necessary because the table is slowing down. I have begun a cron job which will do a daily analyze, and am thinking of a weekly vacuum... Please advise on the best way to keep this table maintained, even if it means regularly taking the service offline early on Sunday morning... thanks in advance Brian -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 183 8059 6 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
