From owner-freebsd-hackers Fri Apr 6 11:29: 5 2001 Delivered-To: freebsd-hackers@freebsd.org Received: from babel.spoiled.org (babel.spoiled.org [212.84.234.227]) by hub.freebsd.org (Postfix) with SMTP id 69BE337B43F for ; Fri, 6 Apr 2001 11:29:00 -0700 (PDT) (envelope-from list-freebsd.hackers@spoiled.org) Received: (qmail 20701 invoked by uid 8); 6 Apr 2001 18:28:52 -0000 From: thomas graichen Reply-To: thomas graichen X-Newsgroups: spoiled.freebsd.hackers Subject: Re: ffsfsn Date: Fri, 6 Apr 2001 20:03:21 +0200 Organization: spoiled dot org Lines: 24 Distribution: local Message-ID: References: <20010406161837.A6182@netserv1.chg.ru> <20010406095621.S17723@fw.wintelcom.net> Reply-To: thomas graichen X-Complaints-To: newsmaster@spoiled.org User-Agent: tin/1.4.4-20000803 ("Vet for the Insane") (UNIX) (Linux/2.4.3-XFS (i586)) To: hackers@FreeBSD.org Sender: owner-freebsd-hackers@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Alfred Perlstein wrote: > * 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. might be worth waiting for the soon to be available postgresql 7.1 which has write ahead logging and can thus run quite safe without fsync (in 7.0 running without fsync might be a bit unsafe in case of a crash i think) t -- thomas graichen ... perfection is reached, not when there is no longer anything to add, but when there is no longer anything to take away. --- antoine de saint-exupery To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-hackers" in the body of the message