Nandling

Extensions

Two lists. The first is what you can CREATE EXTENSION for. The second is what is not on this Postgres. PostgreSQL’s contrib list is the long catalog of the stock modules. pgvector is the vector one.

Supported

These are installed. CREATE EXTENSION turns one on for the database you are connected to.

  • vector — a small vector index. Not a place to park a whole corpus. pgvector.
  • pg_trgm, fuzzystrmatch, unaccent — similarity and text search helpers.
  • pgcrypto, uuid-ossp — crypto helpers and UUIDs.
  • hstore, citext, ltree, intarray — extra data types.
  • cube, earthdistance — points and distances.
  • btree_gin, btree_gist — index operator classes.
  • bloom — a bloom index.
  • tablefunc — crosstab and the rest of that module.
  • pg_stat_statements, pg_buffercache, sslinfo — what the server is doing.

Not supported

These are not installed. They are large libraries, or they need another program running beside Postgres. This database stays small, so they are not part of it.

  • PostGIS
  • TimescaleDB
  • pg_cron
  • Citus
  • VectorChord
  • pgai
  • PostgresML
  • plpython, plperl, pltcl
  • pg_partman
  • hypopg
  • rum
  • Apache AGE

vector is the vector support. A second vector engine is not installed beside it.

Quick start · All contrib modules · pgvector