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 |