I don't think the database does much if it doesn't get the resources and an schema that supports it. As an relative beginner these are my thoughts: 1. Indices:

I don't think the database does much if it doesn't get the resources and an schema that supports it. As an relative beginner these are my thoughts: 1. Indices: signal_date_time and device_id should get indices, reading entries is speed up, but writing is a bit slower. 2. Ressources: Ram and cpu are the two most important resources, the database stores records in ram if it can and that speeds up the database. 3. Your tables may benefit from partitioning. So the data is not stored in one table but in multiple and reduces the amount of data that cannot be accessed because some other connection currently writes is lower. The partitions need to be created before the are used.