This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: RAG

RAG: Vector Database with IVFFLAT, HNSW, DiskANN Indexes, AI & ML in SQL interface, Similarity Funcs, etc…

RAG category has 8 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
vector pgvector PGDG 0.7.4 RAG PostgreSQL vector data type and ivfflat and hnsw access methods
vectorscale pgvectorscale PIGSTY 0.4.0 RAG PostgreSQL pgvectorscale: Advanced indexing for vector data
vectorize pg_vectorize PIGSTY 0.18.3 RAG PostgreSQL The simplest way to do vector search on Postgres
pg_similarity pg_similarity PIGSTY 1.0 RAG BSD 3 support similarity queries
smlar smlar PIGSTY 1.0 RAG PostgreSQL Effective similarity search
pg_tiktoken pg_tiktoken PIGSTY 0.0.1 RAG Apache-2.0 pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres
pgml pgml PIGSTY 2.9.3 RAG MIT PostgresML: Run AL/ML workloads with SQL interface
pg4ml pg4ml PIGSTY 2.0 RAG AGPLv3 Machine learning framework for PostgreSQL

1 - vector

vector data type and ivfflat and hnsw access methods

Overview

PGDG 1st Party Extension: pgvector : vector data type and ivfflat and hnsw access methods

Information

Metadata

  • Version: 0.7.4
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgvector_$v*
  • RPM Ver : 0.7.4
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgvector
  • DEB Ver : 0.7.4
  • DEB Deps: Nil

Details

2 - vectorscale

pgvectorscale: Advanced indexing for vector data

Overview

PIGSTY 3rd Party Extension: pgvectorscale : pgvectorscale: Advanced indexing for vector data

Information

Metadata

  • Version: 0.4.0
  • PG Vers: 17,16,15,14,13
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: vector

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pgvectorscale_$v
  • RPM Ver : 0.4.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pgvectorscale
  • DEB Ver : 0.4.0
  • DEB Deps: Nil

Details

3 - vectorize

The simplest way to do vector search on Postgres

Overview

PIGSTY 3rd Party Extension: pg_vectorize : The simplest way to do vector search on Postgres

Information

Metadata

  • Version: 0.18.3
  • PG Vers: 16,15,14
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: vectorize
  • Requires: pg_cron, pgmq, vector

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_vectorize_$v
  • RPM Ver : 0.18.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-vectorize
  • DEB Ver : 0.18.3
  • DEB Deps: Nil

Details

4 - pg_similarity

support similarity queries

Overview

PIGSTY 3rd Party Extension: pg_similarity : support similarity queries

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_similarity_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-similarity
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

5 - smlar

Effective similarity search

Overview

PIGSTY 3rd Party Extension: smlar : Effective similarity search

Information

Metadata

  • Version: 1.0
  • PG Vers: 17,16,15,14,13
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: smlar_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-smlar
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

6 - pg_tiktoken

pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres

Overview

PIGSTY 3rd Party Extension: pg_tiktoken : pg_tictoken: tiktoken tokenizer for use with OpenAI models in postgres

Information

Metadata

  • Version: 0.0.1
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_tiktoken_$v
  • RPM Ver : 0.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-tiktoken
  • DEB Ver : 0.0.1
  • DEB Deps: Nil

Details

7 - pgml

PostgresML: Run AL/ML workloads with SQL interface

Overview

PIGSTY 3rd Party Extension: pgml : PostgresML: Run AL/ML workloads with SQL interface

Information

Metadata

  • Version: 2.9.3
  • PG Vers: 16,15,14
  • Need Load: Explicit Loading Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Relocatable
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: pgml
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pgml_$v
  • RPM Ver : 2.9.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pgml
  • DEB Ver : 2.9.2
  • DEB Deps: Nil

Details

8 - pg4ml

Machine learning framework for PostgreSQL

Overview

PIGSTY 3rd Party Extension: pg4ml : Machine learning framework for PostgreSQL

Information

Metadata

  • Version: 2.0
  • PG Vers: 17,16,15,14,13,12
  • Need Load: Lib Loading NOT Required
  • Need DDL: DO CREATE EXTENSION DDL
  • Relocatable: Not Relocatable
  • Trusted: Trusted, Can be created by user with CREATE Privilege
  • Schemas: N/A
  • Requires: plpgsql, tablefunc, cube, plpython3u

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg4ml_$v
  • RPM Ver : 2.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg4ml
  • DEB Ver : 2.0
  • DEB Deps: Nil

Details