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!