Postgres Just Cracked the Top Fastest Databases for Analytics
1–10 of 126 posts
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#2This is an exciting project. Few highlights:
- Query processor is DuckDB - as long as it translates PG type system to DuckDB typesystem well - it will be very fast.
- Data is stored on S3 in Parquet with Delta or Iceberg metadata. This is really cool. You don't need to push analytical data through WAL - only metadata goes into WAL. This mean fast loading at least in theory, and compatibility with all the Delta/Iceberg ecosystem.
- Once they build real-time ingest, you can just push timeseries into this system and you don't need a second system like Clickhouse
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#3They're already working on 0.2
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#4> To enhance query execution speed, we embedded DuckDB as the execution engine for columnstore queries
So is it Postgres or DuckDB that cracked the analytics top ?
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#5Will this work alongside Citus?
If yes, what benefits/disadvantages would it have? I presume at some point of time workloads do need a cluster.
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#6This is an exciting project. Few highlights: - Query processor is DuckDB - as long as it translates PG type system to DuckDB typesystem well - it will be very fast. - Data is stored on S3 in Parquet with Delta or Iceberg metadata. This is really cool. You don't need to push analytical data through WAL - only metadata goes into WAL. This mean fast loading at least in theory, and compatibility with all the Delta/Iceber…
Data is also stored in the local filesystem. How does that compare with vanilla PG and/or S3 based storage?
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#7Looks like they're currently No. 12 on their cited Clickbench benchmark - so not quite in the top 10 three weeks later.
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#8It is not really Postgres, the queries are run on DuckDB. Yeah, DuckDB is really fast for analytical queries.
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#9How is this different from Crunchy Warehouse which is also built on Postgres and DuckDB?
Re: Postgres Just Cracked the Top Fastest Databases for Analytics
#10> To enhance query execution speed, we embedded DuckDB as the execution engine for columnstore queries So is it Postgres or DuckDB that cracked the analytics top ?
both??? I mean seeing their homepage this is clearly their business model no?