Comparing ClickHouse to PostgreSQL and TimescaleDB for time-series data

Re:Comparing ClickHouse to PostgreSQL and TimescaleDB for ti... by ryanbooz on Thursday October 21, 2021 @04:15PM (#28950277)

Great question. Yes, eventually it does, but (at least for now) it wasn't something we could reliably force as part of the query cycle and know everything was in it's "best" state with ClickHouse. To be honest, we didn't provide the final compressed size of either database because of the need to wait.

The code that's currently used by TSBS was submitted by Altinity, a heavy supporter of ClickHouse in the U.S., but TSBS is open source and anyone is welcome to contribute and make the process/test better!

[ Parent | on HN ]

Re:Comparing ClickHouse to PostgreSQL and TimescaleDB for ti... by darthShadow on Thursday October 21, 2021 @05:02PM (#28950804)

Thanks for the answer.

May be worth pointing that out in the article since the increased disk usage has been mentioned multiple times in the article without any indication that it's only temporary until ClickHouse merges the parts.

[ Parent | on HN ]