X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 02A92329FC7 for ; Fri, 8 Oct 2004 19:25:35 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14977-07 for ; Fri, 8 Oct 2004 18:24:57 +0000 (GMT) Received: from mail.deg.cc (unknown [64.139.134.201]) by svr1.postgresql.org (Postfix) with ESMTP id 6F5C132A37E for ; Fri, 8 Oct 2004 19:22:37 +0100 (BST) Received: from deg.cc (unknown [198.70.16.205]) by mail.deg.cc (Postfix) with ESMTP id 80FF0560C4 for ; Fri, 8 Oct 2004 14:22:32 -0400 (EDT) Message-ID: <4166DB45.9060300@deg.cc> Date: Fri, 08 Oct 2004 14:24:05 -0400 From: Pallav Kalva User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Vacuumdb Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200410/134 X-Sequence-Number: 15127 Hi Everybody, If i do vacuumdb -z daily as a part of my maintanence, do i have to still vacuum analyze each table in the database ?. The reason i am asking is that even though i do vacuumdb daily my stats are not updated properly in pg_class view and the reltuples values is much higher than the actual records in the table ? can anyone shed some light on this problem ? Thanks! Pallav