Re: [9.4] Make full_page_writes only settable on server start?

Peter,


> I wonder, is anyone really running in production with full_page_writes
> off? 

We're doing so with clients on Joyent (ZFS).  And also for "ephemeral"
postgres instances -- ones where we've also turned off fsync.

It's also quite reasonable to assume that future filesystems will also
be able to make better torn page guarantees.

So it should remain a setting.  I see no reason why it should be a
SIGHUP setting, though, if there's any code maintenance required to
support it -- frankly, I only change this setting at first system
deployment.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com