Do you know which of the settings is causing lower TPS ? I suggest to check shared_buffers. If you haven't done it, disabling THP and KSM can resolve performance issues, esp. with large RAM like shared_buffers, at least with older kernels.https://www.postgresql.org/message-id/20170718180152.GE17566%40telsasoft.com
+--------+--------------+----------------+---------------+ | client | Defaults [1] | buffers=2G [2] | buffers=2G | | | | | huge_pages=on | +--------+--------------+----------------+---------------+ | 1 | 348-475 (??) | 529-583 (??) | 155-290 | +--------+--------------+----------------+---------------+ | 4 | 436-452 | 451-452 | 388-403 | +--------+--------------+----------------+---------------+ | 8 | 862-869 | 859-861 | 778-781 | +--------+--------------+----------------+---------------+ | 12 | 1210-1219 | 1220-1225 | 1110-1111 | +--------+--------------+----------------+---------------+
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных