Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum ALL FULL - Mailing list pgsql-performance

From S Arvind
Subject Re: Vacuum ALL FULL
Date
Msg-id abf9211d0906061609q2551ed66n975b243eaa108a38@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum ALL FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
Sorry Tom, i cant able to understand. Should i have to increse the max_fsm_rel based on formula and re-run the vacuum command? The main reason for vacuum for us is to increase performance of our db. Please tell value for our kind of server(as provided in previous mail) ?

-- Arvind S

On Sun, Jun 7, 2009 at 4:32 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
S Arvind <arvindwill@gmail.com> writes:
> So is it no use running
> vacuumdb --all --analyze --full
> as fsm map is full?

Well, it's not of *no* use.  But you'd be well advised to crank up the
FSM size.

                       regards, tom lane

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

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