On Tue, Jan 31, 2006 at 03:19:38PM -0800, Luke Lonergan wrote: > > Well, the only problem with that is if the machine crashes for any > > reason you risk having the database corrupted (or at best losing some > > committed transactions). > > So, do you routinely turn off Linux write caching? If not, then there's no > difference. My thought was about fsync on WAL; if you're doing much writing then a good raid write cache with BBU will improve performance. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
