Re: FreeBSD Softupdates?? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: FreeBSD Softupdates??
Date
Msg-id 200009262052.QAA22887@candle.pha.pa.us
Whole thread Raw
In response to Re: FreeBSD Softupdates??  (Dale Walker <dale@icr.com.au>)
Responses Re: FreeBSD Softupdates??  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: update inside transaction violates unique constraint?
Next
From: Andrew Sullivan
Date:
Subject: Re: update inside transaction violates unique constraint?