一、
域名:
vgoldpoint-ro-pg.prd.yumc.local(172.25.112.152)
vgoldpoint-pg.prd.yumc.local(172.21.33.235)
集群IP:
172.21.32.23(主)
172.25.112.152
172.25.112.80
172.21.32.24
需要创建2025年分表
1.point_trans_shard_XX_part_XX
2.point_trans_source_shard_XX_part_XX
二、
域名:
vgold-point-archive-pg.prd.yumc.local(172.25.112.160)
IP:
172.25.112.160(主)
需要创建2025年分表
1.point_trans_shard_XX_part_XX
select public.add_partition_table_for_point_trans(202601,12,256);
2.point_trans_source_shard_XX_part_XX
select public.add_partition_table_for_point_trans_source(202601,12,256);
三、
域名
vgoldtrade-ro-pg.prd.yumc.local(172.21.32.28)
vgoldtrade-pg.prd.yumc.local(172.21.33.237)
集群IP:
172.21.32.28
172.21.32.27(主)
172.25.112.30
172.25.112.119
需要创建2025年分表
1.rule_order_shard_xx_part_xxxx
select public.add_partition_table_for_rule_order(202601,12,256);
2.rule_order_validation_error_record_part_xxxx
select public.add_partition_table_for_rule_order_validation_error_record(202601,12);
3.rule_order_operatation_error_record_part_xxxx
select public.add_partition_table_for_rule_order_operatation_error_record(202601,12);
4.rule_personal_limit_record_part_xxxx
select public.add_partition_table_for_rule_personal_limit_record(202601,12);
SELECT tablename
FROM pg_catalog.pg_tables
WHERE tablename LIKE '%2025%';