Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C90552E3054 for ; Thu, 3 Jan 2008 08:48:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 25525-07 for ; Thu, 3 Jan 2008 08:48:26 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 260D12E3062 for ; Thu, 3 Jan 2008 08:48:31 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so1526688wxc.28 for ; Thu, 03 Jan 2008 04:48:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=3L83vWEBJ2GQ++MuDW+nFPcD/Hvk5+XHuOYbiNUXiNk=; b=TbSkcwF6vjnFxRXp88GC9sTB6U3nxTov/m38VHKUSK5I4y2g9gfGz7NECovRf5UMFVla4GqARVctRuL+eQlqg0MNIgwhFMMteC3CGSXG/j0aOJYs+Od8n85qCbrdZ2jAQasQqka8ecd6YhL0pv1nd1Wli+0/cKEQCRk2kqcmdOg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=JY9iIyASeusLDbQbrzWBJA7psBQ/hPpDT0udT9iSlEMV2uB54+98t6vG556JIlHGbHku6LCyO5p7dL4G4l2/QJkCohScxP6Qg8OmSAmD3k/ZktfSRb96+E8F2emUxkBdoO94vBiLd3Mo/yldam2vEqNWDqj4UU0spG8FetFd4FI= Received: by 10.150.58.5 with SMTP id g5mr4129546yba.89.1199364509825; Thu, 03 Jan 2008 04:48:29 -0800 (PST) Received: by 10.35.72.8 with HTTP; Thu, 3 Jan 2008 04:48:29 -0800 (PST) Message-ID: <5a9699850801030448k126a5028m85ddb2153e95184f@mail.gmail.com> Date: Thu, 3 Jan 2008 14:48:29 +0200 From: "Brian Modra" To: pgsql-admin@postgresql.org Subject: Vacuum taking an age MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200801/39 X-Sequence-Number: 27813 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