# Pgvector 16

Pgvector 16 is an extension for the Postgres database that allows it to store and search complex data, such as images or text, based on their meaning. It is open source and self-hosted, installable on Docker Hub and Unraid.

Canonical page: https://ourlocalhost.com/app/5240/pgvector-16

## Description

Pgvector is an extension for the Postgres database that allows it to store and search complex data, such as images or text, based on their meaning. It enables apps to offer “smart” features like personalised recommendations and more human-like search results by finding items that are similar.

## Platform availability

Available on 1 of 10 platforms: Unraid.

## Health score

75/100 (Good), based on 4 of 5 factors.
- Maintained: 100 (last commit 3 days ago)
- Popular: 88 (23,728 GitHub stars)
- Easy to install: 15 (0 install platforms, install notes)
- Security check: 69 (no serious findings, CI, OpenSSF Scorecard 4.4/10)

## Links

- GitHub: https://github.com/pgvector/pgvector
- Docker Hub: https://hub.docker.com/r/pgvector
- Unraid: https://ca.unraid.net/apps?q=pgvector-16&app=vbzj04

## Common questions

### Why can’t PostgreSQL 16 load the pgvector extension after installing the package?

Use the pgvector package whose version number matches the Postgres server, for example postgresql-16-pgvector for Postgres 16. If the numbers do not match, the database cannot load the extension.

### Why does building pgvector from source fail with 'postgres.h not found'?

Install the matching Postgres development files first, such as postgresql-server-dev-16 for Postgres 16. They provide the header files needed for the build.

### How much RAM should I allow for pgvector’s HNSW index?

Plan for about 8 GB in practice, because the HNSW index wants to be resident in memory.

### Can pgvector be used as the vector store in a self-hosted RAG app?

A self-hosted retrieval-augmented chatbot can use pgvector for the vector schema, embedding pipeline, and semantic search. It can also support a streaming answer endpoint.

---
Source: Our Local Host (https://ourlocalhost.com/app/5240/pgvector-16), the self-hosted and open-source app directory.
