Ask HN: Cheapest way to run a time-series database in cloud?
10 points by cedws 13 hours ago | 9 comments
I need to run a database (preferably Postgres-based, currently using TimescaleDB) to store about 20M rows of price data per day, with the option to discard or offload data after 7d to cold storage.
It's just a hobby project that doesn't make me any money, so I want to run this as cheaply as possible. I was experimenting with TimescaleDB cloud but the pricing there starts at $40 a month not including storage.
I tried running it myself on Fly.io but the DB imploded within hours of setting it up and was extremely difficult to recover, so I had to give up on that.
patricklorio 9 hours ago | next |
Highly recommend clickhouse. You can set the partition key to be based on date and delete old data in chunks. Makes life really easy. Also found it much more performant than timescaledb out of the box. Not sure about hosted options but can imagine that translates to better performance for the dollar.