Vig, Sandor (G/FI-2) wrote:

385 transaction/sec?

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.


Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to