Postgres does have partitioned tables, although the implementation is different from MySQL's. Upsert stands, though. I don't disagree there's tradeoffs - I men

Postgres does have partitioned tables, although the implementation is different from MySQL's. Upsert stands, though. I don't disagree there's tradeoffs - I mentioned replication, for example, but it seems to me that MySQL is lacking a lot of features that other DBMS's provide and except for a few use cases, the fewer features unique (or better implemented) in MySQL doesn't make up for it. Honestly I prefer SQL Server by leaps-and-bounds over the four I've used enough to be very familiar with - MySQL, MS SQL, Oracle, and Postgres - but I think Postgres has much more to offer to most users for most use cases than MySQL.