Running a database on EC2? Your clock could be slowing you down
Why would you run your own Postgres instance on EC2 within AWS? That kind of defeats the purpose of paying for AWS.  Why not use Postgres RDS or Aurora?It makes some sense with Sql Server and Oracle in a few cases because of licensing but hosting your own Postgres instance on AWS is the worse of both worlds -- you're paying more than with a cheaper VPS and you have to do all of the maintenance yourself and not taking advantage of all of things that AWS provides -- point in time restores, easy cross region read replicas, faster disk io (Aurora), etc.