Your checkpointing is writing ~40k pages to store using 25 seconds.
Assuming default 4Kb pages this means writing about 160Mb in 25 seconds, or
less than 7Mb/sec. On an SSD. Which seems slow.
But... Your SSD volumes are really small, so perhaps you are partitioning a
single large SSD device into
1. We have DirectIO disabled : does enabling it impact the performance
if enabled?
It should increase performance, but its always worth to do some
benchmarks before using such features in production.
2. When we disabled throttling, we saw 5x better performance. Struggling
load test completed
Hey thanks for replying. we haven't configured the storage path so by
default it should be in the work directory. work, wal, walarchive all three
are SSDs. I have the following queries.
1. We have DirectIO disabled : does enabling it impact the performance if
enabled?
2. When we disabled
Hi, From my perspective this looks like your physical storage is not
fast enough to handle incoming writes. markDirty speed is 2x times
faster that checkpointWrite even in the presence of throttling. You've
mentioned that ignite work folder stored on SSD, but what about PDS
folder