3 ms·
Is anyone running self hosted timescale? How is it going? I have a use case for it, but don’t know why I’m a bit afraid of using it.
by drchaim 4mo ago
Is anyone running self hosted timescale? How is it going? I have a use case for it, but don’t know why I’m a bit afraid of using it.
- lkanwoqwp 4mo agoI run it on VM the same way as a few separate PostgreSQL instances. TimescaleDB is an extension to PostgreSQL, so there's a lot of information, guides, and community support online, and Postgres is one of the most widely used databases right now. There are some things to setup but Tiger data documentation is very good.
- drchaim 4mo agoI've tested the migration of the main table (IoT data), from 300GB to about 25GB in a non-production environment. Everything seems right, but I'm still delaying/procrastinating the prod migration, so I wanted to know how it is going for other live projects.
- ahachete 4mo agoAt StackGres [1] we find Timescale to be one of the most used extensions. Timescale is quite a successful project! StackGres is actually the first solution recommended by Timescale for self-hosting with Kubernetes operators [2]. So if you are into Kubernetes (or if not, consider it, using something like K3s [3] is quite straightforward and lightweight on resources), this is probably a great option to self-host which would avoid you all the hassle of manually doing all the setup involved for production-ready clusters. [1] https://stackgres.io https://stackgres.io [2] https://www.tigerdata.com/docs/get-started/choose-your-path/install-timescaledb#install-with-postgresql-kubernetes-operators https://www.tigerdata.com/docs/get-started/choose-your-path/... [3] https://k3s.io/ https://k3s.io/
- drchaim 4mo agoI'm not into k8s things, but thanks. Still run this project with Postgres in the same machine as the app. No issues so far after 8 years. :)