Re: FreeBSD Softupdates??

-- Start of PGP signed section.
> On Tue, Sep 26, 2000 at 03:20:31AM -0700, Alfred Perlstein wrote:
> > It can cause problems because softupdates makes meta data changes
> > (in this case file creation/removal) asyncronously, the same actually
> > happens with most other logging filesystems that don't support
> > transactions.
>
> I've been running FreeBSD 4.1 with soft updates on my development box
> for a while now without any problems at all. Although it's not
> production so there's not a lot of load on PgSQL.
>
> I don't know if it hurts or hampers performance.

Good question.  I can see soft updates improving performance because it
flushes meta-data writes all at once, rather than each time a file is
created/destroyed.  I don't see any downside for PostgreSQL.  The
default fsync() will still work, or at least it should.  This is not the
same as mounting a volume as async.

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