X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A18F89DCA54 for ; Thu, 23 Mar 2006 23:58:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 98798-09 for ; Thu, 23 Mar 2006 23:58:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id 434E99DC9FB for ; Thu, 23 Mar 2006 23:58:06 -0400 (AST) Received: by nproxy.gmail.com with SMTP id y38so384105nfb for ; Thu, 23 Mar 2006 19:58:12 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CtTKOpsDUnQ0aKsoa+lViKMgUiQ7K3FVIEhoENVHCodNbRnW1YXffGXKZoQz3Vq4g4NF91/8/slqsLGDioU66RXHnXuw0BFlZBBejtDgQ1hjgh0B8rTBcujEMKib/9WIF5/KahJUPd9D/kkfSePCcJsYJmQYhuya6af/oE7a53Q= Received: by 10.49.39.19 with SMTP id r19mr58651nfj; Thu, 23 Mar 2006 19:58:11 -0800 (PST) Received: by 10.48.144.19 with HTTP; Thu, 23 Mar 2006 19:58:11 -0800 (PST) Message-ID: Date: Thu, 23 Mar 2006 22:58:11 -0500 From: "Gregory Maxwell" To: "Tom Lane" Subject: Re: Bloated pg_shdepend_depender_index Cc: pgsql-admin@postgresql.org In-Reply-To: <21266.1143170652@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20060324023105.GB11242@surnet.cl> <21266.1143170652@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.873 required=5 tests=[AWL=-0.459, RCVD_IN_BL_SPAMCOP_NET=1.332] X-Spam-Score: 0.873 X-Spam-Level: X-Archive-Number: 200603/228 X-Sequence-Number: 20985 On 3/23/06, Tom Lane wrote: > > amarokcollection=3D# select relname, pg_relation_size(oid) FROM > > pg_class ORDER BY 2 DESC LIMIT 20; > > relname | pg_relation_size > > ---------------------------------+------------------ > > pg_attribute_relid_attnam_index | 2881069056 > > pg_class_relname_nsp_index | 1185890304 > > That's in a different database --- evidently, the one where a *whole* > lotta temp tables have been created and dropped. If you haven't been > doing any vacuuming then system catalog bloat is to be expected. Oh sure enough it is.. I'm glad I copied the prompt. :) So it's by design that these now bloated index won't shrink if let unvacuumed? I didn't expect to hit something like that. Okay, so long as it wasn't a bug. I've reindexed the system tables now. The database is now 6mb on disk.. a big improvement from 6gb. :) Thanks.