vgold每年创建一次分区表

31 阅读1分钟




一、

域名:

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%';