From owner-freebsd-database@FreeBSD.ORG Sun Oct 22 17:03:50 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 28B5316A412; Sun, 22 Oct 2006 17:03:50 +0000 (UTC) (envelope-from vdemart1@tin.it) Received: from vsmtp12.tin.it (vsmtp12.tin.it [212.216.176.206]) by mx1.FreeBSD.org (Postfix) with ESMTP id 236C343D64; Sun, 22 Oct 2006 17:03:42 +0000 (GMT) (envelope-from vdemart1@tin.it) Received: from [10.155.100.8] (87.20.229.20) by vsmtp12.tin.it (7.2.072.1) (authenticated as vdemart1@tin.it) id 452629DE0070DAF2; Sun, 22 Oct 2006 19:03:36 +0200 From: vittorio To: freebsd-performance@freebsd.org, freebsd-database@freebsd.org Date: Sun, 22 Oct 2006 19:03:06 +0000 User-Agent: KMail/1.9.4 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200610221903.06526.vdemart1@tin.it> Cc: Subject: Improving performance of postgresql X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 22 Oct 2006 17:03:50 -0000 Under freebsd 6.1 on a pentium 4 with 256 MB I compiled and installed a postgresql (now 8.0.8) server which has been running wonderfully. I tailored the conf files to tune the server with my hardware according to the many suggestions I read in the net which are OS-independent that is that apply to any *nix (or better linux-centric). Now I would like to know if for a postgresql server there are settings more ** freebsd specif ic ** to improve performance. Ciao Vittorio. From owner-freebsd-database@FreeBSD.ORG Mon Oct 23 19:30:34 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BF30816A412 for ; Mon, 23 Oct 2006 19:30:34 +0000 (UTC) (envelope-from freebsd-database@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3472543D49 for ; Mon, 23 Oct 2006 19:30:32 +0000 (GMT) (envelope-from freebsd-database@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1Gc5Uo-0000m1-T8 for freebsd-database@freebsd.org; Mon, 23 Oct 2006 21:30:03 +0200 Received: from 89-172-52-23.adsl.net.t-com.hr ([89.172.52.23]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 23 Oct 2006 21:30:02 +0200 Received: from ivoras by 89-172-52-23.adsl.net.t-com.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 23 Oct 2006 21:30:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-database@freebsd.org From: Ivan Voras Date: Mon, 23 Oct 2006 01:13:02 +0200 Lines: 8 Message-ID: References: <200610221903.06526.vdemart1@tin.it> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: 89-172-52-23.adsl.net.t-com.hr User-Agent: Thunderbird 1.5.0.7 (Windows/20060909) In-Reply-To: <200610221903.06526.vdemart1@tin.it> Sender: news Cc: freebsd-performance@freebsd.org Subject: Re: Improving performance of postgresql X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 23 Oct 2006 19:30:34 -0000 vittorio wrote: > Now I would like to know if for a postgresql server there are settings more ** > freebsd specif ic ** to improve performance. You can start from here: http://wiki.freebsd.org/Performance, in particular read the MySQL page but ignore all points regarding threading and threads.