Hey!
I currently have one Postgres server running on an ec2 instance 32GB, and 8 cores. My DB is under a heavy load and sometimes queries might get super slow.
I guess it is doing too much and has many access patterns which don't let it optimize correctly.
I wonder if introducing a slave replication (making all reads going to the slave, and writes to the master) will make my setup more performant.
Are there any good metrics to measure before making such decision? I really want to be able to see the improvement in case I decide to go with setting a replication.
Thanks!