WeAreDevelopers Logo WeAreDevelopers
Sign in
For You LIVE
World Congress 2025 • Aug 20, 2025 • Session details

Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search

Dharin Shah

Can PostgreSQL outperform specialized search engines? Discover how GetYourGuide migrated from OpenSearch, deeply tuning TOAST tables and JSONB structures to slash API latency by 40%.

Pause
Mute Enter Fullscreen
#1 about 2 min

Overview of the GetYourGuide event-based marketplace

An overview of the event marketplace and the business need for a highly responsive discovery system.

#2 about 2 min

Reviewing the legacy search architecture using OpenSearch

The previous search system combined data processing pipelines, OpenSearch for document indexing, and PostgreSQL for availability handling.

#3 about 2 min

API flow for frontend team search queries

Custom domain-specific languages handle frontend filtering rules before requests reach the ranking and ML services.

#4 about 2 min

Technical challenges driving the OpenSearch database migration

A lack of relational joins, complex query structures, and frequent latency spikes limited product flexibility and required high maintenance.

#5 about 2 min

Advantages of migrating search infrastructure to PostgreSQL

Leveraging a mature relational model with flexible JSON support significantly reduces operational complexity and underlying infrastructure costs.

#6 about 3 min

Analyzing limitations with PostgreSQL bitmap heap scans

Running memory-resident TID bitmaps creates additional performance steps compared to faster index-only execution plans.

#7 about 4 min

Evaluating aggregations and memory usage of roaring bitmaps

Native PostgreSQL row-oriented storage struggles with high-cardinality data compared to OpenSearch's highly compressed memory-efficient roaring bitmaps.

#8 about 2 min

Implementing denormalized schemas with GIN indexes in Postgres

Combining array-based columns with GIN indexes perfectly maps to previously denormalized OpenSearch document structure dependencies.

#9 about 2 min

Retrieving custom API payloads using a single query

Executing common table expressions produces a unified JSON result format instead of receiving multiple tabular relational results.

#10 about 2 min

Performance impacts and search data cardinality evaluation

Evaluating search patterns confirms that query caching limits performance degradation when dealing with high-cardinality Postgres filter states.

#11 about 2 min

Generating dynamic database queries using the JOOQ library

Implementing JOOQ provides clean and compile-time validated SQL generation code for handling complex dynamical client search criteria.

#12 about 2 min

Managing infrastructure limitations with managed Amazon Aurora databases

Adopting managed database clusters simplifies replica deployment but restricts usage of specialized real-time aggregation extensions.

#13 about 2 min

Optimizing TOAST configurations for large JSON metadata blobs

Increasing the tuple target size alongside lz4 compression radically reduces row amplification when saving multi-language localization metadata.

#14 about 2 min

Preventing replication conflicts from database vacuum operations

Disabling truncation commands during vacuum runs safely prevents exclusive locks blocking access to standby read replica pages.

#15 about 3 min

Postgres migration performance results and future semantic search

The search layer transition successfully reduced overall latency and cleared a unified roadmap for robust vector-based semantic search.

Matching moments

2:18 min

Comparing PostgreSQL and DynamoDB for read-heavy storage

George Asafev · World Congress 2023

3:00 min

Benchmarking SearchOLAP against existing database engines

Andrey Abramov Andrey Abramov · World Congress 2026 Europe

2:01 min

Migrating existing applications from MongoDB to Postgres

Nikita Shamgunov Nikita Shamgunov · World Congress 2024

3:46 min

Navigating enterprise adoption, search optimization, and platform scaling concerns

Fabian Hedin Fabian Hedin · World Congress 2026 Europe

5:53 min

Choosing relational databases over NoSQL for most workloads

Josip Stuhli Josip Stuhli · World Congress 2026 Europe

1:02 min

Migrating from local JSON storage to relational databases

Noam Honig · World Congress 2023

More from World Congress 2025

GenAI Security: Navigating the Unseen Iceberg thumbnail
24:33
11 months ago

GenAI Security: Navigating the Unseen Iceberg

Maish Saidel-Keesing

Behind the Code: How Women Are Powering the Future of AI thumbnail
30:28
about 1 year ago

Behind the Code: How Women Are Powering the Future of AI

Alexandra Wudel, Laura Moritz, Madalina Florean

The AI Hype Filter: What’s Real, What’s Investable, What’s Noise? thumbnail
28:12
about 1 year ago

The AI Hype Filter: What’s Real, What’s Investable, What’s Noise?

Justus Lumpe, Konstantin Vinogradov, Nils Eiteneyer, Stephan Wirris

AI in Leadership: How Technology is Reshaping Executive Roles thumbnail
28:19
about 1 year ago

AI in Leadership: How Technology is Reshaping Executive Roles

Bernd Datler, Jasmin Kaiser, Jeff Hausmann, Sonja Alvarez

The AI-Ready Stack: Rethinking the Engineering Org of the Future thumbnail
28:09
about 1 year ago

The AI-Ready Stack: Rethinking the Engineering Org of the Future

Alex Laubscher, Jan Oberhauser, Keno Dreßel, Mirko Novakovic

AI Sovereignty: What Does It Take? thumbnail
29:13
about 1 year ago

AI Sovereignty: What Does It Take?

Boris Hecker, Clemens Wasner, Robin Hermann, Sonja Alvarez

Related videos

Scaling: from 0 to 20 million users thumbnail
28:12
World Congress 2023 • about 3 years ago

Scaling: from 0 to 20 million users

Josip Stuhli

Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client thumbnail
30:28
World Congress 2026 Europe • 3 months ago

Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client

Max Fischer, Michael O'Toole

Tracking vehicles at scale thumbnail
30:33
Europe 2026 Virtual • 3 months ago

Tracking vehicles at scale

Thorsten Riess

Swapping Low Latency Data Storage Under High Load thumbnail
22:32
World Congress 2023 • almost 3 years ago

Swapping Low Latency Data Storage Under High Load

George Asafev

Boosting OpenSearch Performance: gRPC Search in Action thumbnail
24:20
Europe 2026 Virtual • 3 months ago

Boosting OpenSearch Performance: gRPC Search in Action

Sakshi Nasha

Database Magic behind 40 Million operations/s thumbnail
24:22
World Congress 2023 • almost 3 years ago

Database Magic behind 40 Million operations/s

Jürgen Pilz

Related articles

From learning to earning

Jobs that call for the skills explored in this talk.