Date: Tue, 15 Aug 2000 14:46:06 +0700 (NSS) From: Max Khon <fjoe@iclub.nsu.ru> To: Steve Reid <sreid@sea-to-sky.net> Cc: freebsd-isp@FreeBSD.ORG Subject: Re: FreeBSD database server questions Message-ID: <Pine.BSF.4.21.0008151442390.32418-100000@iclub.nsu.ru> In-Reply-To: <20000814181031.B13301@grok.localnet>
next in thread | previous in thread | raw e-mail | index | archive | help
hi, there! On Mon, 14 Aug 2000, Steve Reid wrote: > I will soon be setting up a database (among other things, for now) > server running FreeBSD 4.1-R. This will be doing the usual web-type > transaction processing. > > Any tips? Specifically... > > I'd prefer to run an open-source RDBMS; PostgreSQL and Interbase look > like the contenders (I'm not interested in MySQL). First-hand > experiences? I'll probably end up testing them both but if there's > anything specific I should be watching out for I'd like to know > beforehand. we have found database corruption in PostgreSQL 7.0.2 running under FreeBSD 3.5 (and 4.x) when using secondary keys in our tables. > Also, what about softupdates? As I understand it, softupdates is like > async writes except the writes are re-ordered so as to prevent the disk > from ever being left in a corrupt state. Is it possible for this > delaying and re-ordering to interfere with a RDBMS's ACIDity? Should I > stick with sync writes for the RDBMS space? no, no /fjoe To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0008151442390.32418-100000>