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 962F5D84B8 for ; Tue, 30 Aug 2005 10:01:54 -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 51113-07 for ; Tue, 30 Aug 2005 13:01:52 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 53144D847D for ; Tue, 30 Aug 2005 10:01:51 -0300 (ADT) Received: (qmail 24529 invoked by uid 500); 30 Aug 2005 13:01:40 -0000 Date: Tue, 30 Aug 2005 08:01:40 -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: <20050830130140.GE22545@wolff.to> Mail-Followup-To: Bruno Wolff III , jose fuenmayor , pgsql-admin@postgresql.org References: <69f2062a05082505523a9e485a@mail.gmail.com> <20050825132334.GE15100@wolff.to> <69f2062a050830053829b874c5@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <69f2062a050830053829b874c5@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/382 X-Sequence-Number: 18701 On Tue, Aug 30, 2005 at 08:38:03 -0400, jose fuenmayor wrote: > i am using postgreSql 8.0.3 i've try vacuum "vacuum full" the hole database > but it takes too long, seems it will never be finished, i've tried "vacuum > " and the table remains nearly the same as isee i my PGDATA > directory. is this normal? . is there something i can do ? Have you tried VACUUM FULL on just that table? It may be that your FSM setting isn't high enough to remove all of the dead tuples with a normal vacuum. How long did you wait when you tried to vacuum full the whole database? Another option is to use the CLUSTER command on the big table. If that table is mostly dead tuples, cluster may run faster than vacuum full.