CODEWITHSUNDEEP
databaseoptimizationpostgresql
Mauli
Mauli

Reputation: 17203

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

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.

Upvotes: 3

Views: 3364

Answers (3)

Milen A. Radev
Milen A. Radev

Reputation: 62573

Start here.

Upvotes: 3

Liam
Liam

Reputation: 20950

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

Upvotes: 0

Grey Panther
Grey Panther

Reputation: 13118

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.

Upvotes: 2

Related Questions