And its not like you switch to Postgres and your indexes are 10x faster.
Postgres does seems to be marginally faster in some edge cases, but with it you have to learn a whole host of weird slash commands, the tooling just isn’t that great, and setup is unbelievably complicated compared to MySql and heavily heavily intertwined with the host os.
The real advantage Postgres had is some cool party tricks (like pivot functions, super handy for prepping data for Ml) but those being non ansi means you are flirting with disaster if they ever change or go away. Backups on MySql are also not a great affair… xtrabackup is marginally ok but requires some intense scripting. (Honestly I question the usefulness of backups anyway, I think slow replicas are probably the was to go).
It’s certainly not bad, but it’s also not like it isn’t without a myriad of rough spots.