Re: Random server overload

Поиск
Список
Период
Сортировка
От Viktor
Тема Re: Random server overload
Дата
Msg-id 524BD56C.7030900@okservers.eu
обсуждение исходный текст
Ответ на Re: Random server overload  (Igor Neyman <ineyman@perceptron.com>)
Ответы Re: Random server overload
Список pgsql-admin
On 10/1/2013 4:45 PM, Igor Neyman wrote:
> Did you try using any kind of connection pooler, e.g. PgBouncer?
> Should help.

Our Java application uses c3p0 connection pooler and we don't think that
it's the issue.


On 10/1/2013 6:15 PM, Albe Laurenz wrote:
> Looks like something tries to open lots of connections at these times.
>
> Your best bet is to is to set log_connections = on and examine the log file
> when the problem happens.  That way you can figure out where the connections
> come from.
>
> Yours,
> Laurenz Albe

I have made the changes to the config file and will update this ticket
later with the results.

Thank you all!



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

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: DB link from postgres to Oracle; how to query Dbname.tablename?
Следующее
От: Nikolay Morozov
Дата:
Сообщение: Database replication to 50-80 nodes