Date: Mon, 21 Jul 2003 05:06:47 -0700 (PDT) From: Jason Stone <freebsd-performance@dfmm.org> To: <freebsd-performance@freebsd.org>, <freebsd-database@freebsd.org> Subject: Re: Tuning for PostGreSQL Database Message-ID: <20030721043501.F14379-100000@walter> In-Reply-To: <Pine.BSF.4.05.10307191344080.16986-100000@misery.sdf.com>
next in thread | previous in thread | raw e-mail | index | archive | help
-----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-----
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030721043501.F14379-100000>