Alex Jacobs personal blog

The Case Against PGVector

alex-jacobs.com published 2025-10-2912 min read

The real limitations of pgvector in production: index choice between IVFFlat and HNSW, why real-time search is hard, pre- vs post-filtering pain, how performance degrades at scale, and when a dedicated vector database is the better call.

Points

381

HN comments

137

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2025

Related posts from the same era

ICE using Palantir tool that feeds on Medicaid data

EFF Deeplinks20261,475 points969 comments details

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

Tracking down the 16-year-old WAL-reset SQLite bug

Tailscale Blog20261,223 points239 commentscited by 3 details

GPT in 500 Lines of SQL

Explain Extended20241,111 points76 commentscited by 3 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

PGSimCity - How PostgreSQL Works

Nnikolays.github.io2026930 points90 comments details