switched from MySQL to postgres aurora last year for our mobile game backend. honestly didn’t see a huge difference in resource usage - postgres uses a bit more RAM but nothing crazy. the real win was how much better it handled concurrent writes when we’d hit 500+ players online at once.