Skip site navigation (1) Skip section navigation (2)

Re: max_fsm_relations

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: max_fsm_relations
Date: 2005-01-06 17:28:12
Message-ID: 20050106172812.35181.qmail@web50005.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
 --- 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

In response to

pgsql-admin by date

Next:From: Markus BertheauDate: 2005-01-07 07:33:01
Subject: Re: (resend) NULL constrains inheritance to views
Previous:From: Bradley KieserDate: 2005-01-06 17:05:42
Subject: (resend) NULL constrains inheritance to views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group