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.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of PostgreSQL

PostgreSQL

Photo of Pg_analytics

Pg_analytics

Related news:

News photo

Timescale expands open source vector database capabilities for PostgreSQL

News photo

Bulk optimization of queries in Postgres

News photo

Clock's ticking on PostgreSQL 12, but not everyone is ready to say goodbye