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 DDAFF5E46E7 for ; Mon, 30 Aug 2004 13:52:51 -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 64175-06 for ; Mon, 30 Aug 2004 16:52:54 +0000 (GMT) Received: from web52801.mail.yahoo.com (web52801.mail.yahoo.com [206.190.39.165]) by svr1.postgresql.org (Postfix) with SMTP id 62FEF5E46D4 for ; Mon, 30 Aug 2004 13:52:45 -0300 (ADT) Message-ID: <20040830165245.7337.qmail@web52801.mail.yahoo.com> Received: from [68.101.43.86] by web52801.mail.yahoo.com via HTTP; Mon, 30 Aug 2004 09:52:45 PDT Date: Mon, 30 Aug 2004 09:52:45 -0700 (PDT) From: kris pal Subject: Re: pg_attribute - Index To: Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <7947.1093883821@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1547182727-1093884765=:5490" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200408/302 X-Sequence-Number: 14697 --0-1547182727-1093884765=:5490 Content-Type: text/plain; charset=us-ascii I am running 7.4.1 on Linux 2.4.21-15.ELsmp kernel. thanks, Kris Pal. Tom Lane wrote:kris pal writes: > 1) Even if I vacuum regularly, the index > "pg_attribute_relid_attnam_index" is growing very fast because of huge > data loads and deletes. You were running an old version, weren't you? This should be fixed in 7.4 ... regards, tom lane --------------------------------- Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! --0-1547182727-1093884765=:5490 Content-Type: text/html; charset=us-ascii
 
I am running 7.4.1 on Linux 2.4.21-15.ELsmp kernel.
 
thanks,
Kris Pal.


Tom Lane <tgl@sss.pgh.pa.us> wrote:
kris pal writes:
> 1) Even if I vacuum regularly, the index
> "pg_attribute_relid_attnam_index" is growing very fast because of huge
> data loads and deletes.

You were running an old version, weren't you? This should be fixed
in 7.4 ...

regards, tom lane


Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage! --0-1547182727-1093884765=:5490--