PAX: The Cache Performance You're Looking For
Summary
The article explains PostgreSQL's NSM storage and the PAX page-level columnar approach to improve cache efficiency. It compares NSM vs PAX, shows potential cache-line improvements and provides guidance on when PAX is beneficial, along with Parquet relationships and practical trade-offs.