If you’re looking for a mysql/maria drop-in replacement, then you may also want to look at tidb
postgres can do it, but it’s kind of presented as lego blocks for a HA cluster and often requires making your own tooling if you want sophisticated features like placement index instances and rebalancing
query optimization and the similar structure to SQL server with schemas pulls me towards postgres, got another system using SQL server with upwards of millions of records and need it to be fast and reliable
If you’re looking for a mysql/maria drop-in replacement, then you may also want to look at tidb
postgres can do it, but it’s kind of presented as lego blocks for a HA cluster and often requires making your own tooling if you want sophisticated features like placement index instances and rebalancing
query optimization and the similar structure to SQL server with schemas pulls me towards postgres, got another system using SQL server with upwards of millions of records and need it to be fast and reliable