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 593D75E4B91 for ; Sat, 4 Sep 2004 04:23:22 +0100 (BST) 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 79382-04 for ; Sat, 4 Sep 2004 03:23:18 +0000 (GMT) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by svr1.postgresql.org (Postfix) with ESMTP id 5A3E75E49A5 for ; Sat, 4 Sep 2004 04:21:33 +0100 (BST) Received: from web52803.mail.yahoo.com (web52803.mail.yahoo.com [206.190.39.167]) by svr4.postgresql.org (Postfix) with SMTP id 08DA75B0A8A for ; Fri, 3 Sep 2004 19:19:04 +0000 (GMT) Message-ID: <20040903191703.7070.qmail@web52803.mail.yahoo.com> Received: from [68.101.43.86] by web52803.mail.yahoo.com via HTTP; Fri, 03 Sep 2004 12:17:03 PDT Date: Fri, 3 Sep 2004 12:17:03 -0700 (PDT) From: kris pal Subject: Re: repeat Q: pg_attribute - Index To: kris pal , Tom Lane Cc: pgsql-admin@postgresql.org In-Reply-To: <20040830165245.7337.qmail@web52801.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1559322781-1094239023=:5915" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200409/32 X-Sequence-Number: 14735 --0-1559322781-1094239023=:5915 Content-Type: text/plain; charset=us-ascii Hi, So can anyone suggest an easy way to REINDEX "pg_attribute_relid_attnam_index" (belongs to System Catalog). I am running 7.4.1 on Red Hat Linux 2.4.21-15.ELsmp kernel. Frequest data loads / deletes is causing this to grow at a fast rate. This is becoming a concern. I don't want to drop and reimport the whole database everytime. thanks, Kris Pal. kris pal wrote: 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! __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --0-1559322781-1094239023=:5915 Content-Type: text/html; charset=us-ascii
Hi,
 
So can anyone suggest an easy way to REINDEX "pg_attribute_relid_attnam_index" (belongs to System Catalog).
I am running 7.4.1 on Red Hat Linux 2.4.21-15.ELsmp kernel. Frequest data loads / deletes is causing this to grow at a fast rate. 
 
This is becoming a concern. I don't want to drop and reimport the whole database everytime.
 
thanks,
Kris Pal.


kris pal <kristhegambler@yahoo.com> wrote:
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!

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com --0-1559322781-1094239023=:5915--