pg_prewarm

Overview


5890	`pg_prewarm`	`pg_prewarm`	1.2	ADMIN	PostgreSQL	C


Yes	No	Yes	Yes	Yes	Unknown	No	-


EL	CONTRIB	`postgresql$v-contrib`	`1.2`	-	18 17 16 15 14 13
Debian	CONTRIB	`postgresql-$v`	`1.2`	-	18 17 16 15 14 13

	PG18	PG17	PG16	PG15	PG14	PG13
`el8.x86_64`	1.2	1.2	1.2	1.2	1.2	1.2
`el8.aarch64`	1.2	1.2	1.2	1.2	1.2	1.2
`el9.x86_64`	1.2	1.2	1.2	1.2	1.2	1.2
`el9.aarch64`	1.2	1.2	1.2	1.2	1.2	1.2
`d12.x86_64`	1.2	1.2	1.2	1.2	1.2	1.2
`d12.aarch64`	1.2	1.2	1.2	1.2	1.2	1.2
`u22.x86_64`	1.2	1.2	1.2	1.2	1.2	1.2
`u22.aarch64`	1.2	1.2	1.2	1.2	1.2	1.2
`u24.x86_64`	1.2	1.2	1.2	1.2	1.2	1.2
`u24.aarch64`	1.2	1.2	1.2	1.2	1.2	1.2

CONTRIB

PGDG

PIGSTY

This extension is built-in with PostgreSQL and does not need separate download.

Extension pg_prewarm is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.

Load this extension by adding it to shared_preload_libraries:

# postgresql.conf
shared_preload_libraries = 'pg_prewarm'  # add to existing extensions if any

After modifying the configuration, restart PostgreSQL to load the extension.

Create this extension with:

CREATE EXTENSION pg_prewarm;