* Waldo Nell (pwn...@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

Attachment: signature.asc
Description: Digital signature

Reply via email to