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.