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

Return to the regular view of this page.

Category: FEAT

FEAT: OpenCypher with AGE, GraphQL, JsonSchema, Hints & Hypo Index, HLL, Rum, IVM, ChemRDKit, and Message Queues,…

FEAT category has 17 available extensions:

Extension (URL) Alias Repo Version Category License LOAD DDL TRUST RELOC Description
age age PIGSTY 1.5.0 FEAT Apache-2.0 AGE graph database extension
hll hll PGDG 2.18 FEAT Apache-2.0 type for storing hyperloglog data
rum rum PGDG 1.3 FEAT PostgreSQL RUM index access method
pg_graphql pg_graphql PIGSTY 1.5.9 FEAT Apache-2.0 pg_graphql: GraphQL support
pg_jsonschema pg_jsonschema PIGSTY 0.3.3 FEAT Apache-2.0 PostgreSQL extension providing JSON Schema validation
jsquery jsquery PGDG 1.1 FEAT PostgreSQL data type for jsonb inspection
pg_hint_plan pg_hint_plan PGDG 1.6.1 FEAT BSD 3 Give PostgreSQL ability to manually force some decisions in execution plans.
hypopg hypopg PGDG 1.4.1 FEAT PostgreSQL Hypothetical indexes for PostgreSQL
index_advisor index_advisor PIGSTY 0.2.0 FEAT PostgreSQL Query index advisor
plan_filter pg_plan_filter PIGSTY 0.0.1 FEAT PostgreSQL filter statements by their execution plans.
imgsmlr imgsmlr PIGSTY 1.0 FEAT PostgreSQL Image similarity with haar
pg_ivm pg_ivm PGDG 1.8 FEAT PostgreSQL incremental view maintenance on PostgreSQL
pgmq pgmq PIGSTY 1.4.4 FEAT PostgreSQL A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
pgq pgq PGDG 3.5.1 FEAT ISC Generic queue for PostgreSQL
pg_cardano pg_cardano PIGSTY 1.0.2 FEAT MIT A suite of Cardano-related tools
rdkit rdkit PGDG 4.3.0 FEAT BSD 3 Cheminformatics functionality for PostgreSQL.
bloom bloom CONTRIB 1.0 FEAT PostgreSQL bloom access method - signature file based index

1 - age

AGE graph database extension

Overview

PIGSTY 3rd Party Extension: age : AGE graph database extension

Information

Metadata

  • Version: 1.5.0
  • PG Vers: 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: ag_catalog
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: apache-age_$v*
  • RPM Ver : 1.5.0
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-age
  • DEB Ver : 1.5.0
  • DEB Deps: Nil

Details

2 - hll

type for storing hyperloglog data

Overview

PGDG 1st Party Extension: hll : type for storing hyperloglog data

Information

Metadata

  • Version: 2.18
  • 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: PGDG
  • RPM Name: hll_$v*
  • RPM Ver : 2.18
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-hll
  • DEB Ver : 2.18
  • DEB Deps: Nil

Details

3 - rum

RUM index access method

Overview

PGDG 1st Party Extension: rum : RUM index access method

Information

Metadata

  • Version: 1.3
  • 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: rum_$v
  • RPM Ver : 1.3
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-rum
  • DEB Ver : 1.3
  • DEB Deps: Nil

Details

4 - pg_graphql

pg_graphql: GraphQL support

Overview

PIGSTY 3rd Party Extension: pg_graphql : pg_graphql: GraphQL support

Information

Metadata

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

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_graphql_$v
  • RPM Ver : 1.5.9
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-graphql
  • DEB Ver : 1.5.9
  • DEB Deps: Nil

Details

5 - pg_jsonschema

PostgreSQL extension providing JSON Schema validation

Overview

PIGSTY 3rd Party Extension: pg_jsonschema : PostgreSQL extension providing JSON Schema validation

Information

Metadata

  • Version: 0.3.3
  • 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_jsonschema_$v
  • RPM Ver : 0.3.3
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-jsonschema
  • DEB Ver : 0.3.3
  • DEB Deps: Nil

Details

6 - jsquery

data type for jsonb inspection

Overview

PGDG 1st Party Extension: jsquery : data type for jsonb inspection

Information

Metadata

  • Version: 1.1
  • 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: jsquery_$v*
  • RPM Ver : 1.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-jsquery
  • DEB Ver : 1.1
  • DEB Deps: Nil

Details

7 - pg_hint_plan

Give PostgreSQL ability to manually force some decisions in execution plans.

Overview

PGDG 1st Party Extension: pg_hint_plan : Give PostgreSQL ability to manually force some decisions in execution plans.

Information

Metadata

  • Version: 1.6.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: hint_plan
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_hint_plan_$v*
  • RPM Ver : 1.6.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pg-hint-plan
  • DEB Ver : 1.6.1
  • DEB Deps: Nil

Details

8 - hypopg

Hypothetical indexes for PostgreSQL

Overview

PGDG 1st Party Extension: hypopg : Hypothetical indexes for PostgreSQL

Information

Metadata

  • Version: 1.4.1
  • 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: hypopg_$v*
  • RPM Ver : 1.4.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-hypopg
  • DEB Ver : 1.4.1
  • DEB Deps: Nil

Details

9 - index_advisor

Query index advisor

Overview

PIGSTY 3rd Party Extension: index_advisor : Query index advisor

Information

Metadata

  • Version: 0.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: Unknown
  • Schemas: N/A
  • Requires: N/A

Packages

  • RPM Repo: PIGSTY
  • RPM Name: index_advisor_$v
  • RPM Ver : 0.2.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-index-advisor
  • DEB Ver : 0.2.0
  • DEB Deps: Nil

Details

10 - plan_filter

filter statements by their execution plans.

Overview

PIGSTY 3rd Party Extension: pg_plan_filter : filter statements by their execution plans.

Information

Metadata

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

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pg_plan_filter_$v*
  • RPM Ver : 0.0.1
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-plan-filter
  • DEB Ver : 0.0.1
  • DEB Deps: Nil

Details

11 - imgsmlr

Image similarity with haar

Overview

PIGSTY 3rd Party Extension: imgsmlr : Image similarity with haar

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: imgsmlr_$v*
  • RPM Ver : 1.0
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-imgsmlr
  • DEB Ver : 1.0
  • DEB Deps: Nil

Details

12 - pg_ivm

incremental view maintenance on PostgreSQL

Overview

PGDG 3rd Party Extension: pg_ivm : incremental view maintenance on PostgreSQL

Information

Metadata

  • Version: 1.8
  • 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: pg_catalog
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pg_ivm_$v*
  • RPM Ver : 1.8
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-ivm
  • DEB Ver : 1.9
  • DEB Deps: Nil

Details

13 - pgmq

A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

Overview

PIGSTY 3rd Party Extension: pgmq : A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

Information

Metadata

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

Packages

  • RPM Repo: PIGSTY
  • RPM Name: pgmq_$v
  • RPM Ver : 1.4.4
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pgmq
  • DEB Ver : 1.4.4
  • DEB Deps: Nil

Details

14 - pgq

Generic queue for PostgreSQL

Overview

PGDG 1st Party Extension: pgq : Generic queue for PostgreSQL

Information

Metadata

  • Version: 3.5.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: pg_catalog
  • Requires: N/A

Packages

  • RPM Repo: PGDG
  • RPM Name: pgq_$v*
  • RPM Ver : 3.5.1
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-pgq3
  • DEB Ver : 3.5
  • DEB Deps: Nil

Details

15 - pg_cardano

A suite of Cardano-related tools

Overview

PIGSTY 3rd Party Extension: pg_cardano : A suite of Cardano-related tools

Information

Metadata

  • Version: 1.0.2
  • 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_cardano_$v
  • RPM Ver : 1.0.2
  • RPM Deps: Nil
  • DEB Repo: PIGSTY
  • DEB Name: postgresql-$v-pg-cardano
  • DEB Ver : 1.0.2
  • DEB Deps: Nil

Details

16 - rdkit

Cheminformatics functionality for PostgreSQL.

Overview

PGDG 1st Party Extension: rdkit : Cheminformatics functionality for PostgreSQL.

Information

Metadata

  • Version: 4.3.0
  • PG Vers: 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: N/A
  • RPM Name: N/A
  • RPM Ver : N/A
  • RPM Deps: Nil
  • DEB Repo: PGDG
  • DEB Name: postgresql-$v-rdkit
  • DEB Ver : 4.3.0
  • DEB Deps: Nil

Details

17 - bloom

bloom access method - signature file based index

Overview

CONTRIB Built-in Extension: bloom : bloom access method - signature file based index

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: Unknown
  • Trusted: Untrusted, Require Superuser to Create
  • Schemas: N/A
  • Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details