tubeshowcase●1,658,115 videos♡ My collection 0
← Learn to Code

Learn to Code30:12

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

Microsoft Developer ↗

From the creator

In this talk presented in the Americas livestream at Citus Con: An Event for Postgres, Nirav Savani and Mahipal Ramidi share their customer experience managing a geospatial application using PostGIS, PostgreSQL, and Citus on Azure. With their geospatial application, some of the biggest global insurance firms translate vast amounts of data into spatial insights. The workload has 3000 global users, with 10-50 of them concurrently performing complex geospatial analysis, crunching millions of rows across 1000s of spatial polygons. Results are expected in real-time. The dataset is 25 TB. In this talk, you’ll learn about their challenges scaling their spatial capabilities as their data volume & number of users (including concurrency) grew. Nirav and Mahipal share their learnings from building a large-scale geospatial workload on Postgres. Their goal was to identify a database that scales, which made them evaluate and land on the PostGIS and Citus extensions to PostgreSQL. Come learn how PostGIS and Citus meet their application’s requirements: how the spatial indexing of PostGIS combines with the ability to scale out (shard) data across multiple database nodes with Citus, without affecting performance. Nirav Savani works as a Senior Engineering Manager with 19 years of software Development experience. He is passionate about architecting high-performing scalable software applications to solve complex business problems. Having worked on Java applications primarily, he leads a large

Published 2022-04-26 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code