Get the latest tech news
Pg_analytics is now PostgreSQL Licensed
DuckDB-powered analytics for Postgres. Contribute to paradedb/pg_analytics development by creating an account on GitHub.
With pg_analytics installed, Postgres can query foreign object stores like AWS S3 and table formats like Iceberg or Delta Lake. Lack of support for most object stores and table formats Too slow over large datasets to be a viable analytical engine The following example uses pg_analytics to query an example dataset of 3 million NYC taxi trips from January 2024, hosted in a public us-east-1 S3 bucket provided by ParadeDB.
Or read this on Hacker News