Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 247E02E0044 for ; Tue, 22 Apr 2008 14:37:12 -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 26011-02 for ; Tue, 22 Apr 2008 14:37:00 -0300 (ADT) X-Greylist: delayed 00:05:30.196333 by SQLgrey-1.7.5 Received: from azazel.oficina (smtp.akyasociados.com.ar [200.68.121.201]) by developer.postgresql.org (Postfix) with ESMTP id 00D9D2E0046 for ; Tue, 22 Apr 2008 14:37:01 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by azazel.oficina (8.14.1/8.13.8) with ESMTP id m3MHVX3V082068 for ; Tue, 22 Apr 2008 14:31:33 -0300 (ART) (envelope-from rafael@akyasociados.com.ar) X-Virus-Scanned: amavisd-new at akyasociados.com.ar Received: from azazel.oficina ([127.0.0.1]) by localhost (azazel.akyasociados.com.ar [127.0.0.1]) (amavisd-new, port 10024) with LMTP id ydkRa0EShDFH for ; Tue, 22 Apr 2008 14:31:26 -0300 (ART) Received: from [192.168.1.180] (rattlehead.oficina [192.168.1.180]) (authenticated bits=0) by azazel.oficina (8.14.1/8.13.8) with ESMTP id m3MHV2qR082044 for ; Tue, 22 Apr 2008 14:31:03 -0300 (ART) (envelope-from rafael@akyasociados.com.ar) Message-ID: <480E2FBE.3010607@akyasociados.com.ar> Date: Tue, 22 Apr 2008 15:34:38 -0300 From: Rafael Barrera Oro User-Agent: Thunderbird 2.0.0.6 (X11/20070917) MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Suspicious top output Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/331 X-Sequence-Number: 29824 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? should i worry? Thanks in advance, as always yours trully Rafael