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 C6126D6E95 for ; Tue, 30 Aug 2005 09:38:04 -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 46641-09 for ; Tue, 30 Aug 2005 12:38:02 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.194]) by svr1.postgresql.org (Postfix) with ESMTP id 60435D6E6B for ; Tue, 30 Aug 2005 09:38:00 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z6so757250nzd for ; Tue, 30 Aug 2005 05:38:04 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=XujKLlc2ijWzuhKWThDk5d3qppFvEBDXsyWpzESGN/ixH3kcy5eWIUxdAxXy8skD8eRpRNN8ea+RVYvPrTeqr+1/cBrzzOkUDNoOUhDiXUKAFzSO1Imw4kowFgksdTW6t4w9Z+E8LFSdw/BH408zYKyKODusaaOT4Ioe4jpzURE= Received: by 10.37.13.7 with SMTP id q7mr1697917nzi; Tue, 30 Aug 2005 05:38:04 -0700 (PDT) Received: by 10.36.138.5 with HTTP; Tue, 30 Aug 2005 05:38:03 -0700 (PDT) Message-ID: <69f2062a050830053829b874c5@mail.gmail.com> Date: Tue, 30 Aug 2005 08:38:03 -0400 From: jose fuenmayor To: Bruno Wolff III , jose fuenmayor , pgsql-admin@postgresql.org Subject: Re: size of indexes and tables (more than 1GB) In-Reply-To: <20050825132334.GE15100@wolff.to> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4583_1840978.1125405483944" References: <69f2062a05082505523a9e485a@mail.gmail.com> <20050825132334.GE15100@wolff.to> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.699 required=5 tests=[AWL=0.102, FROM_ENDS_IN_NUMS=0.516, HTML_30_40=0.056, HTML_MESSAGE=0.001, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/381 X-Sequence-Number: 18700 ------=_Part_4583_1840978.1125405483944 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline i am using postgreSql 8.0.3 i've try vacuum "vacuum full" the hole database= =20 but it takes too long, seems it will never be finished, i've tried "vacuum= =20 " and the table remains nearly the same as isee i my PGDATA=20 directory. is this normal? . is there something i can do ? On 8/25/05, Bruno Wolff III wrote: >=20 > 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. >=20 > 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. > ------=_Part_4583_1840978.1125405483944 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline i am using postgreSql  8.0.3 i've try vacuum "vacuum full" t= he hole database but it takes too long, seems it will never be finished, i've tried "vacuum <table_name>" and the table remains near= ly the same as isee i my PGDATA directory. is this normal? . is there something i can do ?

On 8/25/05, Bruno Wolff III <bruno@wolff.to> wrote:
On Thu, Aug 25, 2005 at 08:52:35 -0400,
  jose fuenmayor <<= a href=3D"mailto:jafn82@gmail.com">jafn82@gmail.com> wrote:
><= br>> The size of the table is 3 times bigger than,  for instan= ce 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 m= ore
help dealing with this, please include the version of Postgres you a= re
running, since that will affect what suggestions people will give you.<= br>

------=_Part_4583_1840978.1125405483944--