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 1E8FDD8462 for ; Tue, 30 Aug 2005 10:26:19 -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 60400-01 for ; Tue, 30 Aug 2005 13:26:15 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.198]) by svr1.postgresql.org (Postfix) with ESMTP id 5BC89D7BE4 for ; Tue, 30 Aug 2005 10:26:11 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id z6so764676nzd for ; Tue, 30 Aug 2005 06:26:16 -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=jlqujEMKiphCwvA62fMvp3z29EpIE6Y+HDZIwQn39DtlSlwAtTBK9CzoyGvYVjqQQJZyW97hzVshovO9sCrXW8obFfne5SWDpD1B46mIEUYOwsxkjTi1WbG/X/ZjrxJr68mYar/JqP/8kCtaxGxU03hCJT2wYSf2uGQArr5pVFo= Received: by 10.36.113.11 with SMTP id l11mr1733261nzc; Tue, 30 Aug 2005 06:26:16 -0700 (PDT) Received: by 10.36.138.5 with HTTP; Tue, 30 Aug 2005 06:26:16 -0700 (PDT) Message-ID: <69f2062a0508300626f33aa45@mail.gmail.com> Date: Tue, 30 Aug 2005 09:26:16 -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: <20050830130140.GE22545@wolff.to> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4985_29802356.1125408376071" References: <69f2062a05082505523a9e485a@mail.gmail.com> <20050825132334.GE15100@wolff.to> <69f2062a050830053829b874c5@mail.gmail.com> <20050830130140.GE22545@wolff.to> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.687 required=5 tests=[AWL=0.090, 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/384 X-Sequence-Number: 18703 ------=_Part_4985_29802356.1125408376071 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline i waited like 11 hours and it doesn't finish, where is the FSM setting=20 postgreSQL.conf? On 8/30/05, Bruno Wolff III wrote: >=20 > 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=20 > database > > but it takes too long, seems it will never be finished, i've tried=20 > "vacuum > > " and the table remains nearly the same as isee i my PGDATA > > directory. is this normal? . is there something i can do ? >=20 > Have you tried VACUUM FULL on just that table? >=20 > It may be that your FSM setting isn't high enough to remove all of the > dead tuples with a normal vacuum. >=20 > How long did you wait when you tried to vacuum full the whole database? >=20 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. > ------=_Part_4985_29802356.1125408376071 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline i waited like 11 hours and it doesn't finish, where is the FSM setting post= greSQL.conf?

On 8/30/05, Bruno Wolff III < bruno@wolff.to> wrote:
On Tue, Aug 30, 2005 at 08:38:03 -0400,
  j= ose fuenmayor < jafn82@gmail.com> wrote:
>= i am using postgreSql 8.0.3 i've try vacuum "vacuum full" the ho= le database
> but it takes too long, seems it will never be finished,= i've tried "vacuum
> <table_name>" 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 ma= y 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
t= able is mostly dead tuples, cluster may run faster than vacuum full.

------=_Part_4985_29802356.1125408376071--