Re: Random server overload

From: Viktor <viktor(at)okservers(dot)eu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Random server overload
Date: 2013-10-02 08:12:28
Message-ID: 524BD56C.7030900@okservers.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nikolay Morozov 2013-10-02 08:20:34 Database replication to 50-80 nodes
Previous Message Albe Laurenz 2013-10-02 07:58:59 Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename?