* Waldo Nell (pwnell@xxxxxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature
