Re: Vacuum ALL FULL - Mailing list pgsql-performance

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