Re: Random server overload - Mailing list pgsql-admin

From Viktor
Subject Re: Random server overload
Date
Msg-id 524BD56C.7030900@okservers.eu
Whole thread Raw
In response to Re: Random server overload  (Igor Neyman <ineyman@perceptron.com>)
Responses Re: Random server overload  (Igor Neyman <ineyman@perceptron.com>)
List 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 by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: DB link from postgres to Oracle; how to query Dbname.tablename?
Next
From: Nikolay Morozov
Date:
Subject: Database replication to 50-80 nodes