Re: New Opteron box, dedicated to PostgreSQL

Am 16.03.2007 um 09:08 schrieb Oliver Fromme:

> 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?
> Instead, you might want want to give PWD's new
gjournal
> code a try (it's in -current, but I think there's a
port
> to RELENG_6, too).
I will have a look at it.

Axel
------------------------------------------------------------
---------
Axel Rau, ☀Frankfurt , Germany                       +49
69 9514 18 0


_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"

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
_______________________________________________
freebsd-databasefreebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-data
base
To unsubscribe, send any mail to
"freebsd-database-unsubscribefreebsd.org"