Re: performance tuning: shared_buffers, sort_mem; swap

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: performance tuning: shared_buffers, sort_mem; swap
Дата
Msg-id 27214.1029257785@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: performance tuning: shared_buffers, sort_mem; swap  (Thomas O'Connell <tfo@monsterlabs.com>)
Список pgsql-admin
"Thomas O'Connell" <tfo@monsterlabs.com> writes:
> we've had the issue before where postgres will die under heavy load
> (meaning Apache is logging several requests per minute and stressing
> postgres, too) with the error about how probably we don't have shared
> memory configured appropriately.

Uh, which error exactly?  AFAIK all the shared-memory-related messages
would only come out at postmaster startup, not during peak load.  The
system is designed to ensure that those resources are all reserved
during postmaster start.

            regards, tom lane

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

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: Leftover processes on shutdown - Debian+JDBC
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: performance tuning: shared_buffers, sort_mem; swap