4 ms·
Can tiger data be used just as a simple column store? All I want is effectively what clickhouse does in PG. I have a single table that I need fast counts on an
by tempest_ 8mo ago
Can tiger data be used just as a simple column store?
All I want is effectively what clickhouse does in PG. I have a single table that I need fast counts on and clickhouse can do the counts fast but I have to go through the entire sync/replication to do that.
A quick scan of TimeSeries always seemed like it was really only best setup for that and to use it another way would be a bit of a struggle.
- dzonga 8mo agoin a way -- materialized views -- but Tiger Data is more optimized for TimeSeries data - https://www.tigerdata.com/docs/use-timescale/latest/hypercore/real-time-analytics-in-hypercore https://www.tigerdata.com/docs/use-timescale/latest/hypercor... I do wish too there was an embedded click house like db in Postgres