Extensions
hypopg

hypopg

hypopg : Hypothetical indexes for PostgreSQL

Overview

ID Extension Package Version Category License Language
2830
hypopg
hypopg
 1.4.2
FEAT
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
index_advisor
pg_qualstats
powa
pg_hint_plan
auto_explain
pg_stat_statements
btree_gin
pg_show_plans

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.4.2
18
17
16
15
14
13
 hypopg -
RPM
PGDG
 1.4.2
18
17
16
15
14
13
 hypopg_$v* -
DEB
PGDG
 1.4.2
18
17
16
15
14
13
 postgresql-$v-hypopg -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 1.4.2
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
el8.aarch64
PGDG 1.4.2
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
el9.x86_64
PGDG 1.4.2
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
el9.aarch64
PGDG 1.4.2
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
el10.x86_64
PGDG 1.4.2
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
el10.aarch64
PGDG 1.4.2
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
PGDG 1.4.1
d12.x86_64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
d12.aarch64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
d13.x86_64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
d13.aarch64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
u22.x86_64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
u22.aarch64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
u24.x86_64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
u24.aarch64
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
PGDG 1.4.2
Package Version OS ORG SIZE File URL
hypopg_18 1.4.2 el8.x86_64 pgdg 31.1 KiB hypopg_18-1.4.2-1PGDG.rhel8.x86_64.rpm
hypopg_18 1.4.2 el8.aarch64 pgdg 31.8 KiB hypopg_18-1.4.2-1PGDG.rhel8.aarch64.rpm
hypopg_18 1.4.2 el9.x86_64 pgdg 29.7 KiB hypopg_18-1.4.2-1PGDG.rhel9.x86_64.rpm
hypopg_18 1.4.2 el9.aarch64 pgdg 31.1 KiB hypopg_18-1.4.2-1PGDG.rhel9.aarch64.rpm
hypopg_18 1.4.2 el10.x86_64 pgdg 30.3 KiB hypopg_18-1.4.2-1PGDG.rhel10.x86_64.rpm
hypopg_18 1.4.2 el10.aarch64 pgdg 32.0 KiB hypopg_18-1.4.2-1PGDG.rhel10.aarch64.rpm
postgresql-18-hypopg 1.4.2 d12.x86_64 pgdg 57.4 KiB postgresql-18-hypopg_1.4.2-2.pgdg12+1_amd64.deb
postgresql-18-hypopg 1.4.2 d12.aarch64 pgdg 57.9 KiB postgresql-18-hypopg_1.4.2-2.pgdg12+1_arm64.deb
postgresql-18-hypopg 1.4.2 d13.x86_64 pgdg 57.5 KiB postgresql-18-hypopg_1.4.2-2.pgdg13+1_amd64.deb
postgresql-18-hypopg 1.4.2 d13.aarch64 pgdg 58.3 KiB postgresql-18-hypopg_1.4.2-2.pgdg13+1_arm64.deb
postgresql-18-hypopg 1.4.2 u22.x86_64 pgdg 59.2 KiB postgresql-18-hypopg_1.4.2-2.pgdg22.04+1_amd64.deb
postgresql-18-hypopg 1.4.2 u22.aarch64 pgdg 59.3 KiB postgresql-18-hypopg_1.4.2-2.pgdg22.04+1_arm64.deb
postgresql-18-hypopg 1.4.2 u24.x86_64 pgdg 57.4 KiB postgresql-18-hypopg_1.4.2-2.pgdg24.04+1_amd64.deb
postgresql-18-hypopg 1.4.2 u24.aarch64 pgdg 57.7 KiB postgresql-18-hypopg_1.4.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hypopg_17 1.4.1 el8.x86_64 pgdg 30.2 KiB hypopg_17-1.4.1-2PGDG.rhel8.x86_64.rpm
hypopg_17 1.4.1 el8.aarch64 pgdg 30.9 KiB hypopg_17-1.4.1-2PGDG.rhel8.aarch64.rpm
hypopg_17 1.4.1 el9.x86_64 pgdg 29.1 KiB hypopg_17-1.4.1-2PGDG.rhel9.x86_64.rpm
hypopg_17 1.4.1 el9.aarch64 pgdg 30.6 KiB hypopg_17-1.4.1-2PGDG.rhel9.aarch64.rpm
hypopg_17 1.4.1 el10.x86_64 pgdg 30.1 KiB hypopg_17-1.4.1-3PGDG.rhel10.x86_64.rpm
hypopg_17 1.4.1 el10.aarch64 pgdg 31.8 KiB hypopg_17-1.4.1-3PGDG.rhel10.aarch64.rpm
postgresql-17-hypopg 1.4.2 d12.x86_64 pgdg 57.4 KiB postgresql-17-hypopg_1.4.2-2.pgdg12+1_amd64.deb
postgresql-17-hypopg 1.4.2 d12.aarch64 pgdg 57.9 KiB postgresql-17-hypopg_1.4.2-2.pgdg12+1_arm64.deb
postgresql-17-hypopg 1.4.2 d13.x86_64 pgdg 57.6 KiB postgresql-17-hypopg_1.4.2-2.pgdg13+1_amd64.deb
postgresql-17-hypopg 1.4.2 d13.aarch64 pgdg 58.3 KiB postgresql-17-hypopg_1.4.2-2.pgdg13+1_arm64.deb
postgresql-17-hypopg 1.4.2 u22.x86_64 pgdg 72.0 KiB postgresql-17-hypopg_1.4.2-2.pgdg22.04+1_amd64.deb
postgresql-17-hypopg 1.4.2 u22.aarch64 pgdg 72.1 KiB postgresql-17-hypopg_1.4.2-2.pgdg22.04+1_arm64.deb
postgresql-17-hypopg 1.4.2 u24.x86_64 pgdg 57.3 KiB postgresql-17-hypopg_1.4.2-2.pgdg24.04+1_amd64.deb
postgresql-17-hypopg 1.4.2 u24.aarch64 pgdg 57.6 KiB postgresql-17-hypopg_1.4.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hypopg_16 1.4.1 el8.x86_64 pgdg 30.1 KiB hypopg_16-1.4.1-1PGDG.rhel8.x86_64.rpm
hypopg_16 1.4.0 el8.x86_64 pgdg 29.6 KiB hypopg_16-1.4.0-2PGDG.rhel8.x86_64.rpm
hypopg_16 1.4.1 el8.aarch64 pgdg 30.9 KiB hypopg_16-1.4.1-1PGDG.rhel8.aarch64.rpm
hypopg_16 1.4.0 el8.aarch64 pgdg 30.3 KiB hypopg_16-1.4.0-2PGDG.rhel8.aarch64.rpm
hypopg_16 1.4.1 el9.x86_64 pgdg 28.9 KiB hypopg_16-1.4.1-1PGDG.rhel9.x86_64.rpm
hypopg_16 1.4.0 el9.x86_64 pgdg 28.4 KiB hypopg_16-1.4.0-2PGDG.rhel9.x86_64.rpm
hypopg_16 1.4.1 el9.aarch64 pgdg 30.3 KiB hypopg_16-1.4.1-1PGDG.rhel9.aarch64.rpm
hypopg_16 1.4.0 el9.aarch64 pgdg 29.7 KiB hypopg_16-1.4.0-2PGDG.rhel9.aarch64.rpm
hypopg_16 1.4.1 el10.x86_64 pgdg 30.2 KiB hypopg_16-1.4.1-3PGDG.rhel10.x86_64.rpm
hypopg_16 1.4.1 el10.aarch64 pgdg 31.9 KiB hypopg_16-1.4.1-3PGDG.rhel10.aarch64.rpm
postgresql-16-hypopg 1.4.2 d12.x86_64 pgdg 57.4 KiB postgresql-16-hypopg_1.4.2-2.pgdg12+1_amd64.deb
postgresql-16-hypopg 1.4.2 d12.aarch64 pgdg 58.1 KiB postgresql-16-hypopg_1.4.2-2.pgdg12+1_arm64.deb
postgresql-16-hypopg 1.4.2 d13.x86_64 pgdg 57.7 KiB postgresql-16-hypopg_1.4.2-2.pgdg13+1_amd64.deb
postgresql-16-hypopg 1.4.2 d13.aarch64 pgdg 58.5 KiB postgresql-16-hypopg_1.4.2-2.pgdg13+1_arm64.deb
postgresql-16-hypopg 1.4.2 u22.x86_64 pgdg 72.0 KiB postgresql-16-hypopg_1.4.2-2.pgdg22.04+1_amd64.deb
postgresql-16-hypopg 1.4.2 u22.aarch64 pgdg 72.0 KiB postgresql-16-hypopg_1.4.2-2.pgdg22.04+1_arm64.deb
postgresql-16-hypopg 1.4.2 u24.x86_64 pgdg 57.3 KiB postgresql-16-hypopg_1.4.2-2.pgdg24.04+1_amd64.deb
postgresql-16-hypopg 1.4.2 u24.aarch64 pgdg 57.7 KiB postgresql-16-hypopg_1.4.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hypopg_15 1.4.1 el8.x86_64 pgdg 30.5 KiB hypopg_15-1.4.1-1PGDG.rhel8.x86_64.rpm
hypopg_15 1.4.0 el8.x86_64 pgdg 29.8 KiB hypopg_15-1.4.0-1.rhel8.x86_64.rpm
hypopg_15 1.3.1 el8.x86_64 pgdg 74.8 KiB hypopg_15-1.3.1-1.rhel8.x86_64.rpm
hypopg_15 1.4.1 el8.aarch64 pgdg 31.1 KiB hypopg_15-1.4.1-1PGDG.rhel8.aarch64.rpm
hypopg_15 1.4.0 el8.aarch64 pgdg 30.3 KiB hypopg_15-1.4.0-1.rhel8.aarch64.rpm
hypopg_15 1.3.1 el8.aarch64 pgdg 74.8 KiB hypopg_15-1.3.1-1.rhel8.aarch64.rpm
hypopg_15 1.4.1 el9.x86_64 pgdg 29.8 KiB hypopg_15-1.4.1-1PGDG.rhel9.x86_64.rpm
hypopg_15 1.4.0 el9.x86_64 pgdg 29.1 KiB hypopg_15-1.4.0-1.rhel9.x86_64.rpm
hypopg_15 1.3.1 el9.x86_64 pgdg 75.6 KiB hypopg_15-1.3.1-1.rhel9.x86_64.rpm
hypopg_15 1.4.1 el9.aarch64 pgdg 31.2 KiB hypopg_15-1.4.1-1PGDG.rhel9.aarch64.rpm
hypopg_15 1.4.0 el9.aarch64 pgdg 30.5 KiB hypopg_15-1.4.0-1.rhel9.aarch64.rpm
hypopg_15 1.3.1 el9.aarch64 pgdg 76.2 KiB hypopg_15-1.3.1-1.rhel9.aarch64.rpm
hypopg_15 1.4.1 el10.x86_64 pgdg 31.1 KiB hypopg_15-1.4.1-3PGDG.rhel10.x86_64.rpm
hypopg_15 1.4.1 el10.aarch64 pgdg 32.8 KiB hypopg_15-1.4.1-3PGDG.rhel10.aarch64.rpm
postgresql-15-hypopg 1.4.2 d12.x86_64 pgdg 57.9 KiB postgresql-15-hypopg_1.4.2-2.pgdg12+1_amd64.deb
postgresql-15-hypopg 1.4.2 d12.aarch64 pgdg 58.1 KiB postgresql-15-hypopg_1.4.2-2.pgdg12+1_arm64.deb
postgresql-15-hypopg 1.4.2 d13.x86_64 pgdg 58.0 KiB postgresql-15-hypopg_1.4.2-2.pgdg13+1_amd64.deb
postgresql-15-hypopg 1.4.2 d13.aarch64 pgdg 58.7 KiB postgresql-15-hypopg_1.4.2-2.pgdg13+1_arm64.deb
postgresql-15-hypopg 1.4.2 u22.x86_64 pgdg 72.5 KiB postgresql-15-hypopg_1.4.2-2.pgdg22.04+1_amd64.deb
postgresql-15-hypopg 1.4.2 u22.aarch64 pgdg 72.5 KiB postgresql-15-hypopg_1.4.2-2.pgdg22.04+1_arm64.deb
postgresql-15-hypopg 1.4.2 u24.x86_64 pgdg 57.9 KiB postgresql-15-hypopg_1.4.2-2.pgdg24.04+1_amd64.deb
postgresql-15-hypopg 1.4.2 u24.aarch64 pgdg 58.2 KiB postgresql-15-hypopg_1.4.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hypopg_14 1.4.1 el8.x86_64 pgdg 30.6 KiB hypopg_14-1.4.1-1PGDG.rhel8.x86_64.rpm
hypopg_14 1.4.0 el8.x86_64 pgdg 29.8 KiB hypopg_14-1.4.0-1.rhel8.x86_64.rpm
hypopg_14 1.3.1 el8.x86_64 pgdg 74.4 KiB hypopg_14-1.3.1-1.rhel8.x86_64.rpm
hypopg_14 1.4.1 el8.aarch64 pgdg 31.1 KiB hypopg_14-1.4.1-1PGDG.rhel8.aarch64.rpm
hypopg_14 1.4.0 el8.aarch64 pgdg 30.3 KiB hypopg_14-1.4.0-1.rhel8.aarch64.rpm
hypopg_14 1.3.1 el8.aarch64 pgdg 73.8 KiB hypopg_14-1.3.1-1.rhel8.aarch64.rpm
hypopg_14 1.4.1 el9.x86_64 pgdg 29.8 KiB hypopg_14-1.4.1-1PGDG.rhel9.x86_64.rpm
hypopg_14 1.4.0 el9.x86_64 pgdg 29.1 KiB hypopg_14-1.4.0-1.rhel9.x86_64.rpm
hypopg_14 1.3.1 el9.x86_64 pgdg 74.5 KiB hypopg_14-1.3.1-1.rhel9.x86_64.rpm
hypopg_14 1.4.1 el9.aarch64 pgdg 31.2 KiB hypopg_14-1.4.1-1PGDG.rhel9.aarch64.rpm
hypopg_14 1.4.0 el9.aarch64 pgdg 30.4 KiB hypopg_14-1.4.0-1.rhel9.aarch64.rpm
hypopg_14 1.3.1 el9.aarch64 pgdg 75.2 KiB hypopg_14-1.3.1-1.rhel9.aarch64.rpm
hypopg_14 1.4.1 el10.x86_64 pgdg 31.0 KiB hypopg_14-1.4.1-3PGDG.rhel10.x86_64.rpm
hypopg_14 1.4.1 el10.aarch64 pgdg 32.8 KiB hypopg_14-1.4.1-3PGDG.rhel10.aarch64.rpm
postgresql-14-hypopg 1.4.2 d12.x86_64 pgdg 57.8 KiB postgresql-14-hypopg_1.4.2-2.pgdg12+1_amd64.deb
postgresql-14-hypopg 1.4.2 d12.aarch64 pgdg 58.1 KiB postgresql-14-hypopg_1.4.2-2.pgdg12+1_arm64.deb
postgresql-14-hypopg 1.4.2 d13.x86_64 pgdg 58.0 KiB postgresql-14-hypopg_1.4.2-2.pgdg13+1_amd64.deb
postgresql-14-hypopg 1.4.2 d13.aarch64 pgdg 58.6 KiB postgresql-14-hypopg_1.4.2-2.pgdg13+1_arm64.deb
postgresql-14-hypopg 1.4.2 u22.x86_64 pgdg 71.6 KiB postgresql-14-hypopg_1.4.2-2.pgdg22.04+1_amd64.deb
postgresql-14-hypopg 1.4.2 u22.aarch64 pgdg 71.7 KiB postgresql-14-hypopg_1.4.2-2.pgdg22.04+1_arm64.deb
postgresql-14-hypopg 1.4.2 u24.x86_64 pgdg 57.9 KiB postgresql-14-hypopg_1.4.2-2.pgdg24.04+1_amd64.deb
postgresql-14-hypopg 1.4.2 u24.aarch64 pgdg 58.2 KiB postgresql-14-hypopg_1.4.2-2.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
hypopg_13 1.4.1 el8.x86_64 pgdg 30.2 KiB hypopg_13-1.4.1-1PGDG.rhel8.x86_64.rpm
hypopg_13 1.4.0 el8.x86_64 pgdg 29.5 KiB hypopg_13-1.4.0-1.rhel8.x86_64.rpm
hypopg_13 1.3.0 el8.x86_64 pgdg 72.6 KiB hypopg_13-1.3.0-1.rhel8.x86_64.rpm
hypopg_13 1.2.0 el8.x86_64 pgdg 71.8 KiB hypopg_13-1.2.0-1.rhel8.x86_64.rpm
hypopg_13 1.1.4 el8.x86_64 pgdg 67.8 KiB hypopg_13-1.1.4-1.rhel8.x86_64.rpm
hypopg_13 1.4.1 el8.aarch64 pgdg 31.1 KiB hypopg_13-1.4.1-1PGDG.rhel8.aarch64.rpm
hypopg_13 1.4.0 el8.aarch64 pgdg 30.3 KiB hypopg_13-1.4.0-1.rhel8.aarch64.rpm
hypopg_13 1.3.1 el8.aarch64 pgdg 72.4 KiB hypopg_13-1.3.1-1.rhel8.aarch64.rpm
hypopg_13 1.4.1 el9.x86_64 pgdg 29.8 KiB hypopg_13-1.4.1-1PGDG.rhel9.x86_64.rpm
hypopg_13 1.4.0 el9.x86_64 pgdg 29.2 KiB hypopg_13-1.4.0-1.rhel9.x86_64.rpm
hypopg_13 1.3.1 el9.x86_64 pgdg 73.2 KiB hypopg_13-1.3.1-1.rhel9.x86_64.rpm
hypopg_13 1.4.1 el9.aarch64 pgdg 31.3 KiB hypopg_13-1.4.1-1PGDG.rhel9.aarch64.rpm
hypopg_13 1.4.0 el9.aarch64 pgdg 30.5 KiB hypopg_13-1.4.0-1.rhel9.aarch64.rpm
hypopg_13 1.3.1 el9.aarch64 pgdg 73.9 KiB hypopg_13-1.3.1-1.rhel9.aarch64.rpm
hypopg_13 1.4.1 el10.x86_64 pgdg 31.1 KiB hypopg_13-1.4.1-3PGDG.rhel10.x86_64.rpm
hypopg_13 1.4.1 el10.aarch64 pgdg 32.8 KiB hypopg_13-1.4.1-3PGDG.rhel10.aarch64.rpm
postgresql-13-hypopg 1.4.2 d12.x86_64 pgdg 57.8 KiB postgresql-13-hypopg_1.4.2-2.pgdg12+1_amd64.deb
postgresql-13-hypopg 1.4.2 d12.aarch64 pgdg 57.5 KiB postgresql-13-hypopg_1.4.2-2.pgdg12+1_arm64.deb
postgresql-13-hypopg 1.4.2 d13.x86_64 pgdg 57.9 KiB postgresql-13-hypopg_1.4.2-2.pgdg13+1_amd64.deb
postgresql-13-hypopg 1.4.2 d13.aarch64 pgdg 57.9 KiB postgresql-13-hypopg_1.4.2-2.pgdg13+1_arm64.deb
postgresql-13-hypopg 1.4.2 u22.x86_64 pgdg 69.9 KiB postgresql-13-hypopg_1.4.2-2.pgdg22.04+1_amd64.deb
postgresql-13-hypopg 1.4.2 u22.aarch64 pgdg 70.0 KiB postgresql-13-hypopg_1.4.2-2.pgdg22.04+1_arm64.deb
postgresql-13-hypopg 1.4.2 u24.x86_64 pgdg 57.8 KiB postgresql-13-hypopg_1.4.2-2.pgdg24.04+1_amd64.deb
postgresql-13-hypopg 1.4.2 u24.aarch64 pgdg 57.7 KiB postgresql-13-hypopg_1.4.2-2.pgdg24.04+1_arm64.deb

Source

Repository
github.com/HypoPG/hypopg
 Source Tarball
hypopg-1.4.1.tar.gz
 
pig build pkg hypopg;		# build spec not ready

Install

Make sure PGDG repo available:

pig repo add pgdg -u    # add pgdg repo and update cache

Install this extension with pig:

pig install hypopg;		# install via package name, for the active PG version

pig install hypopg -v 18;   # install for PG 18
pig install hypopg -v 17;   # install for PG 17
pig install hypopg -v 16;   # install for PG 16
pig install hypopg -v 15;   # install for PG 15
pig install hypopg -v 14;   # install for PG 14
pig install hypopg -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION hypopg;
Last updated on
pg_hint_planindex_advisor