Separating a single database into one user/transaction database and one time series database
0
votes
0
answers
22
views
My project involves storing sensor data (time series data) in db. There are about 5,000 sensors, each is sending data at 15 min to 1 hour interval. The existing service is using a single db, storing all frontend user, transaction and sensor data. The table holding time series data now has over 10 million rows. Other tables such as user table has a few thousands rows.
If separating sensor data into a dedicate db (say Postgres with TimescaleDB extension), will there be significant benefits in terms of performance, that out-weights the complexity introduced?
Asked by Oliver Lu
(1 rep)
Feb 11, 2023, 03:25 PM