What about RRDtool? github
What RRDtool does
RRDtool is the OpenSource industry standard, high performance data logging and
graphing system for time series data. RRDtool can be easily integrated in shell
scripts, perl, python, ruby, lua or tcl applications.
It's fairly old-school, and well-known among sysadmins, but it is not really an SQL database.
One possible solution is VeraCrypt. You can use file (or partition) which you can mount as disk drive. It is very secure and very stable software. And its free.
To add a bit more info: veracrypt is available for Windows, MacOS, Linux, FreeBSD, Raspberry Pi OS.
P.S. No affiliation with developers of this product.
One possible solution about your case is to use external software. My idea is to use Hive with Parquet tables and create the sort there.
Here you can find sample instruction how to create table for Parquet. You can also check this Q/A in Stack Overflow about load the data directly from Parquet file.
Here you will find how to build statement with sort by ...
I can not comment so I apologize for 'answering', but it seems to me you need error correction or even RR retries rather than guessing disguised as statistics. So for this you'd need a reader/adapter that dumps the NAND while bypassing the controller. See for example: http://www.flash-extractor.com/manual/read_retry/step_by_step/.
Also if we compare C0 and ...
which gives less than 500 MB of historical records (...) expecting to see fifty to one hundred times the current data usage, ideally without buying new hardware
500 MB is a tiny database, I would not expect PostgreSQL to be a limitation here
It is quite challenging to work with a relational model to get the sort of information one needs to ...
Try DynamoDB if you can pay for it. Yes, it doesn't match with your open-source requirement, but it does it all.
but it's semi-structured dynamically-changing data
ideal use-case for DynamoDB
As the table is not aimed to grow infinitely, each table could be stored in a JSON document using an array of arrays.
Dynamo tables are sets of key-value and can be ...