How to Enable pgvector on Neon

How to fix it

// try these in order, the most common fix is first

1. FIX 1Enable

   Copy steps
   1. 01Run CREATE EXTENSION IF NOT EXISTS vector; in SQL Editor or psql
   2. 02Repeat in each database that stores vectors
   Did this fix it? Yes No

2. FIX 2Verify

   Copy steps
   1. 01SELECT extname, extversion FROM pg_extension WHERE extname = 'vector';
   2. 02Neon supports the latest version plus one behind, install one with CREATE EXTENSION vector VERSION '0.7.4';
   Did this fix it? Yes No

3. FIX 3Index builds

   1. 01SET maintenance_work_mem near your working set but under about 50 to 60 percent of RAM
   Did this fix it? Yes No

Symptoms

Vector type missing in a Neon database.

Why it happens

• C-01Extension installed per database, not per project

// this guide also covers

• enable pgvector neon
• neon create extension vector

Other pgvector errors

• pgvector Error: extension "vector" is not available
• pgvector HNSW Index Build Slow
• pgvector "operator does not exist: vector <=>" Error
• pgvector Dimension Limit: Cannot Index More Than 2000 Dimensions
• pgvector "different vector dimensions" Error
• pgvector Query Returns Fewer Results Than LIMIT With Filter
• pgvector Index Not Being Used
• pgvector HNSW Build Out of Memory or Shared Memory Error