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,…

1: age
2: hll
3: rum
4: pg_graphql
5: pg_jsonschema
6: jsquery
7: pg_hint_plan
8: hypopg
9: index_advisor
10: imgsmlr
11: pg_ivm
12: pgmq
13: pgq
14: rdkit
15: bloom

FEAT category has 15 available extensions:

Extension (URL)	Alias	Repo	Version	Category	License	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.7	`FEAT`	Apache-2.0	pg_graphql: GraphQL support
pg_jsonschema	`pg_jsonschema`	PIGSTY	0.3.1	`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.0	`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
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.2.1	`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
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

ID: 1700
Name: age
Alias: age
Category: FEAT
Website: https://github.com/apache/age
License: Apache-2.0 License
Language: Unknown
Tags: N/A
Comment: 无

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

ID: 1710
Name: hll
Alias: hll
Category: FEAT
Website: https://github.com/citusdata/postgresql-hll
License: Apache-2.0 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 2.18
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: 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

ID: 1720
Name: rum
Alias: rum
Category: FEAT
Website: https://github.com/postgrespro/rum
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.3
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: 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

ID: 1730
Name: pg_graphql
Alias: pg_graphql
Category: FEAT
Website: https://github.com/supabase/pg_graphql
License: Apache-2.0 License
Language: Rust
Tags: pgrx, supabase
Comment: 无

Metadata

Version: 1.5.7
PG Vers: 16,15
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.7
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-graphql
DEB Ver : 1.5.7
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

ID: 1750
Name: pg_jsonschema
Alias: pg_jsonschema
Category: FEAT
Website: https://github.com/supabase/pg_jsonschema
License: Apache-2.0 License
Language: Rust
Tags: pgrx, supabase
Comment: 无

Metadata

Version: 0.3.1
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: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_jsonschema_$v
RPM Ver : 0.3.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-jsonschema
DEB Ver : 0.3.1
DEB Deps: Nil

Details

6 - jsquery

data type for jsonb inspection

Overview

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

Information

ID: 1760
Name: jsquery
Alias: jsquery
Category: FEAT
Website: https://github.com/postgrespro/jsquery
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.1
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: 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

ID: 1770
Name: pg_hint_plan
Alias: pg_hint_plan
Category: FEAT
Website: https://github.com/ossc-db/pg_hint_plan
License: BSD 3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

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

Packages

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

Details

8 - hypopg

Hypothetical indexes for PostgreSQL

Overview

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

Information

ID: 1780
Name: hypopg
Alias: hypopg
Category: FEAT
Website: https://github.com/HypoPG/hypopg
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.4.1
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: 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

ID: 1790
Name: index_advisor
Alias: index_advisor
Category: FEAT
Website: https://github.com/supabase/index_advisor
License: PostgreSQL License
Language: Pure SQL
Tags: supabase
Comment: 无

Metadata

Version: 0.2.0
PG Vers: 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 - imgsmlr

Image similarity with haar

Overview

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

Information

ID: 1800
Name: imgsmlr
Alias: imgsmlr
Category: FEAT
Website: https://github.com/postgrespro/imgsmlr
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.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: 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

11 - pg_ivm

incremental view maintenance on PostgreSQL

Overview

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

Information

ID: 1810
Name: pg_ivm
Alias: pg_ivm
Category: FEAT
Website: https://github.com/sraoss/pg_ivm
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.8
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: 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.8
DEB Deps: Nil

Details

12 - 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

ID: 1820
Name: pgmq
Alias: pgmq
Category: FEAT
Website: https://github.com/tembo-io/pgmq
License: PostgreSQL License
Language: Rust
Tags: pgrx
Comment: 无

Metadata

Version: 1.2.1
PG Vers: 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.2.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgmq
DEB Ver : 1.2.1
DEB Deps: Nil

Details

13 - pgq

Generic queue for PostgreSQL

Overview

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

Information

ID: 1830
Name: pgq
Alias: pgq
Category: FEAT
Website: https://github.com/pgq/pgq
License: ISC License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 3.5.1
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: 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

14 - rdkit

Cheminformatics functionality for PostgreSQL.

Overview

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

Information

ID: 1840
Name: rdkit
Alias: rdkit
Category: FEAT
Website: https://github.com/rdkit/rdkit
License: BSD 3 License
Language: Unknown
Tags: N/A
Comment: 无

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

15 - bloom

bloom access method - signature file based index

Overview

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

Information

ID: 1990
Name: bloom
Alias: bloom
Category: FEAT
Website: https://www.postgresql.org/docs/current/bloom.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 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