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`

版本

类型	仓库	版本	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 仓库已经添加并启用：

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

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

安装

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

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 prioritize;

用法

来源：

prioritize 提供 PostgreSQL 后端进程的操作系统优先级控制。它适合降低指定会话的调度优先级，不是 PostgreSQL 查询调度器。

查看和调整后端

CREATE EXTENSION prioritize;
SELECT get_backend_priority(pg_backend_pid());
SELECT set_backend_priority(pg_backend_pid(), 10);

任何用户都可以查询后端优先级。PostgreSQL 超级用户可以请求调整任意后端；其他用户只能调整使用同一数据库角色的后端。

调整同角色会话

SELECT set_backend_priority(pid, get_backend_priority(pid) + 5)
FROM pg_stat_activity
WHERE usename = CURRENT_USER;

增大 nice 数值会降低操作系统调度优先级。因此，这个例子降低这些后端的优先级，不会使它们执行得更快。

权限和限制

安装需要超级用户，无需预加载或重启。操作系统权限仍然生效：普通 PostgreSQL 进程通常不能通过降低 nice 数值来提高优先级。数据库超级用户权限不等于 root 权限。批量调整前，应检查平台调度策略和进程身份。控制文件使用 SQL 版本 1.0；发行版安装包版本 1.0.4 与之不同。

prioritize

概览

版本

安装

用法

查看和调整后端

调整同角色会话

权限和限制

这个页面对您有帮助吗？