Recommend postgresql settings for 1C?

Question

linux

I read documentation and various forums - everywhere they write about weak servers with 4GB of RAM, etc...
But progress does not stand still! Now, according to the database, I use a server with eight 2GHz cores and 24GB of RAM. On large requests, postgres slows down while I try to solve the problem - I decided to ask the community for an edited postgresql.conf for a server with a similar configuration.

Answer 1

Here it is briefly and easily written about the optimization of key parameters: Tuning Your PostgreSQL Server .
You can also try using pgtune .

Answer 2

First of all, you need to look at what operations the server "slows down" when performing.
It can be either the wrong code in 1C, or the postgres "optimizer" built a non-optimal query, I focus on my own, unknown to mere mortals, mechanisms.
Track - under what conditions the base slows down (here you clicked this, and here it is).
And then, if you want - write to me, I will advise.

Answer 3

there are a lot of non-optimal requests in the SCP, sawing them will help much more than tuning the database.

Answer 4

See my version for these purposes. It seems to work well for many of my clients: https://github.com/kozhin/pgsql-1c
If you can suggest further optimization, I will only be happy! The only thing is the config for PostgreSQL running on Windows Server 2008 R2.