On 12/10/15 2:58 PM, Tory M Blue wrote:
> This is a slony slave node, so I'm not too worried about this particular
> host losing it's data, thus fsync is off,
The Amazon RDS team actually benchmarked fsync=off vs sync commit off
and discovered that you get better performance turning sync commit off
and leaving fsync alone in some cases. In other cases the difference
isn't enough to be worth it.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com