Episode
Building geospatial apps on Postgres, PostGIS, & Citus at large scale | Citus Con 2022
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.
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 team involved in modernizing a distributed geospatial analytics platform to a cloud native architecture using microservices, Microsoft Azure, Postgres, Citus, and Databricks.
Mahipal Ramidi works as a data engineer with 14 years of experience in software development. His primary skills are building data-centric applications in Oracle, SQL Server, and PostgreSQL, along with business intelligence applications. In his role at Guy Carpenter, he supports real-time analytics applications using geospatial computations in the PostGIS extension to Postgres. And he is deeply involved in developing high-throughput data pipelines and ETL applications in Azure Cloud, using Azure Data Factory and Azure Databricks.
Recommended resources
- Watch more Citus Con talks on docs.microsoft.com and YouTube
- Everything you need to know about Citus Con: An Event for Postgres can be found here
Connect
- Citus Con | Twitter: @CitusCon
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.
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 team involved in modernizing a distributed geospatial analytics platform to a cloud native architecture using microservices, Microsoft Azure, Postgres, Citus, and Databricks.
Mahipal Ramidi works as a data engineer with 14 years of experience in software development. His primary skills are building data-centric applications in Oracle, SQL Server, and PostgreSQL, along with business intelligence applications. In his role at Guy Carpenter, he supports real-time analytics applications using geospatial computations in the PostGIS extension to Postgres. And he is deeply involved in developing high-throughput data pipelines and ETL applications in Azure Cloud, using Azure Data Factory and Azure Databricks.
Recommended resources
- Watch more Citus Con talks on docs.microsoft.com and YouTube
- Everything you need to know about Citus Con: An Event for Postgres can be found here
Connect
- Citus Con | Twitter: @CitusCon
Have feedback? Submit an issue here.