4 ms·
Well done. Couple of notes: - YugabyteDB is currently on Postgres 11.2 with plans to keep upgrading. - Cockroach is not pinned to any Postgres version so its
by epberry 5y ago
Well done. Couple of notes:
- YugabyteDB is currently on Postgres 11.2 with plans to keep upgrading.
- Cockroach is not pinned to any Postgres version so its compatibility is reliant on their implementation. Not a bad thing, just different than YB.
- Like you said Timescale is in lockstep with latest Postgres (14 at the time of this comment) https://blog.timescale.com/blog/massive-scale-for-time-series-workloads-introducing-continuous-aggregates-for-distributed-hypertables-in-timescaledb-2-5 https://blog.timescale.com/blog/massive-scale-for-time-serie...
- Materialize is not really focused on scaling because that is not really what it is for, https://materialize.com/blog-roadmap/ https://materialize.com/blog-roadmap/
- I might consider moving Spanner to the Somewhat compatible category. Lack of stored procedures and triggers makes it not a drop in replacement for those moving from Oracle/MS SQL https://cloud.google.com/spanner/docs/reference/postgresql/overview https://cloud.google.com/spanner/docs/reference/postgresql/o...
- For native Postgres scaling strategies, we could call attention to Crunchy Data or Percona
Very nice to lay this out and I pretty much agree with the labels and categories on here. I would be you will get some people reaching out since Postgres compatibility is something these vendors compete on.
- benesch 5y ago- Materialize is not really focused on scaling because that is not really what it is for Horizontal scalability is actually something that Materialize's underlying incremental computation engine (timely/differential dataflow) excels at. We're actively working to expose that tech in Materialize. (As in: many engineers, including me, are working on this full time; happy to answer questions!) It is too bad that you got the wrong impression from that blog post! That blog post is about two years out of date. We're working on an updated roadmap blog post. The tl;dr is that we've since moved from step 3 on the roadmap ("Build a single-node database management system") to step 4 ("Build cloud-native elasticity and replication: Materialize Cloud").
- epberry 5y agoOk that is my bad! Sorry I was curious as to the answer to the question in the * scaling cell in the original blog post and searched 'materialized scaling' and came across that. Regardless I am actually a user of Materialize and quite like it.