RAG
RAG: Vector Database with Ivfflat, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc...
RAG category contains 10 PostgreSQL extensions.
| ID | Extension | Package | Version | Description | 
|---|---|---|---|---|
| 1800 | vector | pgvector | 0.8.1 | vector data type and ivfflat and hnsw access methods | 
| 1810 | vchord | vchord | 0.5.1 | Vector database plugin for Postgres, written in Rust | 
| 1820 | vectorscale | pgvectorscale | 0.8.0 | Advanced indexing for vector data with DiskANN | 
| 1830 | vectorize | pg_vectorize | 0.22.2 | The simplest way to do vector search on Postgres | 
| 1840 | pg_similarity | pg_similarity | 1.0 | support similarity queries | 
| 1850 | smlar | smlar | 1.0 | Effective similarity search | 
| 1860 | pg_summarize | pg_summarize | 0.0.1 | Text Summarization using LLMs. Built using pgrx | 
| 1870 | pg_tiktoken | pg_tiktoken | 0.0.1 | tiktoken tokenizer for use with OpenAI models in postgres | 
| 1880 | pg4ml | pg4ml | 2.0 | Machine learning framework for PostgreSQL | 
| 1890 | pgml | pgml | 2.10.0 | Run AL/ML workloads with SQL interface | 
vector - 0.8.1
vector data type and ivfflat and hnsw access methods
| Extension | Website | Attributes | 
|---|---|---|
| Package | pgvector | |
| RPM | pgvector_$v* | DDL  | 
| DEB | postgresql-$v-pgvector | LIB  | 
| Language | C  | |
| License | PostgreSQL  | 
| OS/Arch | x86_64 | aarch64 | 
|---|---|---|
| el8 | 18 17 16 15 14  | 18 17 16 15 14  | 
| el9 | 18 17 16 15 14  | 18 17 16 15 14  | 
| d12 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u22 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u24 | 18 17 16 15 14  | 18 17 16 15 14  | 
vchord - 0.5.1
vectorscale - 0.8.0
Advanced indexing for vector data with DiskANN
| Extension | Website | Attributes | 
|---|---|---|
| Package | pgvectorscale | |
| RPM | pgvectorscale_$v | DDL  | 
| DEB | postgresql-$v-pgvectorscale | LIB  | 
| Language | Rust  | |
| License | PostgreSQL  | 
| OS/Arch | x86_64 | aarch64 | 
|---|---|---|
| el8 | 18 17 16 15 14  | 18 17 16 15 14  | 
| el9 | 18 17 16 15 14  | 18 17 16 15 14  | 
| d12 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u22 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u24 | 18 17 16 15 14  | 18 17 16 15 14  | 
vectorize - 0.22.2
The simplest way to do vector search on Postgres
| Extension | Website | Attributes | 
|---|---|---|
| Package | pg_vectorize | |
| RPM | pg_vectorize_$v | DDL  | 
| DEB | postgresql-$v-pg-vectorize | LIB  | 
| Language | Rust  | |
| License | PostgreSQL  | 
| OS/Arch | x86_64 | aarch64 | 
|---|---|---|
| el8 | 18 17 16 15 14  | 18 17 16 15 14  | 
| el9 | 18 17 16 15 14  | 18 17 16 15 14  | 
| d12 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u22 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u24 | 18 17 16 15 14  | 18 17 16 15 14  | 
pg_similarity - 1.0
support similarity queries
| Extension | Website | Attributes | 
|---|---|---|
| Package | pg_similarity | |
| RPM | pg_similarity_$v* | DDL  | 
| DEB | postgresql-$v-similarity | LIB  | 
| Language | C  | |
| License | BSD 3-Clause  | 
| OS/Arch | x86_64 | aarch64 | 
|---|---|---|
| el8 | 18 17 16 15 14  | 18 17 16 15 14  | 
| el9 | 18 17 16 15 14  | 18 17 16 15 14  | 
| d12 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u22 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u24 | 18 17 16 15 14  | 18 17 16 15 14  | 
smlar - 1.0
Effective similarity search
| Extension | Website | Attributes | 
|---|---|---|
| Package | smlar | |
| RPM | smlar_$v* | DDL  | 
| DEB | postgresql-$v-smlar | LIB  | 
| Language | C  | |
| License | PostgreSQL  | 
| OS/Arch | x86_64 | aarch64 | 
|---|---|---|
| el8 | 18 17 16 15 14  | 18 17 16 15 14  | 
| el9 | 18 17 16 15 14  | 18 17 16 15 14  | 
| d12 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u22 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u24 | 18 17 16 15 14  | 18 17 16 15 14  | 
pg_summarize - 0.0.1
Text Summarization using LLMs. Built using pgrx
| Extension | Website | Attributes | 
|---|---|---|
| Package | pg_summarize | |
| RPM | pg_summarize_$v | DDL  | 
| DEB | postgresql-$v-pg-summarize | LIB  | 
| Language | Rust  | |
| License | PostgreSQL  | 
| OS/Arch | x86_64 | aarch64 | 
|---|---|---|
| el8 | 18 17 16 15 14  | 18 17 16 15 14  | 
| el9 | 18 17 16 15 14  | 18 17 16 15 14  | 
| d12 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u22 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u24 | 18 17 16 15 14  | 18 17 16 15 14  | 
pg_tiktoken - 0.0.1
tiktoken tokenizer for use with OpenAI models in postgres
| Extension | Website | Attributes | 
|---|---|---|
| Package | pg_tiktoken | |
| RPM | pg_tiktoken_$v | DDL  | 
| DEB | postgresql-$v-pg-tiktoken | LIB  | 
| Language | Rust  | |
| License | Apache-2.0  | 
| OS/Arch | x86_64 | aarch64 | 
|---|---|---|
| el8 | 18 17 16 15 14  | 18 17 16 15 14  | 
| el9 | 18 17 16 15 14  | 18 17 16 15 14  | 
| d12 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u22 | 18 17 16 15 14  | 18 17 16 15 14  | 
| u24 | 18 17 16 15 14  | 18 17 16 15 14  |