From: | Robert Gravsjö <robert(at)blogg(dot)se> |
---|---|
To: | anypossibility <anypossibility(at)zoho(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Debug advice when postgres connection maxing out |
Date: | 2010-11-23 12:00:07 |
Message-ID: | 4CEBACC7.3040606@blogg.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2010-11-22 20.41, anypossibility wrote:
> Server: OS X 10.5
> PostgreSQL version: 8.3
>
>
> We experience this connection maxing out once in the full moon.
> The request from client reaches to the server but client never receive response back.
> The queries are very simple update on one record or select one record using primary key (checked current_query from pg_stat_activity).
> Once this started, I normally disconnect all the client (quit client programs) however, the processes don't die on postgres server.
> So I tried to quit PostgreSQL server using pg_ctl, no response. The only way to terminate is to restart the server (I will try kill -s INT next time.. i didn't know better).
> Is there anything you can tell me from this symptoms or anything I can do to generate useful log to analyze?
If track_activities is on in your postgresql.conf you can check
pg_stats_activity to see what query creates the problem.
Maybe http://www.postgresql.org/docs/8.3/static/monitoring-stats.html
can give you some more ideas.
--
Regards,
Robert "roppert" Gravsjö
From | Date | Subject | |
---|---|---|---|
Next Message | Sam Mason | 2010-11-23 12:34:58 | Re: very basic SQL question |
Previous Message | Armand Turpel | 2010-11-23 11:37:57 | Re: json data type |