A Practical Guide to Postgres Full-Text Search
You can ship fast, relevant search on the database you already run. Here's how tsvector, GIN indexes, and ranking fit together in real projects.
Editorial team
66 articles
BlogsPublication is researched, written, and edited by a small team. We work from primary sources and link to them, a human editor is responsible for everything we publish, and we note substantive corrections on the article itself. Where AI tools help with research or drafting, a person still verifies the result before it runs.
How we research, edit and correct: editorial policy · who runs the site: about us
You can ship fast, relevant search on the database you already run. Here's how tsvector, GIN indexes, and ranking fit together in real projects.
In March 2024, Interaction to Next Paint replaced First Input Delay as a Core Web Vital. Here's what INP measures, the thresholds that matter, and how to fix a slow score.
Largest Contentful Paint should be 2.5 seconds or less. Here's what LCP measures, the four parts a slow score breaks into, and the fixes that actually move it.
The gap between a mediocre AI answer and a great one is usually the prompt, not the model. Here's a practical framework — task, context, examples, format — with a before-and-after you can copy.
A good CLS is 0.1 or less. Here's what causes the page to jump while it loads — images, ads, fonts, injected content — and how to hold everything in place.
Core Web Vitals are three metrics — LCP, INP, and CLS — that measure loading, responsiveness, and visual stability. Here's what each one means, the thresholds, and which to fix first.