Performance tuning assisted by a GUI application
Hello,
(Please pardon me if this is offtopic and I should send it to another
mailing list instead)
I had a brief discussion on #postgresql and thought that perhaps there
might be a need for a tool that would enable a fine-tuning of PostgreSQL
performance settings by conveniently testing them with a sample SQL
query with the aid of a simple GUI application. To illustrate this, I
created this little proof of concept:
https://gist.github.com/d33tah/d01f3599e55e53d00f68
Screenshot can be found here: https://imgur.com/TguH6Xq
This is by far not even alpha quality here and would need some basic
Python knowledge to set up the connection string. This only supports
modifying cpu_tuple_cost right now, but I guess that you can extrapolate
where this would go.
What do you think? Would anybody be interested in an application like this?
Cheers,
Jacek Wielemborek
On 4/16/15 8:42 AM, Jacek Wielemborek wrote:
I had a brief discussion on #postgresql and thought that perhaps there
might be a need for a tool that would enable a fine-tuning of PostgreSQL
performance settings by conveniently testing them with a sample SQL
query with the aid of a simple GUI application. To illustrate this, I
created this little proof of concept:https://gist.github.com/d33tah/d01f3599e55e53d00f68
Screenshot can be found here: https://imgur.com/TguH6Xq
...
What do you think? Would anybody be interested in an application like this?
Possibly not in hackers, but I think people on -general might be very
interested. Now whether it's a good idea to hand them such a tool... ;)
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers