On Mon, Jun 03, 2024 at 01:12:05PM -0700, Darrick J. Wong wrote: > This patchset adds a different computation for AG count and log size > that is based entirely on a desired level of concurrency. If we detect > storage that is non-rotational (or the sysadmin provides a CLI option), > then we will try to match the AG count to the CPU count to minimize AGF > contention and make the log large enough to minimize grant head > contention. Do you have any performance numbers for this? Because SSDs still have a limited number of write streams, and doing more parallel writes just increases the work that the 'blender' has to do for them. Typical number of internal write streams for not crazy expensive SSDs would be at most 8.
