Tuning for PostGreSQL Database

Mikko Työläjärvi mbsd at pacbell.net
Tue Jul 22 09:31:58 PDT 2003


On Tue, 22 Jul 2003, Dan Langille wrote:

> On 21 Jul 2003 at 20:35, Jason Stone wrote:
>
> > I feel like this is an extremely important point.  If softupdates changes
> > the semantics of sync(2)/fsync(2), then it absolutely has to be off for a
> > postgresql server because postgresql counts on fsync in order to make its
> > durability guarantees.
>
> If this means all FreeBSD-PostgreSQL users need to change their
> setup, we need to do something ASAP.  I'd first recommend getting the
> confirmation from the PostgreSQL team, then adjusting the PostgreSQL
> documenation and the FreeBSD port.
>
> Does anyone feel this is urgent enough that they'll do something
> about it?

I think you can relax.  Check the mailing lists, or google a bit and
you'll find similar discussions.  For example:

<http://www.ornl.gov/cts/archives/mailing-lists/qmail/2000/02/msg00703.html>

In short: fsync() works with soft-updates.  Too many things would
break otherwise.

  $.02,
  /Mikko


More information about the freebsd-performance mailing list