X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B9C929DCA5E for ; Fri, 10 Feb 2006 23:15:37 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91942-09 for ; Fri, 10 Feb 2006 23:15:42 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A1C9A9DC81A for ; Fri, 10 Feb 2006 23:15:35 -0400 (AST) Received: from 217-20-115-93.internetserviceteam.com (mail.easyload.es [217.20.115.93]) by svr4.postgresql.org (Postfix) with ESMTP id 1C9185AF8B4 for ; Sat, 11 Feb 2006 03:15:40 +0000 (GMT) Received: from [192.168.1.121] (91.Red-83-41-218.dynamicIP.rima-tde.net [83.41.218.91]) by 217-20-115-93.internetserviceteam.com (Postfix) with ESMTP id E8883770004 for ; Sat, 11 Feb 2006 04:14:29 +0100 (CET) Message-ID: <43ED56D3.7040404@mediaroot.de> Date: Sat, 11 Feb 2006 04:15:31 +0100 From: Aldor User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How to VACUUM this table? "998994633 estimated total rows" Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/141 X-Sequence-Number: 20562 Hi, I'm just curious about a VACUUM plan of this table: 1st) When to do VAUUM? 2nd) How often to do VACUUM? 3rd) With which postgresql.conf paremeters to set up vacuum? 4th) When to do a VACUUM FULL? 5th) Can autovacuum of 8.1 be used in this case? I'm a little bit afraid about the size of the table, but I think somebody should have a solution... Here is the complete ANALYZE output of the table: INFO: "tbl1": scanned 300 of 27744713 pages, containing 10802 live rows and 0 dead rows; 300 rows in sample, 998994633 estimated total rows The size of the data is 340 GB, this are 40% of the disk-array. Thanks is advance. Marco