Sample Header Ad - 728x90

Best database solution for high volume tables / data indexing (snapshots) [PostgreSQL]

0 votes
1 answer
70 views
My problem at the moment, is that I need to index/save snapshots of some data every x minutes, so every x minutes I am inserting around 500k new rows, into a table, which each one represents a snapshot of an account. My general problem is that this creates around 100Gb of new data per day at the moment, what is the best way to compress this, without increasing the time spent on querying. Is TimescaleDB a nice solution, even though isn't a time-series based table?
Asked by Ala (1 rep)
Jul 15, 2024, 11:52 PM
Last activity: Jul 20, 2024, 04:42 PM