Project Page

PostgreSQL

PostgreSQL China User Group

PostgreSQL中文社区:: 世界上功能最强大的开源数据库...

Doc

Documentation

JSONB PostgreSQL: How To Store & Index JSON Data

中文分词（zhparser）

install rum / pg_jieba / zhparser

https://github.com/CrunchyData/postgres-operator

CitusData

Citus Data | Distributed Postgres. At any scale.

Citus Docker compose: https://github.com/citusdata/dockerCi

Citus Kubernetes： https://github.com/wenerme/kube-stub-cluster/tree/main/citus

// get all active worker
select citus_get_active_worker_nodes();

// checking shard distribution
select * from citus_shards;

// view all tables
select * from citus_tables;

select * from pg_dist_node;
SELECT * from pg_dist_shard;