Re: Vacuum ALL FULL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx> wrote:
S Arvind <arvindwill@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux