News for hackers. Stuff that matters.
Re:Features I'd Like in PostgreSQL by EamonnMR on Sunday January 29, 2023 @12:53AM (#34565329)
Big second on horizontal scaling. Amazon Redshift is a great example of what's possible, but it also has enough problems that you can't really use it as a primary application database.
Re:Features I'd Like in PostgreSQL by zX41ZdbW on Sunday January 29, 2023 @05:56PM (#34573668)
Redshift is an OLAP database, much like ClickHouse. For OLAP databases, horizontal scalability is a must - due to generally larger data volumes.

While Postgres is OLTP. For OLTP databases achieving horizontal scalability require a more sophisticated approach to distributed consensus, like in CockroachDB or Spanner.