Re: Vacuum ALL FULL - Mailing list pgsql-performance

From S Arvind
Subject Re: Vacuum ALL FULL
Date
Msg-id abf9211d0906061554o1fd1f644t54c677bab21035d3@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum ALL FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Vacuum ALL FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
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@sss.pgh.pa.us> wrote:
S Arvind <arvindwill@gmail.com> 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

pgsql-performance by date:

Previous
From: S Arvind
Date:
Subject: Re: Vacuum ALL FULL
Next
From: Tom Lane
Date:
Subject: Re: Vacuum ALL FULL