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: (view raw, whole thread or download thread mbox)
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 ?

select count(*) from pg_class where relname like

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.

Jaime Casanova

Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en

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-2017 The PostgreSQL Global Development Group