troubleshooting Question

Postgres performance bench mark

Avatar of Shakthi777
Shakthi777Flag for Afghanistan asked on
4 Comments1 Solution720 ViewsLast Modified:
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

Open in new window

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 !
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros