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.
John
=:->
