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>