Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
min(cnt), max(cnt) from result where crt_time between ? and ? group by 1; Optimizing with Large Number of Sensor IDs When the number of sensor IDs reaches 100,000, the query performance drops to 250 milliseconds. If the number of sensor IDs is particularly large; for example, more than one million,