prioritize

get and set the priority of PostgreSQL backends

Overview

Package	Version	Category	License	Language
`pg_prioritize`	`1.0.4`	ADMIN	PostgreSQL	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
5100	`prioritize`	No	Yes	No	Yes	No	Yes	-

Related	`plan_filter` `pg_kpart` `pg_readonly` `qos` `block_copy_command` `safeupdate` `pg_command_fw` `pg_strict` `pg_hint_plan`

no pg 14 on el9

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	PGDG	`1.0.4`	1817161514	`pg_prioritize`	-
RPM	PGDG	`1.0.4`	1817161514	`pg_prioritize_$v`	-
DEB	PGDG	`1.0.4`	1817161514	`postgresql-$v-prioritize`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 1.0.4 el8.x86_64.pg18 : pg_prioritize_18 pg_prioritize_18-1.0.4-7PGDG.rhel8.x86_64.rpm PGDG · 1.0.4 · 14.4KiB	PGDG 1.0.4 el8.x86_64.pg17 : pg_prioritize_17 pg_prioritize_17-1.0.4-5PGDG.rhel8.x86_64.rpm PGDG · 1.0.4 · 14.1KiB	PGDG 1.0.4 el8.x86_64.pg16 : pg_prioritize_16 pg_prioritize_16-1.0.4-4PGDG.rhel8.x86_64.rpm PGDG · 1.0.4 · 14.0KiB	PGDG 1.0.4 el8.x86_64.pg15 : pg_prioritize_15 pg_prioritize_15-1.0.4-2.rhel8.x86_64.rpm PGDG · 1.0.4 · 19.2KiB	PGDG 1.0.4 el8.x86_64.pg14 : pg_prioritize_14 pg_prioritize_14-1.0.4-2.rhel8.x86_64.rpm PGDG · 1.0.4 · 20.0KiB
el8.aarch64	PGDG 1.0.4 el8.aarch64.pg18 : pg_prioritize_18 pg_prioritize_18-1.0.4-7PGDG.rhel8.aarch64.rpm PGDG · 1.0.4 · 14.3KiB	PGDG 1.0.4 el8.aarch64.pg17 : pg_prioritize_17 pg_prioritize_17-1.0.4-5PGDG.rhel8.aarch64.rpm PGDG · 1.0.4 · 14.0KiB	PGDG 1.0.4 el8.aarch64.pg16 : pg_prioritize_16 pg_prioritize_16-1.0.4-4PGDG.rhel8.aarch64.rpm PGDG · 1.0.4 · 13.9KiB	PGDG 1.0.4 el8.aarch64.pg15 : pg_prioritize_15 pg_prioritize_15-1.0.4-2.rhel8.aarch64.rpm PGDG · 1.0.4 · 19.3KiB	PGDG 1.0.4 el8.aarch64.pg14 : pg_prioritize_14 pg_prioritize_14-1.0.4-2.rhel8.aarch64.rpm PGDG · 1.0.4 · 19.3KiB
el9.x86_64	PGDG 1.0.4 el9.x86_64.pg18 : pg_prioritize_18 pg_prioritize_18-1.0.4-9PGDG.rhel9.8.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_18-1.0.4-7PGDG.rhel9.x86_64.rpm PGDG · 1.0.4 · 14.1KiB	PGDG 1.0.4 el9.x86_64.pg17 : pg_prioritize_17 pg_prioritize_17-1.0.4-9PGDG.rhel9.8.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_17-1.0.4-5PGDG.rhel9.x86_64.rpm PGDG · 1.0.4 · 14.0KiB	PGDG 1.0.4 el9.x86_64.pg16 : pg_prioritize_16 pg_prioritize_16-1.0.4-9PGDG.rhel9.8.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_16-1.0.4-4PGDG.rhel9.x86_64.rpm PGDG · 1.0.4 · 13.8KiB	PGDG 1.0.4 el9.x86_64.pg15 : pg_prioritize_15 pg_prioritize_15-1.0.4-9PGDG.rhel9.8.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_15-1.0.4-2.rhel9.x86_64.rpm PGDG · 1.0.4 · 19.6KiB	PGDG 1.0.4 el9.x86_64.pg14 : pg_prioritize_14 pg_prioritize_14-1.0.4-9PGDG.rhel9.8.x86_64.rpm PGDG · 1.0.4 · 14.1KiB
el9.aarch64	PGDG 1.0.4 el9.aarch64.pg18 : pg_prioritize_18 pg_prioritize_18-1.0.4-9PGDG.rhel9.8.aarch64.rpm PGDG · 1.0.4 · 13.8KiB pg_prioritize_18-1.0.4-7PGDG.rhel9.aarch64.rpm PGDG · 1.0.4 · 13.6KiB	PGDG 1.0.4 el9.aarch64.pg17 : pg_prioritize_17 pg_prioritize_17-1.0.4-9PGDG.rhel9.8.aarch64.rpm PGDG · 1.0.4 · 13.8KiB pg_prioritize_17-1.0.4-5PGDG.rhel9.aarch64.rpm PGDG · 1.0.4 · 13.7KiB	PGDG 1.0.4 el9.aarch64.pg16 : pg_prioritize_16 pg_prioritize_16-1.0.4-9PGDG.rhel9.8.aarch64.rpm PGDG · 1.0.4 · 13.8KiB pg_prioritize_16-1.0.4-4PGDG.rhel9.aarch64.rpm PGDG · 1.0.4 · 13.3KiB	PGDG 1.0.4 el9.aarch64.pg15 : pg_prioritize_15 pg_prioritize_15-1.0.4-9PGDG.rhel9.8.aarch64.rpm PGDG · 1.0.4 · 13.8KiB pg_prioritize_15-1.0.4-2.rhel9.aarch64.rpm PGDG · 1.0.4 · 19.3KiB	PGDG 1.0.4 el9.aarch64.pg14 : pg_prioritize_14 pg_prioritize_14-1.0.4-9PGDG.rhel9.8.aarch64.rpm PGDG · 1.0.4 · 13.8KiB pg_prioritize_14-1.0.4-2.rhel9.aarch64.rpm PGDG · 1.0.4 · 19.3KiB
el10.x86_64	PGDG 1.0.4 el10.x86_64.pg18 : pg_prioritize_18 pg_prioritize_18-1.0.4-9PGDG.rhel10.2.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_18-1.0.4-7PGDG.rhel10.x86_64.rpm PGDG · 1.0.4 · 14.4KiB	PGDG 1.0.4 el10.x86_64.pg17 : pg_prioritize_17 pg_prioritize_17-1.0.4-9PGDG.rhel10.2.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_17-1.0.4-6PGDG.rhel10.x86_64.rpm PGDG · 1.0.4 · 14.3KiB	PGDG 1.0.4 el10.x86_64.pg16 : pg_prioritize_16 pg_prioritize_16-1.0.4-9PGDG.rhel10.2.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_16-1.0.4-6PGDG.rhel10.x86_64.rpm PGDG · 1.0.4 · 14.3KiB	PGDG 1.0.4 el10.x86_64.pg15 : pg_prioritize_15 pg_prioritize_15-1.0.4-9PGDG.rhel10.2.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_15-1.0.4-6PGDG.rhel10.x86_64.rpm PGDG · 1.0.4 · 14.3KiB	PGDG 1.0.4 el10.x86_64.pg14 : pg_prioritize_14 pg_prioritize_14-1.0.4-9PGDG.rhel10.2.x86_64.rpm PGDG · 1.0.4 · 14.2KiB pg_prioritize_14-1.0.4-6PGDG.rhel10.x86_64.rpm PGDG · 1.0.4 · 14.3KiB
el10.aarch64	PGDG 1.0.4 el10.aarch64.pg18 : pg_prioritize_18 pg_prioritize_18-1.0.4-9PGDG.rhel10.2.aarch64.rpm PGDG · 1.0.4 · 14.1KiB pg_prioritize_18-1.0.4-7PGDG.rhel10.aarch64.rpm PGDG · 1.0.4 · 14.2KiB	PGDG 1.0.4 el10.aarch64.pg17 : pg_prioritize_17 pg_prioritize_17-1.0.4-9PGDG.rhel10.2.aarch64.rpm PGDG · 1.0.4 · 14.1KiB pg_prioritize_17-1.0.4-6PGDG.rhel10.aarch64.rpm PGDG · 1.0.4 · 14.2KiB	PGDG 1.0.4 el10.aarch64.pg16 : pg_prioritize_16 pg_prioritize_16-1.0.4-9PGDG.rhel10.2.aarch64.rpm PGDG · 1.0.4 · 14.1KiB pg_prioritize_16-1.0.4-6PGDG.rhel10.aarch64.rpm PGDG · 1.0.4 · 14.2KiB	PGDG 1.0.4 el10.aarch64.pg15 : pg_prioritize_15 pg_prioritize_15-1.0.4-9PGDG.rhel10.2.aarch64.rpm PGDG · 1.0.4 · 14.1KiB pg_prioritize_15-1.0.4-6PGDG.rhel10.aarch64.rpm PGDG · 1.0.4 · 14.2KiB	PGDG 1.0.4 el10.aarch64.pg14 : pg_prioritize_14 pg_prioritize_14-1.0.4-9PGDG.rhel10.2.aarch64.rpm PGDG · 1.0.4 · 14.1KiB pg_prioritize_14-1.0.4-6PGDG.rhel10.aarch64.rpm PGDG · 1.0.4 · 14.2KiB
d12.x86_64	PGDG 1.0.4 d12.x86_64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg12+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d12.x86_64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg12+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d12.x86_64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg12+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d12.x86_64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg12+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d12.x86_64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg12+1_amd64.deb PGDG · 1.0.4 · 11.6KiB
d12.aarch64	PGDG 1.0.4 d12.aarch64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg12+1_arm64.deb PGDG · 1.0.4 · 11.6KiB	PGDG 1.0.4 d12.aarch64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg12+1_arm64.deb PGDG · 1.0.4 · 11.6KiB	PGDG 1.0.4 d12.aarch64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg12+1_arm64.deb PGDG · 1.0.4 · 11.6KiB	PGDG 1.0.4 d12.aarch64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg12+1_arm64.deb PGDG · 1.0.4 · 11.6KiB	PGDG 1.0.4 d12.aarch64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg12+1_arm64.deb PGDG · 1.0.4 · 11.6KiB
d13.x86_64	PGDG 1.0.4 d13.x86_64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg13+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.x86_64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg13+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.x86_64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg13+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.x86_64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg13+1_amd64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.x86_64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg13+1_amd64.deb PGDG · 1.0.4 · 11.6KiB
d13.aarch64	PGDG 1.0.4 d13.aarch64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg13+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.aarch64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg13+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.aarch64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg13+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.aarch64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg13+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 d13.aarch64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg13+1_arm64.deb PGDG · 1.0.4 · 11.7KiB
u22.x86_64	PGDG 1.0.4 u22.x86_64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb PGDG · 1.0.4 · 12.3KiB	PGDG 1.0.4 u22.x86_64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb PGDG · 1.0.4 · 12.6KiB	PGDG 1.0.4 u22.x86_64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb PGDG · 1.0.4 · 12.6KiB	PGDG 1.0.4 u22.x86_64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb PGDG · 1.0.4 · 12.6KiB	PGDG 1.0.4 u22.x86_64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg22.04+1_amd64.deb PGDG · 1.0.4 · 12.6KiB
u22.aarch64	PGDG 1.0.4 u22.aarch64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb PGDG · 1.0.4 · 12.1KiB	PGDG 1.0.4 u22.aarch64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb PGDG · 1.0.4 · 12.4KiB	PGDG 1.0.4 u22.aarch64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb PGDG · 1.0.4 · 12.3KiB	PGDG 1.0.4 u22.aarch64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb PGDG · 1.0.4 · 12.4KiB	PGDG 1.0.4 u22.aarch64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg22.04+1_arm64.deb PGDG · 1.0.4 · 12.3KiB
u24.x86_64	PGDG 1.0.4 u24.x86_64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb PGDG · 1.0.4 · 11.8KiB	PGDG 1.0.4 u24.x86_64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb PGDG · 1.0.4 · 11.8KiB	PGDG 1.0.4 u24.x86_64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb PGDG · 1.0.4 · 11.8KiB	PGDG 1.0.4 u24.x86_64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb PGDG · 1.0.4 · 11.8KiB	PGDG 1.0.4 u24.x86_64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg24.04+1_amd64.deb PGDG · 1.0.4 · 11.8KiB
u24.aarch64	PGDG 1.0.4 u24.aarch64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 u24.aarch64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 u24.aarch64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 u24.aarch64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb PGDG · 1.0.4 · 11.7KiB	PGDG 1.0.4 u24.aarch64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg24.04+1_arm64.deb PGDG · 1.0.4 · 11.7KiB
u26.x86_64	PGDG 1.0.4 u26.x86_64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg26.04+1_amd64.deb PGDG · 1.0.4 · 12.0KiB	PGDG 1.0.4 u26.x86_64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg26.04+1_amd64.deb PGDG · 1.0.4 · 12.0KiB	PGDG 1.0.4 u26.x86_64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg26.04+1_amd64.deb PGDG · 1.0.4 · 12.0KiB	PGDG 1.0.4 u26.x86_64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg26.04+1_amd64.deb PGDG · 1.0.4 · 12.0KiB	PGDG 1.0.4 u26.x86_64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg26.04+1_amd64.deb PGDG · 1.0.4 · 11.9KiB
u26.aarch64	PGDG 1.0.4 u26.aarch64.pg18 : postgresql-18-prioritize postgresql-18-prioritize_1.0.4-13.pgdg26.04+1_arm64.deb PGDG · 1.0.4 · 12.0KiB	PGDG 1.0.4 u26.aarch64.pg17 : postgresql-17-prioritize postgresql-17-prioritize_1.0.4-13.pgdg26.04+1_arm64.deb PGDG · 1.0.4 · 11.9KiB	PGDG 1.0.4 u26.aarch64.pg16 : postgresql-16-prioritize postgresql-16-prioritize_1.0.4-13.pgdg26.04+1_arm64.deb PGDG · 1.0.4 · 11.9KiB	PGDG 1.0.4 u26.aarch64.pg15 : postgresql-15-prioritize postgresql-15-prioritize_1.0.4-13.pgdg26.04+1_arm64.deb PGDG · 1.0.4 · 12.0KiB	PGDG 1.0.4 u26.aarch64.pg14 : postgresql-14-prioritize postgresql-14-prioritize_1.0.4-13.pgdg26.04+1_arm64.deb PGDG · 1.0.4 · 11.9KiB

Install

You can install pg_prioritize directly. First, make sure the PGDG repository is added and enabled:

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

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_prioritize;          # Install for current active PG version

pig

pig ext install -y pg_prioritize -v 18  # PG 18
pig ext install -y pg_prioritize -v 17  # PG 17
pig ext install -y pg_prioritize -v 16  # PG 16
pig ext install -y pg_prioritize -v 15  # PG 15
pig ext install -y pg_prioritize -v 14  # PG 14

dnf

dnf install -y pg_prioritize_18       # PG 18
dnf install -y pg_prioritize_17       # PG 17
dnf install -y pg_prioritize_16       # PG 16
dnf install -y pg_prioritize_15       # PG 15
dnf install -y pg_prioritize_14       # PG 14

apt

apt install -y postgresql-18-prioritize   # PG 18
apt install -y postgresql-17-prioritize   # PG 17
apt install -y postgresql-16-prioritize   # PG 16
apt install -y postgresql-15-prioritize   # PG 15
apt install -y postgresql-14-prioritize   # PG 14

Create Extension:

CREATE EXTENSION prioritize;

Usage

prioritize: get and set the priority of PostgreSQL backends

The prioritize extension exposes getpriority() and setpriority() system calls for PostgreSQL backends, allowing you to renice backend processes from SQL.

Get Backend Priority

SELECT get_backend_priority(pg_backend_pid());

Any user may query the priority of any backend.

Set Backend Priority

SELECT set_backend_priority(pg_backend_pid(), 10);

Superusers can set the priority of any backend. Unprivileged users can only adjust backends with the same role.

Note: priority can only be raised (higher numeric value = lower OS priority). Only root can lower the numeric priority value, and PostgreSQL processes should not run as root.

Batch Operations

-- Increase priority of all current user's backends by 5
SELECT set_backend_priority(pid, get_backend_priority(pid) + 5)
  FROM pg_stat_activity
  WHERE usename = CURRENT_USER;

prioritize

Overview

Version

Install

Usage

Get Backend Priority

Set Backend Priority

Batch Operations

Was this page helpful?