Universal Storage, Part 6: Column Group

The text discusses Universal Storage in SingleStoreDB, a single table type that supports both analytical and transactional workloads. It stores data in columnar format, optimized for seekability. The latest version of SingleStoreDB introduces a new feature called Column Group, which can be used to significantly improve transactional workload performance on wide tables. Column Group creates an on-disk, row-oriented representation of the table data living side-by-side to the columns blobs, and combines it with columnstore to deliver an optimal execution plan. The text also provides examples of how to define a Column Group when creating or adding it to an existing table, as well as scenarios where Column Group can improve query performance. Benchmarks show that Column Group increases transaction throughput by 6x-8x and improves the TPC-C benchmark results by 20-30%.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.