Re: max_fsm_relations

--- Pallav Kalva <pkalva(at)deg(dot)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