How to optimize Postgresql for high loads?

Question

PostgreSQL

Colleagues.
I would like to get advice on optimizing postgresql 9.2 for high loads.
There is VMWare VM 24vCPU\128GB vRAM\1Tb vHDD. Debian x64 installed. About 25k requests come to the server and the LA server is filled with 10-70. An almost constant picture is the use of all vCPUs at 100%. In this case, the memory is practically not used.
Base config attached: pastebin.com/mDFCTJW8

Answer 1

First, check if everything is in order with sql queries and indexes in the database.
And for fine-tuning, I recommend postgresql.leopard.in.ua

Answer 2

Well, the very first and simple step is to run pgtune, it will generate a config optimized for your database and server.
And then turn on the log of slow queries and optimize them.

Answer 3

How many connections do you have if the CPU is under 100%
if more than the number of cores on the server, install pgbouncer and work through it.
use pgbadger to detect slow queries, then optimize them.
And the question of disk load remains open, run iostat -x 5, if util% reaches 100%, then write, I will give out a bunch of tips ...