tembo-io / pg_timeseries

Simple and focused time-series tables for PostgreSQL, from Tembo
PostgreSQL License
324 stars 5 forks source link

Question: Is pg_timeseries compatible with Citus? #26

Open prateek-khatri opened 4 months ago

prateek-khatri commented 4 months ago

I am looking to utilize this extension for timeseries data, however, I have a very high write throughput requirement. I want to distribute the load to multiple nodes. Before I dive in and start configuring, I wanted to see if anyone already has tried it this extension with Citus and does it work?

Thank you!

jasonmp85 commented 4 weeks ago

I don't know of any compatibility issues with Citus, but I could also see usage patterns mattering a lot in terms of how shards are layered with partitioned tables.

Can you give a bit more details about your throughput requirements/how you're sharding your data?