What database is suitable for trillions of records with indexes?

Question

Database

Please advise a Debian database for trillions of indexed data. Wish it was free.

Answer 1

Need more information about the task:
1. data type: structured or not.
I assume structured, under RDBMS
2. record size (in bytes)
3. number of fields in the record
4. field data types (including fields with variable length)
5. base purpose (OLTP / OLAP)
6. number of indexes and columns in indexes
Here, somewhere so.
If you have the information above, you can give a balanced answer.
Otherwise, you will get something like: "Go horse, horse." :)
Good luck.

Answer 2

if we are talking about some timeseries, then it works the fastest and takes up less space ClickHouse

Answer 3

One server is not suitable for these volumes. You need something distributed. More precisely, we can only say only after there is information about what data is stored there and how it is stored, written and read. What is the frequency and

Answer 4

Normal postgre is enough. You can safely generate a dataset ( https://postgrespro.ru/docs/postgrespro/9.5/functi... and test the speed of fetching and reading, it won't take much time.