There are other relational databases like MemSQL or Clickhouse that use distributed column-oriented architectures that are much better at large scale analytics

There are other relational databases like MemSQL or Clickhouse that use distributed column-oriented architectures that are much better at large scale analytics and aggregations. Postgres is getting pluggable storage engines in the next version (and already has foreign data wrappers) so that can at least lead to a better storage design.