Re: postgres generates too much processes per minute

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: postgres generates too much processes per minute
Дата
Msg-id 20080619101710.dba7192e.wmoran@collaborativefusion.com
обсуждение исходный текст
Ответ на postgres generates too much processes per minute  ("coliban@gmail.com" <coliban@gmail.com>)
Ответы Re: postgres generates too much processes per minute  ("Josh Tolley" <eggyknap@gmail.com>)
Список pgsql-general
In response to "coliban@gmail.com" <coliban@gmail.com>:

> Hello,
>
> i have the problem that postgres ist starting and stopping several (up
> to 4)  processes per minute, so that the error log in windows is
> running full, with more than 14 entries every minute.
>
> Does someone know, how to reduce the start and the end of so many
> processes, is there a variable or something ?

A process is started for every connection and ends when the connection
is closed.  If you're opening/closing connections frequently, you'll
see this.  It's by design.

Is the problem just that it's overwhelming the logs?  If so, you're
best bet is probably to reduce the amount of logging that occurs.

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Vacuum and inserts
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Vacuum and inserts