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?
On Sun, Jun 7, 2009 at 4:15 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> S Arvind <arvindwill(at)gmail(dot)com> writes:
> > But there nearly only 300 tables in that db. Is the free space map is
> > DB or for all DB. Can i know the reason of this problem?
> It's across all DBs in the installation.
> regards, tom lane
In response to
pgsql-performance by date
|Next:||From: S Arvind||Date: 2009-06-06 22:59:53|
|Subject: Re: Vacuum ALL FULL|
|Previous:||From: Tom Lane||Date: 2009-06-06 22:45:08|
|Subject: Re: Vacuum ALL FULL |