Re: Vacuum ALL FULL

[S Arvind <arvindwill@xxxxxxxxx>]

So is it no use running 
vacuumdb --all --analyze --full
as fsm map is full? 

-Arvind S

On Sun, Jun 7, 2009 at 4:24 AM, S Arvind <arvindwill@xxxxxxxxx> wrote:

Thanks Tom,
So do i have to increase the max_fsm_relation based on (Average_no_relation per db * number of db)? if so it will be very high since in our one db server we have 200 db with average 800 tables in each db. What is the value we have to give for this kind of server?

-Arvind S

On Sun, Jun 7, 2009 at 4:15 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

S Arvind <arvindwill@xxxxxxxxx> writes:
> But there nearly only 300 tables in that db. Is the  free space map is per
> DB or for all DB. Can i know the reason of this problem?

It's across all DBs in the installation.

                       regards, tom lane