Extensions
prioritize

prioritize

pg_prioritize : get and set the priority of PostgreSQL backends

Overview

ID Extension Package Version Category License Language
5090
prioritize
pg_prioritize
 1.0.4
ADMIN
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
pg_proctab
pg_background
system_stats
pgnodemx
pg_wait_sampling
pg_repack
pg_rewrite
pg_squeeze

no pg 14,13,12 on el9

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PGDG
 1.0.4
18
17
16
15
14
13
 pg_prioritize -
RPM
PGDG
 1.0.4
18
17
16
15
14
13
 pg_prioritize_$v* -
DEB
PGDG
 1.0.4
18
17
16
15
14
13
 postgresql-$v-prioritize -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
el8.aarch64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
el9.x86_64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
MISS
MISS
el9.aarch64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
el10.x86_64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
el10.aarch64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
d12.x86_64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
d12.aarch64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
d13.x86_64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
d13.aarch64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
u22.x86_64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
u22.aarch64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
u24.x86_64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
u24.aarch64
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
PGDG 1.0.4
Package Version OS ORG SIZE File URL
pg_prioritize_18 1.0.4 el8.x86_64 pgdg 14.4 KiB pg_prioritize_18-1.0.4-7PGDG.rhel8.x86_64.rpm
pg_prioritize_18 1.0.4 el8.aarch64 pgdg 14.3 KiB pg_prioritize_18-1.0.4-7PGDG.rhel8.aarch64.rpm
pg_prioritize_18 1.0.4 el9.x86_64 pgdg 14.1 KiB pg_prioritize_18-1.0.4-7PGDG.rhel9.x86_64.rpm
pg_prioritize_18 1.0.4 el9.aarch64 pgdg 13.6 KiB pg_prioritize_18-1.0.4-7PGDG.rhel9.aarch64.rpm
pg_prioritize_18 1.0.4 el10.x86_64 pgdg 14.4 KiB pg_prioritize_18-1.0.4-7PGDG.rhel10.x86_64.rpm
pg_prioritize_18 1.0.4 el10.aarch64 pgdg 14.2 KiB pg_prioritize_18-1.0.4-7PGDG.rhel10.aarch64.rpm
postgresql-18-prioritize 1.0.4 d12.x86_64 pgdg 11.7 KiB postgresql-18-prioritize_1.0.4-13.pgdg12+1_amd64.deb
postgresql-18-prioritize 1.0.4 d12.aarch64 pgdg 11.6 KiB postgresql-18-prioritize_1.0.4-13.pgdg12+1_arm64.deb
postgresql-18-prioritize 1.0.4 d13.x86_64 pgdg 11.7 KiB postgresql-18-prioritize_1.0.4-13.pgdg13+1_amd64.deb
postgresql-18-prioritize 1.0.4 d13.aarch64 pgdg 11.7 KiB postgresql-18-prioritize_1.0.4-13.pgdg13+1_arm64.deb
postgresql-18-prioritize 1.0.4 u22.x86_64 pgdg 12.3 KiB postgresql-18-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb
postgresql-18-prioritize 1.0.4 u22.aarch64 pgdg 12.1 KiB postgresql-18-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb
postgresql-18-prioritize 1.0.4 u24.x86_64 pgdg 11.8 KiB postgresql-18-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb
postgresql-18-prioritize 1.0.4 u24.aarch64 pgdg 11.7 KiB postgresql-18-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_prioritize_17 1.0.4 el8.x86_64 pgdg 14.1 KiB pg_prioritize_17-1.0.4-5PGDG.rhel8.x86_64.rpm
pg_prioritize_17 1.0.4 el8.aarch64 pgdg 14.0 KiB pg_prioritize_17-1.0.4-5PGDG.rhel8.aarch64.rpm
pg_prioritize_17 1.0.4 el9.x86_64 pgdg 14.0 KiB pg_prioritize_17-1.0.4-5PGDG.rhel9.x86_64.rpm
pg_prioritize_17 1.0.4 el9.aarch64 pgdg 13.7 KiB pg_prioritize_17-1.0.4-5PGDG.rhel9.aarch64.rpm
pg_prioritize_17 1.0.4 el10.x86_64 pgdg 14.3 KiB pg_prioritize_17-1.0.4-6PGDG.rhel10.x86_64.rpm
pg_prioritize_17 1.0.4 el10.aarch64 pgdg 14.2 KiB pg_prioritize_17-1.0.4-6PGDG.rhel10.aarch64.rpm
postgresql-17-prioritize 1.0.4 d12.x86_64 pgdg 11.7 KiB postgresql-17-prioritize_1.0.4-13.pgdg12+1_amd64.deb
postgresql-17-prioritize 1.0.4 d12.aarch64 pgdg 11.6 KiB postgresql-17-prioritize_1.0.4-13.pgdg12+1_arm64.deb
postgresql-17-prioritize 1.0.4 d13.x86_64 pgdg 11.7 KiB postgresql-17-prioritize_1.0.4-13.pgdg13+1_amd64.deb
postgresql-17-prioritize 1.0.4 d13.aarch64 pgdg 11.7 KiB postgresql-17-prioritize_1.0.4-13.pgdg13+1_arm64.deb
postgresql-17-prioritize 1.0.4 u22.x86_64 pgdg 12.6 KiB postgresql-17-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb
postgresql-17-prioritize 1.0.4 u22.aarch64 pgdg 12.4 KiB postgresql-17-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb
postgresql-17-prioritize 1.0.4 u24.x86_64 pgdg 11.8 KiB postgresql-17-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb
postgresql-17-prioritize 1.0.4 u24.aarch64 pgdg 11.7 KiB postgresql-17-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_prioritize_16 1.0.4 el8.x86_64 pgdg 14.0 KiB pg_prioritize_16-1.0.4-4PGDG.rhel8.x86_64.rpm
pg_prioritize_16 1.0.4 el8.aarch64 pgdg 13.9 KiB pg_prioritize_16-1.0.4-4PGDG.rhel8.aarch64.rpm
pg_prioritize_16 1.0.4 el9.x86_64 pgdg 13.8 KiB pg_prioritize_16-1.0.4-4PGDG.rhel9.x86_64.rpm
pg_prioritize_16 1.0.4 el9.aarch64 pgdg 13.3 KiB pg_prioritize_16-1.0.4-4PGDG.rhel9.aarch64.rpm
pg_prioritize_16 1.0.4 el10.x86_64 pgdg 14.3 KiB pg_prioritize_16-1.0.4-6PGDG.rhel10.x86_64.rpm
pg_prioritize_16 1.0.4 el10.aarch64 pgdg 14.2 KiB pg_prioritize_16-1.0.4-6PGDG.rhel10.aarch64.rpm
postgresql-16-prioritize 1.0.4 d12.x86_64 pgdg 11.7 KiB postgresql-16-prioritize_1.0.4-13.pgdg12+1_amd64.deb
postgresql-16-prioritize 1.0.4 d12.aarch64 pgdg 11.6 KiB postgresql-16-prioritize_1.0.4-13.pgdg12+1_arm64.deb
postgresql-16-prioritize 1.0.4 d13.x86_64 pgdg 11.7 KiB postgresql-16-prioritize_1.0.4-13.pgdg13+1_amd64.deb
postgresql-16-prioritize 1.0.4 d13.aarch64 pgdg 11.7 KiB postgresql-16-prioritize_1.0.4-13.pgdg13+1_arm64.deb
postgresql-16-prioritize 1.0.4 u22.x86_64 pgdg 12.6 KiB postgresql-16-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb
postgresql-16-prioritize 1.0.4 u22.aarch64 pgdg 12.3 KiB postgresql-16-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb
postgresql-16-prioritize 1.0.4 u24.x86_64 pgdg 11.8 KiB postgresql-16-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb
postgresql-16-prioritize 1.0.4 u24.aarch64 pgdg 11.7 KiB postgresql-16-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_prioritize_15 1.0.4 el8.x86_64 pgdg 19.2 KiB pg_prioritize_15-1.0.4-2.rhel8.x86_64.rpm
pg_prioritize_15 1.0.4 el8.aarch64 pgdg 19.3 KiB pg_prioritize_15-1.0.4-2.rhel8.aarch64.rpm
pg_prioritize_15 1.0.4 el9.x86_64 pgdg 19.6 KiB pg_prioritize_15-1.0.4-2.rhel9.x86_64.rpm
pg_prioritize_15 1.0.4 el9.aarch64 pgdg 19.3 KiB pg_prioritize_15-1.0.4-2.rhel9.aarch64.rpm
pg_prioritize_15 1.0.4 el10.x86_64 pgdg 14.3 KiB pg_prioritize_15-1.0.4-6PGDG.rhel10.x86_64.rpm
pg_prioritize_15 1.0.4 el10.aarch64 pgdg 14.2 KiB pg_prioritize_15-1.0.4-6PGDG.rhel10.aarch64.rpm
postgresql-15-prioritize 1.0.4 d12.x86_64 pgdg 11.7 KiB postgresql-15-prioritize_1.0.4-13.pgdg12+1_amd64.deb
postgresql-15-prioritize 1.0.4 d12.aarch64 pgdg 11.6 KiB postgresql-15-prioritize_1.0.4-13.pgdg12+1_arm64.deb
postgresql-15-prioritize 1.0.4 d13.x86_64 pgdg 11.7 KiB postgresql-15-prioritize_1.0.4-13.pgdg13+1_amd64.deb
postgresql-15-prioritize 1.0.4 d13.aarch64 pgdg 11.7 KiB postgresql-15-prioritize_1.0.4-13.pgdg13+1_arm64.deb
postgresql-15-prioritize 1.0.4 u22.x86_64 pgdg 12.6 KiB postgresql-15-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb
postgresql-15-prioritize 1.0.4 u22.aarch64 pgdg 12.4 KiB postgresql-15-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb
postgresql-15-prioritize 1.0.4 u24.x86_64 pgdg 11.8 KiB postgresql-15-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb
postgresql-15-prioritize 1.0.4 u24.aarch64 pgdg 11.7 KiB postgresql-15-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_prioritize_14 1.0.4 el8.x86_64 pgdg 20.0 KiB pg_prioritize_14-1.0.4-2.rhel8.x86_64.rpm
pg_prioritize_14 1.0.4 el8.aarch64 pgdg 19.3 KiB pg_prioritize_14-1.0.4-2.rhel8.aarch64.rpm
pg_prioritize_14 1.0.4 el9.aarch64 pgdg 19.3 KiB pg_prioritize_14-1.0.4-2.rhel9.aarch64.rpm
pg_prioritize_14 1.0.4 el10.x86_64 pgdg 14.3 KiB pg_prioritize_14-1.0.4-6PGDG.rhel10.x86_64.rpm
pg_prioritize_14 1.0.4 el10.aarch64 pgdg 14.2 KiB pg_prioritize_14-1.0.4-6PGDG.rhel10.aarch64.rpm
postgresql-14-prioritize 1.0.4 d12.x86_64 pgdg 11.6 KiB postgresql-14-prioritize_1.0.4-13.pgdg12+1_amd64.deb
postgresql-14-prioritize 1.0.4 d12.aarch64 pgdg 11.6 KiB postgresql-14-prioritize_1.0.4-13.pgdg12+1_arm64.deb
postgresql-14-prioritize 1.0.4 d13.x86_64 pgdg 11.6 KiB postgresql-14-prioritize_1.0.4-13.pgdg13+1_amd64.deb
postgresql-14-prioritize 1.0.4 d13.aarch64 pgdg 11.7 KiB postgresql-14-prioritize_1.0.4-13.pgdg13+1_arm64.deb
postgresql-14-prioritize 1.0.4 u22.x86_64 pgdg 12.6 KiB postgresql-14-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb
postgresql-14-prioritize 1.0.4 u22.aarch64 pgdg 12.3 KiB postgresql-14-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb
postgresql-14-prioritize 1.0.4 u24.x86_64 pgdg 11.8 KiB postgresql-14-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb
postgresql-14-prioritize 1.0.4 u24.aarch64 pgdg 11.7 KiB postgresql-14-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb
Package Version OS ORG SIZE File URL
pg_prioritize_13 1.0.4 el8.x86_64 pgdg 19.5 KiB pg_prioritize_13-1.0.4-1.rhel8.x86_64.rpm
pg_prioritize_13 1.0.4 el8.aarch64 pgdg 19.1 KiB pg_prioritize_13-1.0.4-2.rhel8.aarch64.rpm
pg_prioritize_13 1.0.4 el9.aarch64 pgdg 19.0 KiB pg_prioritize_13-1.0.4-2.rhel9.aarch64.rpm
pg_prioritize_13 1.0.4 el10.x86_64 pgdg 14.3 KiB pg_prioritize_13-1.0.4-6PGDG.rhel10.x86_64.rpm
pg_prioritize_13 1.0.4 el10.aarch64 pgdg 14.1 KiB pg_prioritize_13-1.0.4-6PGDG.rhel10.aarch64.rpm
postgresql-13-prioritize 1.0.4 d12.x86_64 pgdg 11.6 KiB postgresql-13-prioritize_1.0.4-13.pgdg12+1_amd64.deb
postgresql-13-prioritize 1.0.4 d12.aarch64 pgdg 11.6 KiB postgresql-13-prioritize_1.0.4-13.pgdg12+1_arm64.deb
postgresql-13-prioritize 1.0.4 d13.x86_64 pgdg 11.6 KiB postgresql-13-prioritize_1.0.4-13.pgdg13+1_amd64.deb
postgresql-13-prioritize 1.0.4 d13.aarch64 pgdg 11.6 KiB postgresql-13-prioritize_1.0.4-13.pgdg13+1_arm64.deb
postgresql-13-prioritize 1.0.4 u22.x86_64 pgdg 12.4 KiB postgresql-13-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb
postgresql-13-prioritize 1.0.4 u22.aarch64 pgdg 12.2 KiB postgresql-13-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb
postgresql-13-prioritize 1.0.4 u24.x86_64 pgdg 11.7 KiB postgresql-13-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb
postgresql-13-prioritize 1.0.4 u24.aarch64 pgdg 11.6 KiB postgresql-13-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb

Source

Repository
github.com/schmiddy/pg_prioritize

Install

Make sure PGDG repo available:

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

Install this extension with pig:

pig install pg_prioritize;		# install via package name, for the active PG version
pig install prioritize;		# install by extension name, for the current active PG version

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

Create this extension with:

CREATE EXTENSION prioritize;
Last updated on
ddlxpg_checksums