Which database to choose to store 10 billion rows?

Question

SQL

Dear BigData experts,
I have a data array of two fields of the Integer type, one with 200 million unique values, the other with 100 million. In total, there are about 10 billion values ​​in the array.
It is required to implement only two types of request:
1. Selection by the value of one of the fields.
select id1, id2 from bigtab where id1 = 123;
2. Selection by the list of values ​​with grouping
select id1, count(id2)
from bigtab
where id1 in (<list of values>)
group by id1;
What is the easiest way to do this?

Answer 1

74 gigabytes of data? Is this big data? I thought there speech begins with a terabyte.
postgresql, plus partitioning by id1

Answer 2

yes, you can simply do it on mysql last