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 369013A45FB for ; Thu, 6 Jan 2005 17:28:44 +0000 (GMT) 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 24134-04 for ; Thu, 6 Jan 2005 17:28:17 +0000 (GMT) Received: from web50005.mail.yahoo.com (web50005.mail.yahoo.com [206.190.38.20]) by svr1.postgresql.org (Postfix) with SMTP id B9E873A42BA for ; Thu, 6 Jan 2005 17:28:17 +0000 (GMT) Received: (qmail 35183 invoked by uid 60001); 6 Jan 2005 17:28:12 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=Gi2CzSqKaIlQ2g9pylKVSmqr5Ku/J3Nsqh/+e9IuJ7HcBAT607hCc+VNxT5JMeeJSumxw5ZbK8KVKJFwj09LrfEeMfUngHKL1oMD5rTgkezLmF9t1HSsX2uFbiWR5g+qunfEBQ3LTjCfVGL1Js+IDtvWiZPqs8I5tr/x+bzKTKI= ; Message-ID: <20050106172812.35181.qmail@web50005.mail.yahoo.com> Received: from [69.65.137.210] by web50005.mail.yahoo.com via HTTP; Thu, 06 Jan 2005 11:28:12 CST Date: Thu, 6 Jan 2005 11:28:12 -0600 (CST) From: Jaime Casanova Subject: Re: max_fsm_relations To: pgsql-admin@postgresql.org In-Reply-To: <41DAAE8B.9060902@deg.cc> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.339 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200501/38 X-Sequence-Number: 15897 --- Pallav Kalva escribió: > Hi Everybody, > > I want to set max_fsm_relations parameter in > the postgres.conf file > is there any way to find out the count of all the > tables and indexes in all the databases without > running any vacuum > verbose commands ? > maybe select count(*) from pg_class where relname like 'some-prefix-youuse%'; but you need to do this per-database. besides your tables must have a prefix to identify them if they have not maybe the owner if it is postgres, wll i don't know. regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com