Re: Vacuum ALL FULL

Поиск
Список
Период
Сортировка
От S Arvind
Тема Re: Vacuum ALL FULL
Дата
Msg-id abf9211d0906061609q2551ed66n975b243eaa108a38@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vacuum ALL FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum ALL FULL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum ALL FULL