From owner-freebsd-performance@FreeBSD.ORG Mon Jul 21 05:06:49 2003 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5313837B401 for ; Mon, 21 Jul 2003 05:06:49 -0700 (PDT) Received: from dfmm.org (walter.dfmm.org [209.151.233.240]) by mx1.FreeBSD.org (Postfix) with ESMTP id 74CF543FAF for ; Mon, 21 Jul 2003 05:06:48 -0700 (PDT) (envelope-from freebsd-performance@dfmm.org) Received: (qmail 76290 invoked by uid 1000); 21 Jul 2003 12:06:48 -0000 Received: from localhost (sendmail-bs@127.0.0.1) by localhost with SMTP; 21 Jul 2003 12:06:48 -0000 Date: Mon, 21 Jul 2003 05:06:47 -0700 (PDT) From: Jason Stone X-X-Sender: To: , In-Reply-To: Message-ID: <20030721043501.F14379-100000@walter> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: Re: Tuning for PostGreSQL Database X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 21 Jul 2003 12:06:49 -0000 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Sat, 19 Jul 2003, Tom Samplonius wrote: > Softupdates on, async off. Softupdates is just a better async. postgresql fsync's all its files before returning from a commit in order to ensure durability, right? Does softupdates interfere with the functioning of sync(2)/fsync(2)? On Sun, 20 Jul 2003, Sean Chittenden wrote: > > I would recommend 4.8 over 5.1. Especially if you intend this to be > > a production server. 5.1 is not ready for public consumption. > > Public consumption, yes. Production consumption, no. I recently decided to take up the issue of migrating towards 5.1 at my company. The way I dealt with it was to publish all of my services to 5.1 boxes and run regression tests. For me, 5.1 provided adequate performance, and since 5.1 is on the branch where all new dev work is going on and 4.x is going to be end-of-lifed in the not-too-distant future, I decided to go with 5.1. Personally, I would only go with 4.8 if testing showed 5.1 to be inadequate for your particular situation with your particular apps, hardware, load, etc. But you can only tell that by testing. -Jason -------------------------------------------------------------------------- Freud himself was a bit of a cold fish, and one cannot avoid the suspicion that he was insufficiently fondled when he was an infant. -- Ashley Montagu -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) Comment: See https://private.idealab.com/public/jason/jason.gpg iD8DBQE/G9dYswXMWWtptckRAkrNAKD6NjeQW9kFS8J//fxec1qWVUVqaACgzTmM zeAG240i4H11u/yM/FI0E1w= =wFfZ -----END PGP SIGNATURE-----