Re: Huge Data sets, simple queries

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@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461