18:45Build smarter search without AI: Fuzzy matching for applications | Data Exposed
Microsoft Developer
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.
18:45Microsoft Developer
02:01
20:24
01:40
19:55Microsoft Developer
57:29
09:02Allow Google Analytics to measure visits. Your history stays in your browser. Privacy details