SELECT master_create_distributed_table(‘github_events‘, ‘repo_id‘, ‘hash‘);

SELECT master_create_worker_shards(‘github_events‘, 16, 2);

SELECT * from master_get_active_worker_nodes();

SELECT * from master_get_table_metadata(‘rewind‘);

SELECT master_copy_shard_placement(12345, ‘good_host‘, 5432, ‘bad_host‘, 5432);

select * from pg_dist_shard;

SELECT * from pg_dist_shard_placement;

本文出自 “勇敢向前，坚决向左” 博客，谢绝转载！

citusdb function集合