From owner-freebsd-questions@FreeBSD.ORG  Fri Mar 17 20:39:15 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 AB39316A420
	for <freebsd-questions@freebsd.org>;
	Fri, 17 Mar 2006 20:39:15 +0000 (UTC)
	(envelope-from kris@obsecurity.org)
Received: from elvis.mu.org (elvis.mu.org [192.203.228.196])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0EC2243D48
	for <freebsd-questions@freebsd.org>;
	Fri, 17 Mar 2006 20:39:15 +0000 (GMT)
	(envelope-from kris@obsecurity.org)
Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196])
	by elvis.mu.org (Postfix) with ESMTP id EBB571A4EE0;
	Fri, 17 Mar 2006 12:39:14 -0800 (PST)
Received: by obsecurity.dyndns.org (Postfix, from userid 1000)
	id 473DD51406; Fri, 17 Mar 2006 15:39:14 -0500 (EST)
Date: Fri, 17 Mar 2006 15:39:14 -0500
From: Kris Kennaway <kris@obsecurity.org>
To: Dino Vliet <dino_vliet@yahoo.com>
Message-ID: <20060317203913.GB16542@xor.obsecurity.org>
References: <20060317203045.45542.qmail@web51106.mail.yahoo.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="MW5yreqqjyrRcusr"
Content-Disposition: inline
In-Reply-To: <20060317203045.45542.qmail@web51106.mail.yahoo.com>
User-Agent: Mutt/1.4.2.1i
Cc: freebsd-questions@freebsd.org
Subject: Re: 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 <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 17 Mar 2006 20:39:15 -0000


--MW5yreqqjyrRcusr
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Mar 17, 2006 at 12:30:45PM -0800, Dino Vliet wrote:
> Hi folks,
>=20
> 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.

That means it's reading something from disk.

> After I have cancelled the process, the postgres
> process still continues but now with a sbwait state.=20

That means it's waiting for work.

Kris
--MW5yreqqjyrRcusr
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (FreeBSD)

iD8DBQFEGx5xWry0BWjoQKURAk74AJ9vzGcABOJmQX+RUzvT/2VCUYsC2ACg9PHJ
BSl3u2CPwRfTDbWoge4BjdA=
=esXr
-----END PGP SIGNATURE-----

--MW5yreqqjyrRcusr--