3 ms·

New open-source benchmark for real-time analytics applications

• 6Az4Mj4D 2y ago
  For the lazy people click to see results https://rtabench.com/ https://rtabench.com/
• giovannibonetti 2y ago
  When it comes to Postgres extensions for columnar storage, I like how Citus [1] handles the more general problem of columnar tables instead of focusing just on "hypertables" which necessarily must have a time column as primary key. [1] https://github.com/citusdata/citus?tab=readme-ov-file#creating-tables-with-columnar-storage https://github.com/citusdata/citus?tab=readme-ov-file#creati...
  • drchaim 2y ago
    I was thinking about giving it a try until I read: “Update, delete, and foreign keys are currently unsupported on columnar tables. “
    • giovannibonetti 2y ago
      This works fine when you have partitioned tables over time, and the current partition is row-oriented, while the historic read-only partitions are columnar.