Re: problem with memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: problem with memory
Дата
Msg-id 13165.1243353602@sss.pgh.pa.us
обсуждение исходный текст
Ответ на problem with memory  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: problem with memory  (Greg Stark <greg.stark@enterprisedb.com>)
Список pgsql-hackers
Pavel Stehule <pavel.stehule@gmail.com> writes:
> one czech PostgreSQL user reports problem with memory - probable memleak?
> Is possible to diagnose some from log?

If he's getting an actual "out of memory" error, let's see the memory
context map that gets dumped to the server log (or more specifically,
to stderr).

> Server 8G RAM,  32b Debian Etch.
> shared_buffers = 324000        # min 16 or max_connections*2, 8KB each

Although you may have told us enough right here.  2.5GB of shared
buffers in a 4GB address space (with probably only 3GB available to the
application) isn't a very sane choice.  Back that off or run 64-bit.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: PostgreSQL Developer meeting minutes up
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL Developer meeting minutes up