https://www.manning.com/books/scalatra-in-action
PostgreSQL as a Time Series Database
The database is range partitioned into 24 partitions based on the ts field, the main table and the partitions are indexed on the timestamp (ts) and status fields. Hardware spec AMD Ryzen 7 5800x 128gb Corsair 3600 MT/s RAM SABRENT M.2 NVMe SSD 1TB Gen 4, Internal Solid State Debian Linux 12 PostgreSQL 15 With …