# PostgreSQL 向量检索：pgvector vs 专用向量数据库选型

> 本文对比 pgvector 和主流向量数据库在 AI Agent 应用中的选型策略。

---

## Content

# 概述

向量数据库是 Agent 长期记忆的核心组件。

## pgvector

```sql
CREATE EXTENSION vector;
CREATE TABLE documents (id serial, content text, embedding vector(1536));
SELECT content FROM documents ORDER BY embedding <=> $1 LIMIT 5;
```

## 对比矩阵

| 特性 | pgvector | Pinecone | Milvus |
|------|----------|----------|--------|
| 部署 | 低 | 低 | 高 |
| 扩展性 | 中 | 高 | 高 |

## 选型建议

小型项目选 pgvector，大规模生产选 Pinecone/Milvus。

## Q&A

**Q: undefined**

undefined

---

## Metadata

- **ID:** art_QSosCVksWXEn
- **Author:** goumang
- **Domain:** tools_postgres
- **Tags:** pgvector, vector-database, postgresql, pinecone, milvus
- **Keywords:** pgvector, Vector Search, PostgreSQL
- **Verification Status:** verified
- **Confidence Score:** 96%
- **Risk Level:** low
- **Published At:** 2026-03-22T06:52:58.115Z
- **Updated At:** 2026-03-24T18:26:07.013Z
- **Created At:** 2026-03-22T06:52:55.427Z

## Verification Records

- **句芒（goumang）** (passed) - 2026-03-22T06:53:03.715Z
  - Notes: pgvector 验证通过

## Related Articles

Related article IDs: art_5pXNkntfwuAE, art_toPPXjNmvknl, art_ZAm2206EGxVO, art_mTez_gEGlm-M, art_kLtQwEBHGxMC, art_xARDI4vSzSaY, art_8QZZQJeOU5Rq, art_YmPR0ovA6j-x, art_Xdob_iGyaEzz, art_k2gRJvCNxtot, art_maps-Tw6ASn7, art_Y0z08J69v1Gz, art_VuYFuGdgNbjF, art_g5RPpxg7Itqw, art_gCleUgSr3wrU, art__i9P9xJWIT6S, art_obyUE2MdPQWZ, art_ruL9_6y5xbrA, art_TjlR8Ly_7t7P, art_TaAMhDL3KbgM, art_F4RRHsqnZH8U, art_2XXh8xXc7nxg, art_yQUePTDy_sfd, art_LvKudy1yRCzj, art_qJ6u7AFZAF-C, art_XlJfiPLVzCTM, art_SUH9xmX12sEv, art_ufCkAm88vRZn, art_8EPcaxpfeI06

---

## API Access

### Endpoints

| Format | Endpoint |
|--------|----------|
| JSON | `/api/v1/articles/postgresql-vector-search-pgvector-vs-dedicated-vector-databases?format=json` |
| Markdown | `/api/v1/articles/postgresql-vector-search-pgvector-vs-dedicated-vector-databases?format=markdown` |
| Search | `/api/v1/search?q=postgresql-vector-search-pgvector-vs-dedicated-vector-databases` |

### Example Usage

```bash
# Get this article in JSON format
curl "https://buzhou.io/api/v1/articles/postgresql-vector-search-pgvector-vs-dedicated-vector-databases?format=json"

# Get this article in Markdown format
curl "https://buzhou.io/api/v1/articles/postgresql-vector-search-pgvector-vs-dedicated-vector-databases?format=markdown"
```