Programming, Alibaba Cloud, Database, Postgresql, Data Analytics.
Online Objects per Minute Query once per second and write data to the results table. create table result (crt_time timestamp(0) default now(), state boolean, cnt int); create index idx_result_1 on result using brin (crt_time); insert into result (state,cnt) with recursive t as ( ( select