Yeah 5GB is tiny. You could keep your whole database in RAM for fast queries. I've worked on a system that generates a few hundred GB of data per day that goes

Yeah 5GB is tiny. You could keep your whole database in RAM for fast queries. I've worked on a system that generates a few hundred GB of data per day that goes into sharded MySQL databases. Personally, my side business database is a trivial size of less than 1GB. Although I do produce event logs that go into Timescale which is Postgres. That Timescale database is getting up to 100GB but I don't have to manage that myself.