X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E85A2D7109 for ; Thu, 25 Aug 2005 10:24:00 -0300 (ADT) 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 77888-07 for ; Thu, 25 Aug 2005 13:23:59 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 2D441D7F08 for ; Thu, 25 Aug 2005 10:23:58 -0300 (ADT) Received: (qmail 18491 invoked by uid 500); 25 Aug 2005 13:23:34 -0000 Date: Thu, 25 Aug 2005 08:23:34 -0500 From: Bruno Wolff III To: jose fuenmayor Cc: pgsql-admin@postgresql.org Subject: Re: size of indexes and tables (more than 1GB) Message-ID: <20050825132334.GE15100@wolff.to> Mail-Followup-To: Bruno Wolff III , jose fuenmayor , pgsql-admin@postgresql.org References: <69f2062a05082505523a9e485a@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <69f2062a05082505523a9e485a@mail.gmail.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/314 X-Sequence-Number: 18633 On Thu, Aug 25, 2005 at 08:52:35 -0400, jose fuenmayor wrote: > > The size of the table is 3 times bigger than, for instance Visual Fox > Pro dbf's? since is there fisically three times. Have you been vacuuming properly? It is possible you have a lot of dead tuples in the database. If that seems to be the case and you need more help dealing with this, please include the version of Postgres you are running, since that will affect what suggestions people will give you.