Advice about -B n_buffers option

Поиск
Список
Период
Сортировка
От Robert Williams
Тема Advice about -B n_buffers option
Дата
Msg-id 38ECB3AF.F44E961E@bob.usuhs.mil
обсуждение исходный текст
Ответ на Re: Date formats in 7.0b2  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-admin
I have a postmaster process that is crashing periodically.
I haven't turned on debugging yet, but I suspect the
number of buffers may be low (its 64).
Does anyone have some general observations about
the importance of having more buffers?



      -B n_buffers
           n_buffers is the number of shared-memory buffers  for
           the postmaster to allocate and manage for the backend
           server processes that it starts.  This value defaults
           to 64, and each buffer is 8k bytes.

as in "postmaster -D /usr/local/var/Postgresql -B 128"


--
Bob Williams, http://bob.usuhs.mil/
office: 301-295-3568




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

Предыдущее
От: Brad Bonkoski
Дата:
Сообщение: Still Looking
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: changing the owner of a db