Company
Date Published
Author
Eric Hanson, Xiening Dai, Huzaifa Abbasi
Word count
2081
Language
English
Hacker News points
None

Summary

The SingleStore Universal Storage is a single table type that supports both analytical and transactional workloads. It uses a columnstore format, enhanced for seekability. The new release of SingleStoreDB (8.0) introduces significant improvements in seeking into JSON and string data, with orders-of-magnitude performance gains. Fast seeks enable faster updates by avoiding the need to scan entire segments of data. Universal Storage tables are organized differently in 8.0 to enable fast row lookups for JSON data, using a new SingleStore-encoded Parquet (S2EP) data format. This simplifies designs and reduces hardware requirements, while maintaining excellent performance across both operational and analytical workloads. The improvements also include faster update and delete performance for changes affecting small percentages of rows, with significant speedups in TPC-C results illustrating these gains.