Re: Vacuum ALL FULL

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

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