pgvector-semantic-search

SKILL.md

Semantic search finds content by meaning rather than exact keywords. An embedding model converts text into high-dimensional vectors, where similar meanings map to nearby points. pgvector stores these vectors in PostgreSQL and uses approximate nearest neighbor (ANN) indexes to find the closest matches quickly—scaling to millions of rows without leaving the database. Store your text alongside its embedding, then que...

This guide covers pgvector setup and tuning—not embedding model selection or text chunking, which significantly affect search quality. Requires pgvector 0.8.0+ for all features (halfvec, binaryquantize, iterative scan).

Use this configuration unless you have a specific reason not to.

PostgreSQL의 텍스트 임베딩을 사용한 의미 체계 검색을 위한 pgVector 설정 및 모범 사례 출처: timescale/pg-aiguide.

원본 보기