a month ago
Currently running a project submitting trades into a clickhouse db and using materialized views for candles.
After 22 hours of usage, the postgres counterpart fills up < 1gb while clickhouse uses > 5gb.
What do people use to alleviate this? Seems like disable logging is an option. Do people run startup scripts to format clickhouse?
2 Replies
a month ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
a month ago
ClickHouse and other columnar datastores are known to use significantly more disk and memory compared to row-based databases like Postgres, especially when materialized views are involved. This is expected behavior and is generally a tradeoff for the performance benefits they provide with analytical workloads. Disabling logging can help reduce storage usage, and some users do run startup scripts to optimize or format their ClickHouse instance, but the high resource usage is typical for this type of database.
Status changed to Awaiting User Response Railway • 29 days ago
22 days ago
This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!
Status changed to Solved Railway • 22 days ago