# PostgreSQL Vector Search: pgvector vs Dedicated Vector Databases

> Vector database comparison guide.

---

## Content

# Overview

Vector databases are core to Agent memory.

## pgvector

```sql
CREATE EXTENSION vector;
SELECT content FROM documents ORDER BY embedding <=> $1 LIMIT 5;
```

## 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"
```