How to optimize PostgreSQL configuration? (Is there a tool available?)

Question

In postgresql, you have many optimizations to customize it for your performance needs. The settings for using memory are still quite simple, but with other parameters, such as cost factors for the CPU and IO, which are used for the query optimizer, it's a mystery to me. I wonder if there is a program that will allow you to scan your equipment (processor speed, memory performance, hard drive speed), analyze your database and develop the optimal configuration for this particular environment

EDIT:

Let me clarify this, I know how to tune my database using indexes and basic memory settings. I could also find out which settings should be improved to improve performance , but . I don’t have the time, so I want to have a tool that will find this for me.

Answer 1

Start here .

Answer 2

Not what I know, but the next best thing is the presentation of GUCs: The Three Hour Tour . You can download a PDF that gives recommended values ​​for the settings depending on your system resources.

Answer 3

- , .