Hacker News new | ask | show | jobs
by PaulWaldman 703 days ago
How does this compare to the Parquet S3 Foreign Data Wrapper?

https://github.com/pgspider/parquet_s3_fdw

2 comments

We talk about it more in our first post for pg_lakehouse: https://blog.paradedb.com/pages/introducing_lakehouse

This FDW does not support predicate pushdown, so performance is weak. pg_lakehouse is the same performance as DuckDB. In addition, we're supporting table formats like Apache Iceberg, more object stores, and have many other plans to improve analytics in Postgres through pg_lakehouse.

Does the S3 FDW support predicate pushdown?