本专栏全部文章 | https://blog.csdn.net/tonghu_note/category_11713514.html |
总目录 | https://blog.csdn.net/tonghu_note/article/details/124333034 |
来我的dou音 aa10246666, 看配套视频
一、实战环境
节点 cn_node1(协调节点,不存储数据) | postgresql 14.2 | 10.211.55.9 |
节点 worker1_node2(工作节点,存储数据) | postgresql 14.2 | 10.211.55.4 |
节点 worker2_node3(工作节点,存储数据) | postgresql 14.2 | 10.211.55.6 |
citus-10.2 / debian 9 |
二、Citus核心系统表
1、查看shard分布信息
列出所有表及shard情况
d1=# select * from pg_dist_shard ;
logicalrelid | shardid | shardstorage | shardminvalue | shardmaxvalue
--------------+---------+--------------+---------------+---------------
t1 | 102266 | t | -2147483648 | -2013265921
t1 | 102267 | t | -2013265920 | -1879048193
t1 | 102268 | t | -1879048192 | -1744830465
t1 | 102269 | t | -1744830464 | -1610612737
t1 | 102270 | t | -1610612736 | -1476395009
t1 | 102271 | t | -1476395008 | -1342177281
t1 | 102272 | t | -1342177280 | -1207959553
t1 | 102273 | t | -1207959552 | -1073741825
t1 | 102274 | t | -1073741824 | -939524097
t1 | 102275 | t | -939524096 | -805306369
t1 | 102276 | t