3 ms·
I really like Postgres as an allround database, and putting monitoring data into Postgres is an attractive idea to me. One thing I'm wondering is how well you c
by fabian2k 7y ago
I really like Postgres as an allround database, and putting monitoring data into Postgres is an attractive idea to me. One thing I'm wondering is how well you can mix a regular Postgres database with timeseries data using TimescaleDB? If I have a regular application using Postgres, can I just add timeseries in there with TimescaleDB in the same database? Or is that either not possible, or simply a bad idea?
- dedsm 7y agoit's perfectly fine to use TimescaleDB alongside any regular tables.
- RobAtticus 7y agoYou definitely can mix the two, and we actually find it a very useful thing so you can have your metadata available to query alongside the time series data. TimescaleDB will only make a table a hypertable if you tell it too, otherwise regular tables should work as you'd expect. And since we appear as a table in the contexts that it matters (JOINs, querying, inserting, etc), you shouldn't have any issues mixing the two.
- stalller 7y agoIt is encouraged! :)
- GordonS 7y agoI do this, and it works just fine - no caveats, it's actually one of the selling points of TimescaleDB.
- jeltz 7y agoYes you can, and I think this is one of the main selling points of TimescaleDB.