my table is as below:
create table if not exists dts_lpi
(
custid varchar(12),
meterid varchar(10),
read_time timestamp,
read_date date,
date_created timestamp,
last_updated timestamp,
del_kwh numeric,
rec_kwh numeric,
del_kwh_val_status varchar(5),
rec_kwh_val_status varchar(5)
);
This table will be insert upto 3 billions data everyday. And the retention period is 2 months.
The total number of meterid is from 3 millions up to 20 millions.
I create the hypertable with below commands:
select create_hypertable(‘dts_lpi’, ‘read_time’);
select set_chunk_time_interval(‘dts_lpi’, INTERVAL ‘15 minutes’);
select add_retention_policy(‘dts_lpi’, INTERVAL ‘2 months’);
Now I want to add the field meterid to partitioning column with command add_dimension(...) . What number_partitions should I give ?