This repository contains the materials for my talk “BISCUIT: Solving PostgreSQL’s Wildcard Search Performance Problem” presented at FOSSASIA Summit 2026 under the PGDay track.
- Talk Recording – Video of the conference presentation
- Slides (PPTX) – Original presentation slides
- Slides (PDF) – Exported version of the slides
video/talk.mp4– Recording of the talkslides/Biscuit.pptx– Original presentation slidesslides/Biscuit.pdf– PDF version of the slides
This talk introduces BISCUIT, an approach to deterministic wildcard indexing in PostgreSQL. It explores how wildcard queries can be indexed efficiently and how deterministic indexing techniques can improve query performance and scalability in database systems.
Topics covered include:
- Challenges of wildcard search in databases
- Indexing strategies for pattern matching
- Deterministic indexing approaches
- Practical considerations for PostgreSQL systems
FOSSASIA Summit 2026 is an international open technology conference that brings together developers, researchers, and open-source communities to share knowledge and collaborate on open technologies.
The content of the slides (text, ideas, explanations, and diagrams) is licensed under the Creative Commons Attribution 4.0 International (CC BY 4.0) license.
You are free to share and adapt the material provided that appropriate credit is given to the original talk and author.
If you reuse material from these slides, please attribute:
“BISCUIT: Deterministic Wildcard Indexing in PostgreSQL” — presented at FOSSASIA Summit 2026.
Some visual design elements may originate from a Canva presentation template and remain subject to Canva's template licensing terms.