Postgres auto tuning

Question

As we all know postgres performance highly depends on config params. Eg if I have ssd drive or more RAM I need to tell that postgres by changing relevant cfg param

I wonder if there is any tool (for Linux) which can suggest best postgres configuration for current hardware?

Im aware Websites (eg pgtune) where I can enter server spec and those can suggest best config

However each hardware is different (eg I might have better raid / controller or some processes what might consume more ram etc). My wish would be postgres doing self tuning, analysing query execution time available resources etc

Understand there is no such mechanism, so maybe there is some tool / script I can run which can do this job for me (checking eg disk seq. / random disk read, memory available etc) and telling me what to change in config

Must be a conspiracy of the PostgreSQL support providers, but I never heard of such a tool. — Laurenz Albe
– Laurenz Albe, Commented Nov 18, 2019 at 6:53

abby37 · Accepted Answer · 2019-11-18 07:29:34Z

1

There are parameters that you can tweak to get better performance from postgresql.

This article gives good read about that. There are few scripts that can do that. One that is mentioned in postgres wiki is this one.

To get more idea about what more tuning your database needs, you need to log its request and performance, after analysing those logs you can tune more params. For this there is pgbadger log analyzer.

After using database in production, you get more idea regarding what requirements you have and how to approach them rather than making changes just based on os or hardware configuration.

answered Nov 18, 2019 at 7:29

abby37

6476 silver badges21 bronze badges

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

1 Comment

Maciej Over a year ago

Thanks - will check this later today and see what those tools say :)

Collectives™ on Stack Overflow

Postgres auto tuning

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related