Re:Ask HN: How to store billions of rows of time-series data?
by icsa on Sunday April 05, 2020 @03:07PM
(#22787684)
I have built many billion+ row databases on a laptop with 16 GB RAM, using the 32-bit version. kdb+ uses memory mapping and can support databases much larger than available RAM.
PostgreSQL is a fine choice and I use it for many projects. However, kdb+ is a much better choice when time-series analysis is required.
I'm happy to provide more details if you're interested.
PostgreSQL is a fine choice and I use it for many projects. However, kdb+ is a much better choice when time-series analysis is required.
I'm happy to provide more details if you're interested.