Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: S ArvindDate: 2009-06-06 22:59:53
Subject: Re: Vacuum ALL FULL
Previous:From: Tom LaneDate: 2009-06-06 22:45:08
Subject: Re: Vacuum ALL FULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group