3 ms·
I would like to keep my data in Postgres (OLTP purposes), but run analytical queries against the same datafiles in Snowflake/DuckDB fashion. The analytics part
by jpalomaki 3y ago
I would like to keep my data in Postgres (OLTP purposes), but run analytical queries against the same datafiles in Snowflake/DuckDB fashion.
The analytics part should scale independently. Often this is only needed occasionally, so scale-to-zero (like Snowflake) would be great.
- derekperkins 3y agoYou have been able to do that with DuckDB for 18 months. https://duckdb.org/2022/09/30/postgres-scanner.html https://duckdb.org/2022/09/30/postgres-scanner.html Clickhouse supports it too https://clickhouse.com/docs/en/sql-reference/table-functions/postgresql https://clickhouse.com/docs/en/sql-reference/table-functions...