Received: from localhost (unknown [200.46.204.184])
	by developer.postgresql.org (Postfix) with ESMTP id D2E472E0044
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 20:50:54 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 92713-01
	for <pgsql-performance-postgresql.org@developer.postgresql.org>;
	Tue, 22 Apr 2008 20:50:39 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from ciao.gmane.org (main.gmane.org [80.91.229.2])
	by developer.postgresql.org (Postfix) with ESMTP id 7F5242E002C
	for <pgsql-performance@postgresql.org>;
	Tue, 22 Apr 2008 20:50:45 -0300 (ADT)
Received: from list by ciao.gmane.org with local (Exim 4.43)
	id 1JoSG3-0006Aw-IF
	for pgsql-performance@postgresql.org; Tue, 22 Apr 2008 23:50:43 +0000
Received: from 89-172-63-116.adsl.net.t-com.hr ([89.172.63.116])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Tue, 22 Apr 2008 23:50:43 +0000
Received: from ivoras by 89-172-63-116.adsl.net.t-com.hr with local (Gmexim
	0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-performance@postgresql.org>; Tue, 22 Apr 2008 23:50:43 +0000
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-performance@postgresql.org
From: Ivan Voras <ivoras@geri.cc.fer.hr>
Subject: Re: Suspicious top output
Date: Wed, 23 Apr 2008 01:50:33 +0200
Lines: 19
Message-ID: <fultkb$r9k$1@ger.gmane.org>
References: <480E2FBE.3010607@akyasociados.com.ar>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: 89-172-63-116.adsl.net.t-com.hr
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
In-Reply-To: <480E2FBE.3010607@akyasociados.com.ar>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200804/334
X-Sequence-Number: 29827

Rafael Barrera Oro wrote:
> Hello, i have a postgresql server running and from time to time it gets
> painfully slow. When this happens i usually connect to the server and
> run a "top" command, the output i get is filled with lines like the
> following
> 
> 71872 pgsql            1   4    0 48552K 42836K sbwait   1:41  4.79%
> postgres
> 
> Are those connections that were not closed or something like that?

This looks like FreeBSD; "sbwait" state is socket buffer wait, and 
guessing from the CPU usage the process seems to be talking to another 
process.

> should i worry?

Don't know. Are you sure all client processes disconnect properly from 
the database?