Video wird geladen...

Video konnte nicht geladen werden

Zur Startseite

Inverted indexes are the perfect structure for text search. "Inverted" here doesn't mean upside-down. Rather that it's an inversion of the original data. We take every distinct word from a set of documents and build a "posting list" of references back to every location where that word is used....

32,297 Aufrufe • vor 18 Tagen •via X (Twitter)

10 Kommentare

Profilbild von Eddy
Eddyvor 18 Tagen

FAST balls indeed

Profilbild von Rishabh Chauhan
Rishabh Chauhanvor 18 Tagen

will you open source it?

Profilbild von Ratul Dawar
Ratul Dawarvor 17 Tagen

But this doesn’t include like queries right?

Profilbild von Ben Dicken
Ben Dickenvor 17 Tagen

The index is the structure for making searches fast. TIN has a complete syntax for specifying search queries, TINQL

Profilbild von Samantha
Samanthavor 18 Tagen

Hi Ben, just following up on the DM I just sent regarding a potential Bloomberg interview. Would love to hear from you when you get a chance.

Profilbild von shane borden 🛩️
shane borden 🛩️vor 18 Tagen

How did you resolve the hot block 0 issue with regular GiN indexes. No more pending list? Fast update?

Profilbild von Darius Rey
Darius Reyvor 18 Tagen

I Use it too I how I can Filter/orga my data in the cash (Looked by superbuffer)

Profilbild von Wanten
Wantenvor 17 Tagen

@grok 这个索引方式支持多字符串词组吗?

Profilbild von liprais
lipraisvor 18 Tagen

good idea,now try with chinese texts

Profilbild von Pankaj Kumar
Pankaj Kumarvor 18 Tagen

Half the teams I see bolt on Elasticsearch before they have 10k rows. Postgres was fine, Ben.

Ähnliche Videos

Big moment for Postgres! AI coding tools have been surprisingly bad at writing Postgres code. Not because the models are dumb, but because of how they learned SQL in the first place. LLMs are trained on the internet, which is full of outdated Stack Overflow answers and quick-fix tutorials. So when you ask an AI to generate a schema, it gives you something that technically runs but misses decades of Postgres evolution, like: - No GENERATED ALWAYS AS IDENTITY (added in PG10) - No expression or partial indexes - No NULLS NOT DISTINCT (PG15) - Missing CHECK constraints and proper foreign keys - Generic naming that tells you nothing But this is actually a solvable problem. You can teach AI tools to write better Postgres by giving them access to the right documentation at inference time. This exact solution is actually implemented in the newly released pg-aiguide by Tiger Data - Creators of TimescaleDB, which is an open-source MCP server that provides coding tools access to 35 years of Postgres expertise. In a gist, the MCP server enables: - Semantic search over the official PostgreSQL manual (version-aware, so it knows PG14 vs PG17 differences) - Curated skills with opinionated best practices for schema design, indexing, and constraints. I ran an experiment with Claude Code to see how well this works, and worked with the team to put this together. Prompt: "Generate a schema for an e-commerce site twice, one with the MCP server disabled, one with it enabled. Finally, run an assessment to compare the generated schemas." The run with the MCP server led to: - 420% more indexes (including partial and expression indexes) - 235% more constraints - 60% more tables (proper normalization) - 11 automation functions and triggers - Modern PG17 patterns throughout The MCP-assisted schema had proper data integrity, performance optimizations baked in, and followed naming conventions that actually make sense in production. pg-aiguide works with Claude Code, Cursor, VS Code, and any MCP-compatible tool. It's free and fully open source. I have shared the repo in the replies!

Avi Chawla

187,280 Aufrufe • vor 9 Monaten