From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Huge spikes in number of connections doing "PARSE" |
Date: | 2011-03-09 20:38:07 |
Message-ID: | 20110309203807.GA12394@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,
i have a server with pg 8.3.11.
Every now and then, for no apparent reason (io normal, cpu usage normal,
web traffic normal) i see hundreds of connections in "PARSE" state.
to give some perspective - we're doing in the lowest traffic of the day
around 3000 transactions per second, with ~ 500-600 connections.
So. every now and then (couple of times per day at most). I see hundreds
(800-900) of connections in "PARSE" state.
I did notice one thing.
we do log output of ps axo user,pid,ppid,pgrp,%cpu,%mem,rss,lstart,nice,nlwp,sgi_p,cputime,tty,wchan:25,args
every 15 seconds or so.
And based on its output, I was able to get stats of "wchan" of all PARSE
pg processes when the problem was logged.
Results:
805 x semtimedop
10 x stext
Any ideas on what could be wrong? Machine was definitely not loaded most
of the times it happened.
The problem usually goes away in ~ 10-15 seconds.
Any hints? Suggestions?
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
From | Date | Subject | |
---|---|---|---|
Next Message | John Edens | 2011-03-09 21:39:43 | Re: How to configure for remote TCP/IP client conncections using MS Visual Basic OLE DB calls and PostgreSQL dll's? |
Previous Message | akp geek | 2011-03-09 20:19:13 | pg_restore: [archiver] unsupported version (1.12) in file header |