From owner-freebsd-questions@FreeBSD.ORG Thu Mar 30 19:41:57 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 B4B7816A400 for ; Thu, 30 Mar 2006 19:41:57 +0000 (UTC) (envelope-from usleepless@gmail.com) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.203]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5D6DC43D69 for ; Thu, 30 Mar 2006 19:41:51 +0000 (GMT) (envelope-from usleepless@gmail.com) Received: by zproxy.gmail.com with SMTP id l8so547401nzf for ; Thu, 30 Mar 2006 11:41:51 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=RFDs4/hn/weubsjavI38LrFgTi+KLdCZ/cJLosr+XRbqqxPvAia8auSjZHSa+QqIgA0aCywNRRK+68tYpTgmoQJk6XqesBsWJZZu2LacyFvy+21kBPPBMvOC3AQ/aZjC6XaO+a1bDZ2Vpm4rQS4rYQ+dnhD70lyrxr1B4bMKktU= Received: by 10.36.20.16 with SMTP id 16mr62722nzt; Thu, 30 Mar 2006 11:41:51 -0800 (PST) Received: by 10.36.154.7 with HTTP; Thu, 30 Mar 2006 11:41:51 -0800 (PST) Message-ID: Date: Thu, 30 Mar 2006 21:41:51 +0200 From: usleepless@gmail.com To: Miguel In-Reply-To: <442BF0BB.8010504@123.com.sv> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> <442BF0BB.8010504@123.com.sv> Cc: freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 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: Thu, 30 Mar 2006 19:41:57 -0000 Miguel, > 3.0G i looked at your top-screenshot, i have the impression you could dedicate far more memory to postgresql. maybe it would be usefull to post your postgresql.conf ( this is in fact a postgresql question, but i don't care ). you might want to turn fsync off, my limited knowledge about this switch tells me it is only important in case of powerfailures. you want to give postgresql as much memory as it needs, cause else it will underperform heavily. this might be one of the reasons it is not catching on as quick as i would like. postgresql is the best in OSS though. bring on your .conf! regards, usleep