Lesson 4.1 — AI-Enabling PostgreSQL

Click on the "Edit" button in the top corner of the screen to edit your slide content.

Installed Extensions

sudo apt install postgresql-17-pgvector

CREATE EXTENSION vector;

CREATE EXTENSION "uuid-ossp";

CREATE EXTENSION pg_trgm;

CREATE EXTENSION hstore;

CREATE EXTENSION pg_stat_statements;

What Each Extension Enables

Extension

Purpose

pgvector

Embeddings & semantic search

pg_trgm

Fuzzy text search

uuid-ossp

Global identifiers

hstore

Key-value ERP metadata

pg_stat_statements

Query diagnostics

Rating
0 0

There are no comments for now.

to be the first to leave a comment.

1. Which extension supports embeddings?