On 20/02/07, Tzahi Fadida <[EMAIL PROTECTED]> wrote:
In PostgreSQL they don't even do the caching (more or less), they let the OS to do it. This is a common question and the claim of the PostgreSQL dev community is that the added benefit of a raw fs will be negligable. I for one believe it because many of them uses oracle also. Not to mention PostgreSQL is more or less compatible in syntax with oracle. I also can tell you that with recent stable versions 8+ and recent kernels you can probably achieve almost raw fs capabilities by using certain file options (which they do). They also use techniques as back writings etc... This thing is very advanced.
Thanks for the clarification.
That (battey-backed RAM) sounds like a good tip. Will keep it around. > Thanks. If you have more specific details to help Google for such a product > I'll appreciate to hear them. Check out these sites, i think these are the real thing: http://www.anandtech.com/tradeshows/showdoc.aspx?i=2431&p=5 http://www.cenatek.com/ However, also remember to periodically back up your stuff to the HD. I trust batteries only so far. :)
Well - if I use it only for transaction logging then hopefully the data there will be useful only for fractions of seconds, wouldn't it? Thanks, --Amos
