Re: postmaster grows

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: postmaster grows
Дата
Msg-id 24933.981473857@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: postmaster grows  (Max Vaschenko <max@nino.ru>)
Список pgsql-bugs
Max Vaschenko <max@nino.ru> writes:
> After some (2-3 weeks) time both postmaster and all (every) backends take
> about 60mb memory.

Okay, then it is a postmaster leak.  The backends are started by fork
from the postmaster, so they'd inherit whatever data memory size the
postmaster currently has.

> May be backend that running long time, causes other postgres processes
> to grow?

Not possible for a backend to affect the postmaster like that, AFAICS.
I think it's just a garden-variety memory leak in some postmaster
operation.

Since this isn't being reported by other folks, either there's a
system-specific problem or you are using a postmaster feature that's not
widely used.  RedHat 6.2 is pretty common so we can probably eliminate
system-specific issues.  Which authentication method(s) do you use?
(If you could send your whole pg_hba.conf file, that might be useful to
look at.)

            regards, tom lane

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

Предыдущее
От: Max Vaschenko
Дата:
Сообщение: Re: postmaster grows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: UNION and VIEW