Configuration tunning advisor

[michelmilezzi]

Hi folks,

I've been using Temboard recently and it's really a great tool. However, It would be interesting if it had an advisor... A long time ago I made one in Java, based on the rules defined on Greg Smith's book "PostgreSQL 9.0 High Performance". You can check it here (although the repository is recent, the tool is quite old, supporting only PostgreSQL from 8.3 to 9.5). Basically, it collects info about the server environment and suggests improvements such as increasing shared_buffers and so on.

Do you have any plans to do a similar feature on Temboard?

[julmon]

Hi,

No plan for the moment for a such feature, but I think this is a good idea and we should think about this. Thanks for the idea, I'm keeping this issue open for a while.

[michelmilezzi]

What about something like the AWS Redshift Advisor? It's a simple, nonintrusive, advisor for Redshift.

We could put it within Configuration, showing a small warning. E.g.: Recommended shared_buffers: 512MB.

If the user accepts the advice we could do something like:

--Changes suggested parameter
ALTER SYSTEM SET shared_buffers = '512MB';
SELECT pg_reload_conf();

--Checks if anything left pending
SELECT bool_or(pending_restart) FROM pg_settings;

Please let me know if I can contribute to something.