pg_analytics (formerly named pg_lakehouse) puts DuckDB inside Postgres. With pg_analytics installed, Postgres can query foreign object stores like AWS S3 and table formats like Iceberg or Delta Lake. Queries are pushed down to DuckDB, a high-performance analytical query engine. By transforming Postgres into a performant search and analytics engine, ParadeDB frees your team from the pain of scaling and syncing Elasticsearch.

Features

  • Advanced data aggregation functions
  • Optimized for performance with large datasets
  • Support for custom metrics and dimensions
  • Real-time analytics processing
  • Integration with PostgreSQL databases

Project Samples

pg_analytics Screenshot 1

Project Activity

See All Activity >