Huge spikes in number of connections doing "PARSE"

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/

Responses

Browse pgsql-general by date

  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