Hi PG Gurus,
I'm (a newbie db admin) planning to start db performance tune up from the scratch. This will start from server side parameters tune up, and Postgres configuration fine tune etc. Postgres 9.2 on Ubuntu and it's Hot standby cluster too. So there might be some synchronization tune up too. WAL segments, Archiving, WAL Keep, etc.
Version string PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
And now I need to have a bench mark of the current performance state of the database cluster.
What is the best approach for this ?
What are the triggering point of performance ?
Please recommend good GUI tools for this ?
Thanks a lot for your time !