Home / Companies / Contentful / Blog / Post Details
Content Deep Dive

Full-text search at Contentful just got faster: Why it’s important and how we did it

Blog post from Contentful

Post Details
Company
Date Published
Author
Farruco Sanjurjo
Word Count
2,091
Company Posts That Month
21
Language
English
Hacker News Points
-
Post removed?
No
Summary

We've improved the median response time of full-text search in Contentful by 35% through a combination of optimizations, including input string normalization, query planning improvements, and schema adjustments. The new implementation uses a SQL function to normalize input strings, allowing for parallelization and pre-evaluation, which reduces query planning time. Additionally, combining text values into a single row per locale improves the performance of full-text searches by leveraging GIN indexes more efficiently. These changes enable editorial teams to quickly locate content using full-text search, tagging, or browsing tag collections, ultimately enhancing productivity and workflow efficiency.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.