Scaling Citus Clusters via Logical Replication – Lessons from PostgreSQL China Conference

The 10th PostgreSQL China Technical Conference in January 2021 featured expert talks on scaling Citus clusters with logical replication and on applying PostgreSQL to Suning’s retail digitalization, highlighting architecture, challenges, technology choices, and future directions for database-driven business transformation.

CitusData ArchitectureLogical Replication

0 likes · 2 min read

Scaling Citus Clusters via Logical Replication – Lessons from PostgreSQL China Conference

dbaplus Community

Nov 22, 2020 · Databases

How Suning Scaled with PostgreSQL & Citus: Lessons from 3000+ Instances

This article details Suning's journey of replacing commercial databases with PostgreSQL and Citus, covering background, feature and performance comparisons, reliability tests, deployment architecture, real‑world use cases, operational tips, and a comprehensive Q&A on migration and maintenance.

CitusOperational Experiencedatabase migration

0 likes · 26 min read

How Suning Scaled with PostgreSQL & Citus: Lessons from 3000+ Instances

Suning Technology

Nov 22, 2020 · Databases

How Suning Scaled PostgreSQL to 4,000+ Instances for Smart Retail

Suning’s 2020 PostgreSQL case study, presented at PostgresConf.CN & PGConf.Asia, details how the company deployed over 4,000 instances, leveraged Citus, JSON, PostGIS and roaringbitmap, and achieved cost savings and smart‑retail capabilities across billing, analytics, location search and user profiling.

Case StudyCitusDatabase Deployment

0 likes · 3 min read

How Suning Scaled PostgreSQL to 4,000+ Instances for Smart Retail

Suning Technology

Sep 29, 2020 · Databases

How SuNing’s O2O System Uses PostGIS & Citus for Scalable Geospatial Retail

Facing the post‑pandemic slowdown of e‑commerce growth, SuNing pioneered an O2O “smart retail” strategy by integrating online and offline channels through its “Anytime Business System,” which combines PostGIS‑enabled geospatial analysis, PostgreSQL high‑availability clustering with Citus, and seamless data flow across front‑end, transaction, and support layers.

CitusGeospatialO2O

0 likes · 17 min read

How SuNing’s O2O System Uses PostGIS & Citus for Scalable Geospatial Retail

Architects Research Society

Feb 3, 2020 · Databases

MapReduce‑Style Parallel Query Processing with Citus

The article explains how Citus enables sharding and MapReduce‑style parallel query execution in PostgreSQL, showing performance gains, example bucket algorithms, and how standard SQL can replace custom MapReduce code for large‑scale data analytics.

CitusDistributed PostgreSQLMapReduce

0 likes · 6 min read

MapReduce‑Style Parallel Query Processing with Citus

ITPUB

Dec 16, 2017 · Databases

Why PostgreSQL Is Climbing the DB‑Engines Rankings in 2017

The December 2017 DB‑Engines ranking shows Oracle still on top, while PostgreSQL maintains steady growth, gaining momentum with JSON support and the Citus extension, as developers turn to it over NoSQL alternatives, signaling a potential shift in the database landscape.

CitusDB-EnginesDatabase Rankings

0 likes · 5 min read

Why PostgreSQL Is Climbing the DB‑Engines Rankings in 2017