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 15 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.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
- 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
- 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
- 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
- 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
- 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
- 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.
- 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
- 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
- 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
- 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
- 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.
- 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
- 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.
- 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
- 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
Details