Schedule - pgDay Paris 2025
Full-Text-Search Explained from A to Z with French Food
Date: 2025-03-20
Time: 11:15–12:00
Room: Auditorium
Bon Appétit! Join us for a delicious deep dive into PostgreSQL's full-text search capabilities, seasoned with the flavors of French cuisine. We'll start with the basics (Apéritif - what is full-text search and why use it?), then move on to the main course (Cassoulet - exploring core concepts like tsvector, tsquery, and ranking).
We'll savor the nuances of stemming, lexemes, and parsing documents like a fine Boeuf Bourguignon. For dessert, we'll indulge in advanced techniques (think Tarte Tatin!): fine-tuning search with weights, stemming dictionaries, and custom configurations.
To top it off, we'll explore the art of combining classic full-text search with the exciting world of semantic search, creating a hybrid approach that captures both precise keyword matching and contextual understanding (like a perfect pairing of Croque Monsieur and Soupe à l'oignon).
Leave this session with a full stomach and the knowledge to implement powerful and efficient full-text search in your PostgreSQL applications. Allons-y!