From PostgreSQL to Elasticsearch: Migrating a Fuzzy Name Search at Scale
βπ Date: Thursday, October 15 from 6:00-9:00 PM
βπ Location: Elastic London Office
βDavidson Building, 1st Floor, 5 Southampton St,
βLondon, WC2E 7HA
βπ Important: Please use the Exeter St entrance as the main entrance is closed after 6 PM.
ββ οΈ Entrance will be on a first come, first served basis, subject to room capacity β arrive on time to guarantee your spot.
ββ° Agenda
βArrivals, pizza and drinks: 6 PM
βWelcome: 6:30 PM
βTalk #1: 6:45 - 7:15 PM
βTalk #2: 7:15 PM - 7:45 PM
βNetworking: 7:45 PM
βClosing: 8:30 PM
βTalk #1 by Amir Hossein Rassafi | Software Engineer at Condukt
βWhat happens when your search quality is good but your database can't keep up? In this talk, we'll walk through a real migration from PostgreSQL's pg_trgm to Elasticsearch β driven by growing latency and database pressure.
βWe'll cover how to preserve trigram-like behaviour using n-grams, prefixes, keywords, and shingles, how to validate the new system with real queries and synthetic typo cases, and the production details that made the migration safe: replication, checkpointing, lag handling, and replayable indexing.
βA practical talk for anyone dealing with fuzzy search at scale β or planning a migration where quality, performance, and reliability all matter.
βTalk #2 details TBC soon