From: Jaime Casanova <systemguards@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: max_fsm_relations
Date: Thu, 6 Jan 2005 11:28:12 -0600 (CST)
Message-ID: <20050106172812.35181.qmail@web50005.mail.yahoo.com> (raw)
In-Reply-To: <41DAAE8B.9060902@deg.cc>
--- Pallav Kalva <pkalva@deg.cc> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: systemguards@yahoo.com
Subject: Re: max_fsm_relations
In-Reply-To: <20050106172812.35181.qmail@web50005.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox