Обсуждение: max_fsm_relations

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 ?

Thanks!
Pallav

 --- 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