filmov
tv
pg_duckdb: Postgres analytics just got faster with DuckDB
Показать описание
Postgres analytics 10x faster with just an extension?! 🤯
In August, we announced pg_duckdb, a PostgreSQL extension that integrates DuckDB's analytics engine directly into Postgres. It's open-source and represents a joint partnership between Hydra and MotherDuck.
Two months later, we are happy to announce its first release and highlight many features, including the ability to read and write over object storage with Parquet and CSV, as well as Apache Iceberg (currently read-only), and the capability to query from MotherDuck without leaving Postgres.
Note :
We ingested the TPC-DS datasets into PostgreSQL without indexes for two main reasons:
2. While indexes are common in real-world PostgreSQL scenarios, optimizing them for specific analytic queries can be complicated and bring extra overhead. Considering this, we believe there is value in looking at the performance of queries without any indexes.
📓 Resources
➡️ Follow Us
0:00 Intro
1:33 Postgres extension ecosystem
2:35 Getting started with pg_duckdb
6:20 Query data lake / lakehouse
8:54 Scaling to the cloud with MotherDuck
13:37 Moving forward
In August, we announced pg_duckdb, a PostgreSQL extension that integrates DuckDB's analytics engine directly into Postgres. It's open-source and represents a joint partnership between Hydra and MotherDuck.
Two months later, we are happy to announce its first release and highlight many features, including the ability to read and write over object storage with Parquet and CSV, as well as Apache Iceberg (currently read-only), and the capability to query from MotherDuck without leaving Postgres.
Note :
We ingested the TPC-DS datasets into PostgreSQL without indexes for two main reasons:
2. While indexes are common in real-world PostgreSQL scenarios, optimizing them for specific analytic queries can be complicated and bring extra overhead. Considering this, we believe there is value in looking at the performance of queries without any indexes.
📓 Resources
➡️ Follow Us
0:00 Intro
1:33 Postgres extension ecosystem
2:35 Getting started with pg_duckdb
6:20 Query data lake / lakehouse
8:54 Scaling to the cloud with MotherDuck
13:37 Moving forward
0:14:19
pg_duckdb: Postgres analytics just got faster with DuckDB
0:04:19
Using DuckDB to analyze the data quality of Apache Parquet files
0:02:37
PostgreSQL in 100 Seconds
0:24:31
DuckDB and SQL - for Data Analysis and Processing
0:23:07
Data Engineering with DuckDb Tutorial | PySpark | SQL | Postgres | Python | ETL Data processing
0:19:02
In-Process Analytical Data Management with DuckDB - posit::conf(2023)
0:25:53
DuckDB Tutorial - DuckDB course for beginners
0:08:42
15 futuristic databases you’ve never heard of
0:06:39
Querying DuckDB with PRQL
0:16:07
8 PostgreSQL Extensions You Need To Know About
1:08:05
Practical Applications for DuckDB (with Simon Aubury & Ned Letcher)
0:14:59
Splicing Elephant & Duck DNA | Scaling Postgres 330
0:03:22
Vector databases are so hot right now. WTF are they?
0:24:39
DuckDB - Overview by Hannes Mühleisen
0:16:19
DuckDB An Embeddable Analytical Database
1:20:33
Implementing Hardware-Friendly Databases (with DuckDB co-creator, Hannes Mühleisen)
0:16:19
DuckDB An Embeddable Analytical Database
0:24:41
Data-intensive PostgreSQL: Three ways to scale | POSETTE 2024
0:14:20
77 Times Faster In Postgres 17 | Scaling Postgres 337
0:55:38
DuckDB and PostGIS: Your geospatial super duo
0:05:16
An introduction to Apache Parquet
0:33:01
DuckDB – Overview and latest developments (DuckCon #5, Seattle, 2024)
0:09:11
Own your business intelligence reports with evidence.dev
0:16:49
Unleashing the Power of DuckDB for Interactive SQL Notebooks
Комментарии