4 ms·
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 w
by nojvek 3y ago
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.
- CSSer 3y agoKnow anybody who could do it in a weekend? That’s about what you’re paying for.
- dkatz23238 3y agoParade DB are working on this problem: https://github.com/paradedb/paradedb/tree/dev/pg_analytics https://github.com/paradedb/paradedb/tree/dev/pg_analytics
- speedgoose 3y agoColumnar store PostgreSQL extension exists, here are two but I think I’m missing at least another one: https://github.com/citusdata/cstore_fdw https://github.com/citusdata/cstore_fdw https://github.com/hydradatabase/hydra https://github.com/hydradatabase/hydra 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.
- Loic 3y agoFor time series, you have the TimescaleDB extension. https://www.timescale.com/ https://www.timescale.com/
- ddorian43 3y ago> I'm willing to give a bounty of $1000 to whoever adds that into main postgres tree. This is the most disrespectful thing I've read on HN.
- nojvek 3y agoI'm sorry my intent came off in the wrong way. I am not super wealthy.