Re: Interpreting vacuum verbosity

Поиск
Список
Период
Сортировка
От Ed L.
Тема Re: Interpreting vacuum verbosity
Дата
Msg-id 200405071229.01168.pgsql@bluepolka.net
обсуждение исходный текст
Ответ на Re: Interpreting vacuum verbosity  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: Interpreting vacuum verbosity  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Friday May 7 2004 12:23, Ed L. wrote:
> On Friday May 7 2004 12:20, Ed L. wrote:
> > 1)  I'm inclined to set this to handle as large a DB footprint as will
> > be in the coming year or two, so maybe 3X what it is now.  What is the
> > impact/cost of setting max_fsm_pages at, say, 3M for an 8GB footprint?
> > (3 x 8GB/8K)
>
> Ok, so I see 40B per, so setting it to 3M ==> 3M * 40 = 120MB of
> additional RAM usage for this?  Any other impacts with which to be
> concerned?

Sorry, I see that's *6B* per, so setting it to 3M ==> 18MB, which is trivial
for the benefit.  Any other concerns in setting this too high?



В списке pgsql-general по дате отправления:

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: Interpreting vacuum verbosity
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Interpreting vacuum verbosity