Postgres seriously needs a columnstore backed table instead of just a rowstore.
MSSQL has this and it is magic.
SingleStore has it, and it is wonderful.
I'm willing to give a bounty of $1000 to whoever adds that into main postgres tree.
Snowflake is great as a warehouse. it's latency is shit when it comes to fast lookups and aggregates. If you can tolerate >1s api calls, that is fine. It takes forever to insert a few rows in a large table.
If you want a proper live DB, snowflake is a rich man's poor database.
You can also connect other stores using the foreign data wrappers, like parquet files stored on an object store, duckdb, clickhouse… though the joins aren’t optimised as PostgreSQL would do full scan on the external table when joining.
MSSQL has this and it is magic. SingleStore has it, and it is wonderful.
I'm willing to give a bounty of $1000 to whoever adds that into main postgres tree.
Snowflake is great as a warehouse. it's latency is shit when it comes to fast lookups and aggregates. If you can tolerate >1s api calls, that is fine. It takes forever to insert a few rows in a large table.
If you want a proper live DB, snowflake is a rich man's poor database.