Video by FOSSASIA via YouTube
Wildcard searches (LIKE and ILIKE) are common in PostgreSQL applications, but they often become a major performance bottleneck. Traditional B-tree indexes only optimize prefix searches, while pg_trgm can produce false positives that require expensive heap rechecks.
This session introduces Biscuit, an open source PostgreSQL extension that uses a new bitmap-based indexing approach to accelerate wildcard pattern matching. Learn how Biscuit integrates with the PostgreSQL query planner, avoids unnecessary heap rechecks, and delivers faster, more predictable query performance for text-heavy workloads.
We’ll explore the indexing algorithm, benchmark results against B-tree and pg_trgm, practical use cases, and the trade-offs of building a custom PostgreSQL index access method. Whether you’re a PostgreSQL DBA, database developer, or systems engineer, this talk offers valuable insights into query optimization and PostgreSQL internals.
FOSSASIA Summit 2026 held in Bangkok, is Asia’s leading Open Source tech conference featuring sessions on #AI, #Cloud, #DevOps, #Open Hardware, #Security, #Web #Mobile Technologies, #Web3, and #Databases. Learn more: http://summit.fossasia.org
Session slide: https://eventyay.com/ev/88882f3e/talk/3DBEVESKT2LW/
#FOSSASIA #FOSSASIASummit #opensource #FOSS