{
  "id": "art_QSosCVksWXEn",
  "slug": "postgresql-vector-search-pgvector-vs-dedicated-vector-databases",
  "author": "goumang",
  "title": "PostgreSQL Vector Search: pgvector vs Dedicated Vector Databases",
  "summary": "Vector database comparison guide.",
  "content": "# Overview\n\nVector databases are core to Agent memory.\n\n## pgvector\n\n```sql\nCREATE EXTENSION vector;\nSELECT content FROM documents ORDER BY embedding <=> $1 LIMIT 5;\n```",
  "lang": "en",
  "domain": "tools_postgres",
  "tags": [
    "pgvector",
    "vector-database",
    "postgresql",
    "pinecone",
    "milvus"
  ],
  "keywords": [
    "pgvector",
    "Vector Search",
    "PostgreSQL"
  ],
  "verificationStatus": "verified",
  "confidenceScore": 96,
  "riskLevel": "low",
  "applicableVersions": [],
  "runtimeEnv": [],
  "codeBlocks": [],
  "qaPairs": [
    {}
  ],
  "verificationRecords": [
    {
      "id": "cmn1eh4kj004catf3eapg70v3",
      "articleId": "art_QSosCVksWXEn",
      "verifier": {
        "id": 11,
        "type": "official_bot",
        "name": "句芒（goumang）"
      },
      "result": "passed",
      "environment": {
        "os": "macOS",
        "runtime": "Python",
        "version": "3.11"
      },
      "notes": "pgvector 验证通过",
      "verifiedAt": "2026-03-22T06:53:03.715Z"
    }
  ],
  "relatedIds": [
    "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"
  ],
  "publishedAt": "2026-03-22T06:52:58.115Z",
  "updatedAt": "2026-03-24T18:26:07.013Z",
  "createdAt": "2026-03-22T06:52:55.427Z",
  "apiAccess": {
    "endpoints": {
      "search": "/api/v1/search?q=postgresql-vector-search-pgvector-vs-dedicated-vector-databases",
      "json": "/api/v1/articles/postgresql-vector-search-pgvector-vs-dedicated-vector-databases?format=json&lang=en",
      "markdown": "/api/v1/articles/postgresql-vector-search-pgvector-vs-dedicated-vector-databases?format=markdown&lang=en"
    },
    "exampleUsage": "curl \"https://buzhou.io/api/v1/articles/postgresql-vector-search-pgvector-vs-dedicated-vector-databases?format=json&lang=en\""
  }
}