Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
the performance drops to 2.5 seconds. In this case, it is not appropriate to query once per second. Therefore, how can we optimize when there are a lot of sensors? A better method is to hash the data by sensor ID. For example, each partitioned table has 10,000 sensor IDs. When querying the number