Re: FreeBSD Softupdates??

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, PostgreSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: FreeBSD Softupdates??
Date: 2000-10-04 17:20:36
Message-ID: 20001004122036.A25985@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The consensu from the FreeBSD -STABLE lists are that SOFTUPDATES helps
ANY UFS FileSystem, and makes it MORE robust because of the logging
and the way FSCK works.

I've turned SOFTUPDATES on all my FS's on 4.1.1-STABLE.

Larry

* The Hermit Hacker <scrappy(at)hub(dot)org> [000926 10:32]:
>
> I've been runing since softupdates became mainstream, on a relatively
> heavily used production server ... I can't answer about performance
> gains/loss, but from what I know of softupdates, it should be neglible for
> a database system ... but, I haven't been 'shot in the foot' yet for any
> of our database ...
>
>
> On Tue, 26 Sep 2000, Neil Conway wrote:
>
> > 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.
> >
> > HTH,
> >
> > Neil
> >
> > --
> > Neil Conway <neilconway(at)home(dot)com>
> > Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
> > Encrypted mail welcomed
> >
> > I am not interested in the past. I am interested in the future for
> > that is where I intend to spend the rest of my life.
> > -- Charles F. Ketterring
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Biamonte 2000-10-04 18:09:47 -F option, RAM usage, more...
Previous Message Stephan Szabo 2000-10-04 17:04:27 Re: Checking number of entries