A comprehensive benchmark comparing PostgreSQL storage options using 144 million audit trail records. Row storage (heap) consumed 72GB but offered lightning-fast indexed queries (0.038ms). Columnar storage via Citus extension achieved 10x compression to 6.7GB, ideal for analytical workloads. CSV format required 85GB while Parquet files compressed to 5.5GB. Each storage type serves different purposes: row storage excels at OLTP operations, columnar storage optimizes analytical queries and reduces I/O, while Parquet provides excellent compression for data archiving and exchange.
Table of contents
Storing and archiving data efficientlySample data: Oracle audit logsConclusion and comparisonSort: