On the Windows platform, where sysbench and test_fsync will not be available, an INSERT test is really the only good option for testing the commit rate. Note that the PostgreSQL wal_sync_method needs to be set properly for this test to give valid results. Like most platforms, the Windows defaults will include unsafe write-back cache behavior.
Windows commit rate
Get PostgreSQL 10 High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
