From owner-freebsd-questions@FreeBSD.ORG Fri Mar 17 20:30:51 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 17DF716A400 for ; Fri, 17 Mar 2006 20:30:51 +0000 (UTC) (envelope-from dino_vliet@yahoo.com) Received: from web51106.mail.yahoo.com (web51106.mail.yahoo.com [206.190.38.148]) by mx1.FreeBSD.org (Postfix) with SMTP id 43F4843D5E for ; Fri, 17 Mar 2006 20:30:46 +0000 (GMT) (envelope-from dino_vliet@yahoo.com) Received: (qmail 45544 invoked by uid 60001); 17 Mar 2006 20:30:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=LHLYNwxRtRU11zLDjx4GfbK+f/rn2gImUPXcrDBR5t8TQwjjGV43pXGAFUCTdXKgjparq8EuAyZRy9kaoKoy3lffAWCzfcGRZsGwubVROSuiXLQfE3K4Iy3g7/1971pfVXAwEbohqWp9ks67IoGdbyMAGoLGOL3pMhDVpNdQ3hg= ; Message-ID: <20060317203045.45542.qmail@web51106.mail.yahoo.com> Received: from [83.160.155.248] by web51106.mail.yahoo.com via HTTP; Fri, 17 Mar 2006 12:30:45 PST Date: Fri, 17 Mar 2006 12:30:45 -0800 (PST) From: Dino Vliet To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: biord and sbwait state of postgresql process X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 17 Mar 2006 20:30:51 -0000 Hi folks, I'm running a application where I create multiple (300+) textfiles out of a postgresql database. The first 160 loops go perfectly but the suddenly the process of the app gets the state biord at certain point in the procedure. Then the WCPU column in the top command goes almost to 0% and also the CPU utilization drops to a few %. Normally both these values were showing values in the 80 and 90 range. The process stays here a few minutes (always at a certain point in the procedure) and runs very slowly but after all recovers. Then everything goes back to normal, and the process gets its state RUN again. The WCPU increases again to it's old values as does the CPU utilization but then my app goes back in another loop and starts degrading again. After I have cancelled the process, the postgres process still continues but now with a sbwait state. What does this mean? So, what is happening here? How can the performance degrade like that? And why always at the same step in the algorithm? Hope someone can help me out. Ooh yeah, I did some tweaks: sysctl -w kern.ipc.shmmax=402653184 sysctl -w kern.ipc.shmall=16384 I have an amd64 3000+ system with 1GB ram and a SATA harddisk running freebsd 6.0 release-p5. Thanks in advanced Dino __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com