I’d say Postgres is generally very fast for the average workload in analysis and the external extensibility is truly great, being able to use different index types for example. Postgres also has good support for modern SQL and many datatypes. With those 2 aspects the ecosystem is rather large thus lots of ways to extend Postgres. MySQL and MariaDB are now starting to expand their horizons in this regard.