3

In postgresql you have a wealth of optimizations at hand to configure it for your performance needs. The settings for memory usage are still easy enough, but with other options like the cost factors for CPU and IO which are used for the query optimizer are quite a mystery for me. I wonder if there is a program available which would do lets say a benchmark of your hardware (CPU speed, memory performance, harddisk speed), analyze your database and come up with the optimal configuration for this specific environment?

EDIT:

Let me clarify this, I know how to tune my database with indexes and the basic memory settings. I also could find out which settings are to be tweaked to get better performance, but: I don't have the time, so I want to have a tool which finds this out for me.

Improve this question

3 Answers 3

Reset to default
3

Start here.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

2

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

Improve this answer

Comments

0

Understanding indexes is the where most people should start when trying to improve any databases performance.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.