* Waldo Nell (pwnell@telkomsa.net) wrote:
> The fsync = off was because the production system runs on a uber expensive SAN system with multipathing over Fibre
Channel,it is on UPS and backup generators in a secure datacenter, and we have daily backups we can fall back to.
So, two points: #1- the uber-expensive SAN should make twiddling fsync
have much less of an effect on performance than in a non-SAN/non-BBWC
environment, so you might validate that you really need it off. #2- the
SAN, FC, UPS, etc will be of no help if the OS or PG crash. Seems
pretty harsh to resort back to a daily backup in the event the OS reboots
due to some wacky NMI, or the ASR going haywire..
Thanks,
Stephen