Building geospatial apps on Postgres, PostGIS, & Citus at large scale

on YouTube ↗30m

" summary

A geospatial analytics platform built on PostGIS + Citus on Azure Hyperscale handles a 25 TB dataset and supports 3,000 users with 10–50 concurrent analysts running real‑time spatial queries that intersect millions of rows against thousands of polygons. Data is sharded by portfolio ID, shape tables are replicated as reference tables, shard count targets 2–4× cores, and the distributed cluster cuts query times (single query 10s vs 24s) and raises concurrency 10–100×.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 1:52Overview of GC Advantage Point
3. 3:16How users analyze accumulations for their portfolios
4. 9:12GC Advantage Point by the numbers
5. 12:15Azure Database for Postgres – Hyperscale (Citus)
6. 17:58Shard count & useful server parameters for real time analytics apps
7. 19:46Demo of GC Advantage Point
8. 28:52Q&A with Nirav, Mahipal, & Marco

" related talks

• 24mCitus from the Customer eyesSai Krishna Srirampur · Citus Con: An Event for Postgres 2023
• 08mFoundations of Distributed PostgreSQL with CitusOnder Kalaci · Azure Cosmos DB: Liftoff 2022
• 31mKEYNOTE: The Distributed PostgreSQL Problem & How Citus Solves itMarco Slot · Citus Con: An Event for Postgres 2023
• 55mBreakout SessionDan Robinson · PGConf Silicon Valley 2015
• 16mOnline Scale-Out and Cloud Data IngestionAdam Wolk · Azure Cosmos DB: Liftoff 2022
• 16mKeynote – Umur CubukcuUmur Cubukcu · PGConf Silicon Valley 2015
• 44mDistributed Postgres with CitusWill Leinweber · HighLoad++ 2017
• 31mCitus and JSON for real-time analytics at Vizor GamesIvan Vyazmitinov · Citus Con: An Event for Postgres 2023