Re: FreeBSD Softupdates??

> 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.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026