Tuning for PostGreSQL Database

David Miller small at d.sparks.net
Tue Jul 22 09:06: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.

If softupdates breaks the semantics of sync/fsync it affects a lot more
than postgres, it affects every application that manages data on its
own.  Every other database that doesn't do raw IO would seem to be
affected, for example.

Before we go off half-cocked, can anyone confirm that softupdates actually
does this - reorders/delays sync/fsync - on writes within a file?  I had
the impression it worked on meta data about files (directory structures) 
rather than the data within the file itself.

--- David



More information about the freebsd-performance mailing list