Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Wednesday, May 12 • 16:00 - 16:30
Comparing Geospatial Implementation in MongoDB, Postgres, and Elastic

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.

For a considerable set of applications querying geographical data consists of a critical operation. Fast responses combined with a high level of accuracy are often the requirements when an application user interacts with functions/operations of the type “Give me near me” or “Find me in area XYZ”. Additional complexity is usually added when the points of interest are constantly on the move, like a public transportation vehicle or a taxi.

For applications that frequently access geographical data and rely on both speed and accuracy, both application and database design is crucial. In this presentation, we are going to focus on the database side. More specifically, we are going to evaluate three of the most popular open-source databases, MongoDB, Postgres, and Elastic against geospatial workloads. For each of these databases, we are going to examine the implementation and the performance of geo-queries. We are going to discuss best practices and design patterns for each database and try to find a winner among the three.

avatar for Alex Cercel

Alex Cercel

Senior Database Engineer, Palantir technologies
A Red Hat Certified Architect that is also enjoying Windows and network administration and has an itch for Databases. Loves The Cloud. Currently working as an SRE for a team that is supporting a variety of datastores, mostly NoSQL. All round geek with a genuine passion for anything... Read More →
avatar for Antonios Giannopoulos

Antonios Giannopoulos

Senior Database Administrator, Rackspace Technology
I am working as Senior NoSQL Database Administrator at Rackspace supporting thousands of MongoDB installations over the past 7 years. I have 18 years experience in databases and system engineering. I really enjoy challenges in sharding and schema design and love migrations from Relational... Read More →
avatar for Pedro Albuquerque

Pedro Albuquerque

Staff Database Engineer, Wise (former TransferWise)
I have many years of working in various database technologies, which include relational and NoSQL platforms. I am currently focused on MariaDB, MongoDB and PostgreSQL datastores at Wise. Previously to Wise, I was focused on MongoDB at ObjectRocket by Rackspace, supporting customers... Read More →

Wednesday May 12, 2021 16:00 - 16:30 EDT
Room #2