Re: Vacuum ALL FULL

From: S Arvind <arvindwill(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Vacuum ALL FULL
Date: 2009-06-06 22:54:29
Message-ID: abf9211d0906061554o1fd1f644t54c677bab21035d3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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
> 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
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message S Arvind 2009-06-06 22:59:53 Re: Vacuum ALL FULL
Previous Message Tom Lane 2009-06-06 22:45:08 Re: Vacuum ALL FULL