Re: FreeBSD Softupdates??

* Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> [000926 13:55] wrote:
> > Alfred Perlstein wrote:
> > >
> > [snipped thread]
> >
> > OK, if I'm reading it right, the general concensus seems to be - it'll
> > work, but there is a possibility of data loss in event of system
> > crash....although everything should be OK 99.9% of the time.
> >
> > yep, this is about what I thought.. I wanted to get a feel for
> > practicality though.
> >
> > Thanks for all your input guys, I'll stick to my standard filesystem for
> > now..
>
> No, softupdates to not affect recovery. Standard PostgreSQL flushes all
> stuff to disk on transaction commit, and this it not affected by the
> file system softupdate status.

This is only true if the user isn't running postgresql async.

So softupdates should be ok as long as postgresql is issueing
fsyncs, if you're running postgresql in async mode, then it's
probably better not to use softupdates.

Also, since running postgresql in sync mode will basically cause
the negation of most softupdate benifits with the exception of
tempfiles, doesn't postgresql differenciate between system files
and tempfiles?

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."