Vig, Sandor (G/FI-2) wrote:
fsync = false
risky but fast.
I think with a dedicated RAID10 for pg_xlog (or possibly a battery backed up ramdisk), and then a good amount of disks in a bulk RAID10 or possibly a good partitioning of the db across multiple raids, you could probably get a good enough tps.
But you're right, fsync=false could certainly give you the performance, though a power outage means potential *real* corruption. Not just missing transactions, but duplicated rows, all sorts of ugliness.
Description: OpenPGP digital signature