pg_analytics: Transforming Postgres into a Fast OLAP Database

An extension called pg_analytics is introduced to accelerate the native analytical performance of any Postgres database. With pg_analytics installed, Postgres becomes 8x faster than Elasticsearch and nearly ties ClickHouse on analytical benchmarks. It eliminates the need to extract, transform, and load data into another system for analytics.