Building Geospatial Apps on Postgres, PostGIS, & Citus at Large Scale

Explore a conference talk from Citus Con 2022 focusing on building large-scale geospatial applications using PostgreSQL, PostGIS, and Citus on Azure. Discover how Nirav Savani and Mahipal Ramidi managed a geospatial application for major global insurance firms, processing vast amounts of data for spatial insights. Learn about the challenges of scaling spatial capabilities with increasing data volume and user concurrency, and how PostGIS and Citus extensions to PostgreSQL meet their application's requirements. Gain insights into spatial indexing, data sharding across multiple database nodes, and maintaining performance at scale. The talk includes a detailed overview of the GC Advantage Point platform, its user analysis capabilities, and a live demonstration. Dive into technical aspects such as shard count and server parameters for real-time analytics applications, and benefit from the speakers' extensive experience in software development and data engineering.

Introduction.
Overview of GC Advantage Point.
How users analyze accumulations for their portfolios.
GC Advantage Point by the numbers.
Azure Database for Postgres – Hyperscale (Citus).
Shard count & useful server parameters for real time analytics apps.
Demo of GC Advantage Point.
Q&A with Nirav, Mahipal, & Marco .