From owner-freebsd-hackers Fri Apr 6 9:56:27 2001 Delivered-To: freebsd-hackers@freebsd.org Received: from fw.wintelcom.net (ns1.wintelcom.net [209.1.153.20]) by hub.freebsd.org (Postfix) with ESMTP id 880EF37B496 for ; Fri, 6 Apr 2001 09:56:25 -0700 (PDT) (envelope-from bright@fw.wintelcom.net) Received: (from bright@localhost) by fw.wintelcom.net (8.10.0/8.10.0) id f36GuL601278; Fri, 6 Apr 2001 09:56:21 -0700 (PDT) Date: Fri, 6 Apr 2001 09:56:21 -0700 From: Alfred Perlstein To: Dmitry Sivachenko Cc: hackers@FreeBSD.ORG Subject: Re: ffsfsn Message-ID: <20010406095621.S17723@fw.wintelcom.net> References: <20010406161837.A6182@netserv1.chg.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20010406161837.A6182@netserv1.chg.ru>; from dima@Chg.RU on Fri, Apr 06, 2001 at 04:18:37PM +0400 X-all-your-base: are belong to us. Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG * Dmitry Sivachenko [010406 05:18] wrote: > Hello! > > What does 'ffsfsn' state (shown in top(1) output) mean? > I am inserting records in Postgres, and the process is going very slowly > probably due to postgres is in this state... Looks like part of the file being fsync'd. Did you read the docs that come with Postgresql? There's an option you need to use to disable calls to fsync() for each operation that ought to speed things up for you. -- -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org] Represent yourself, show up at BABUG http://www.babug.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message