Re: freebsd/softupdates for data dir - Mailing list pgsql-performance

From Vivek Khera
Subject Re: freebsd/softupdates for data dir
Date
Msg-id C5DD26F3-47FD-41B8-A56A-F617B780FA1F@khera.org
Whole thread Raw
In response to Re: freebsd/softupdates for data dir  (Mark Kirkwood <markir@paradise.net.nz>)
Responses Re: freebsd/softupdates for data dir  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-performance
On Apr 3, 2006, at 10:10 PM, Mark Kirkwood wrote:

> I've always left them on, and never had any issues...(even after
> unscheduled power loss - which happened here yesterday). As I
> understand it, the softupdate code reorders *metadata* operations,
> and does not alter data operations - so the effect of fysnc(2) on a
> preexisting file is not changed by softupdates being on or off.

This is also my understanding, and I also leave softupdates on for
the data partition.  Even if it doesn't improve performance, it will
not reduce it, and otherwise does no harm with respect to postgres'
disk usage.


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: bad performance on Solaris 10
Next
From: Dan Harris
Date:
Subject: vacuum full seems to hang on very small table