Hi.
I'm having problems with PostgreSQL performance.
My server has good CPU and lots of memory, but just two SATA 7200 hard
drives in software RAID1.
When running pgbench I'm getting 68 TPS with synchronous_commit turned on,
and 3100 TPS with synchronous commit turned off.
Can somebody tell me why there is such big difference? Is it normal to have
it like this?
PS: During run of pgbench with synchronous commit on system is mostly idle,
iowait is 0.12%
--
Best regards,
Sergey