Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
aid int, – the sensor ID crt_time timestamp, – time of reporting val numeric – reported value ); create index idx_b_1 on b(aid, crt_time desc); – indexing Write 100,001 sensor IDs and the reported data reported by 100 million sensors. insert into a select generate_series(0,100000); insert into b