A bunch of other relevant features of PostgreSQL: - table elimination/join removal (MariaDB supports it but MySQL doesn't) - asynchronous protocol (the new X

A bunch of other relevant features of PostgreSQL: - table elimination/join removal (MariaDB supports it but MySQL doesn't) - asynchronous protocol (the new X Protocol supports it but not the standard protocol) - table functions (for example the generate_series function which is very useful in PostgreSQL) - LISTEN/NOTIFY (a built-in pub-sub mechanism) - WITH (Common Table Expressions) - Window aggregations (very useful for reporting and stats) - Row Level Security (introduced in PostgreSQL 9.5; very useful for multi-tenant applications)