I think Postgres has more features, MySQL has more scalability. Citus exists for Postgres but seems to have a much smaller community compared to MySQL active active replication or Vitess/Planetscale. I would probably pick Postgres for personal projects, but potentially consider MySQL/Planetscale for something that needs to hold petabytes.