Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 19 Mar 2007 15:35:58 +0100 (CET)
From:      Oliver Fromme <olli@lurza.secnetix.de>
To:        freebsd-database@FreeBSD.ORG, freebsd-amd64@FreeBSD.ORG, Axel.Rau@chaos1.de
Subject:   Re: New Opteron box, dedicated to PostgreSQL
Message-ID:  <200703191435.l2JEZwjn036991@lurza.secnetix.de>
In-Reply-To: <1FDE5616-AF00-416F-B8E8-1D6A584B1126@chaos1.de>

next in thread | previous in thread | raw e-mail | index | archive | help
Axel Rau wrote:
 > Oliver Fromme wrote:
 > 
 > > Be sure to disable background fsck via /etc/rc.conf.  I've
 > > seen it breaking file systems under certain circumstances.
 > 
 > Good to know. What about softupdates?

It makes a bit of a difference, but not a big one.  Note
that you should enable fsync in the PostgreSQL config
anyway, which defeats the purpose of softupdates somewhat.

If you disable fsync (and you know what you're doing),
using softupdates will probably improve i/o performance
significantly, but I haven't tried that.  Note that you
might lose data if you setup your DB server that way.

Best regards
   Oliver

PS:  Please respect the Reply-To header.  I don't need
to receive a separate copy of the mail; I'm reading the
list.

-- 
Oliver Fromme, secnetix GmbH & Co. KG, Marktplatz 29, 85567 Grafing b. M.
Handelsregister: Registergericht Muenchen, HRA 74606,  Geschäftsfuehrung:
secnetix Verwaltungsgesellsch. mbH, Handelsregister: Registergericht Mün-
chen, HRB 125758,  Geschäftsführer: Maik Bachmann, Olaf Erb, Ralf Gebhart

FreeBSD-Dienstleistungen, -Produkte und mehr:  http://www.secnetix.de/bsd

"If you think C++ is not overly complicated, just what is a protected
abstract virtual base pure virtual private destructor, and when was the
last time you needed one?"
        -- Tom Cargil, C++ Journal



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200703191435.l2JEZwjn036991>