prioritize

获取和设置 PostgreSQL 后端的优先级

概览

扩展包名	版本	分类	许可证	语言
`pg_prioritize`	`1.0.4`	ADMIN	PostgreSQL	C

ID	扩展名	Bin	Lib	Load	Create	Trust	Reloc	模式
5100	`prioritize`	否	是	否	是	否	是	-

相关扩展	`plan_filter` `pg_kpart` `pg_readonly` `qos` `block_copy_command` `safeupdate` `pg_command_fw` `pg_strict` `pg_hint_plan`

no pg 14 on el9

版本

类型	仓库	版本	PG 大版本	包名	依赖
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

安装

您可以直接安装 pg_prioritize 扩展包的预置二进制包，首先确保 PGDG 仓库已经添加并启用：

BASH

pig repo add pgdg -u          # 添加 PGDG 仓库并更新缓存

使用 pig 或者是 apt/yum/dnf 安装扩展：

安装

BASH

pig install pg_prioritize;          # 当前活跃 PG 版本安装

pig

BASH

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

BASH

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

BASH

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

创建扩展：

SQL

CREATE EXTENSION prioritize;

用法

prioritize: 获取和设置 PostgreSQL 后端进程的优先级

prioritize 扩展为 PostgreSQL 后端进程暴露了 getpriority() 和 setpriority() 系统调用，允许你通过 SQL 对后端进程执行 renice 操作。

获取后端优先级

SQL

SELECT get_backend_priority(pg_backend_pid());

任何用户都可以查询任意后端的优先级。

设置后端优先级

SQL

SELECT set_backend_priority(pg_backend_pid(), 10);

超级用户可以设置任意后端的优先级。非特权用户只能调整同一角色的后端。

注意：优先级只能提高（更大的数值 = 更低的 OS 优先级）。只有 root 才能降低数值优先级，而 PostgreSQL 进程不应以 root 身份运行。

批量操作

SQL

-- 将当前用户所有后端的优先级提高 5
SELECT set_backend_priority(pid, get_backend_priority(pid) + 5)
  FROM pg_stat_activity
  WHERE usename = CURRENT_USER;

意见反馈

这个页面对您有帮助吗？

感谢反馈！请告诉我们如何改进。

抱歉给您带来不便。请告诉我们如何改进。