От: Tom Lane
Тема: Re: Vacuum ALL FULL
Дата: ,
Msg-id: 411.1244329951@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: Vacuum ALL FULL  (S Arvind)
Ответы: Re: Vacuum ALL FULL  (S Arvind)
Список: pgsql-performance

Скрыть дерево обсуждения

Vacuum ALL FULL  (S Arvind, )
 Re: Vacuum ALL FULL  (S Arvind, )
 Re: Vacuum ALL FULL  (Tom Lane, )
  Re: Vacuum ALL FULL  (S Arvind, )
   Re: Vacuum ALL FULL  (Tom Lane, )
    Re: Vacuum ALL FULL  (S Arvind, )
 Re: Vacuum ALL FULL  (S Arvind, )
  Re: Vacuum ALL FULL  (Tom Lane, )
   Re: Vacuum ALL FULL  (S Arvind, )

S Arvind <> writes:
> 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?

About 160000.

One wonders whether you shouldn't rethink your schema design.  Large
numbers of small tables usually are not a good use of SQL.  (I assume
they're small, else you'd have had serious bloat problems already from
your undersized max_fsm_pages setting ...)

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: S Arvind
Дата:
Сообщение: Postgres installation for Performance
От: Dimitri Fontaine
Дата:
Сообщение: Re: Pointers needed on optimizing slow SQL statements