Databases7 min read
Database
Alibaba just cut 70% off database index bloat. The trick is in the prefixes.
Secondary indexes often dominate database storage, especially in SaaS and e-commerce. PolarDB-X introduces secondary prefix compression (SPC), a lightweight per-page dictionary scheme that reduces index space by 30% to 70% without heavy CPU overhead. Benchmarks show up to 47% throughput improvement in I/O-bound read workloads.
2020-10-22