Remix.run Logo
tempest_ 4 hours 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 an hour ago | parent [-]

in a way -- materialized views --

but Tiger Data is more optimized for TimeSeries data - https://www.tigerdata.com/docs/use-timescale/latest/hypercor...

I do wish too there was an embedded click house like db in Postgres