pg_cooldown
remove buffered pages for specific relations
Repository
rbergm/pg_cooldown
https://github.com/rbergm/pg_cooldown
Source
pg_cooldown-0.1.tar.gz
pg_cooldown-0.1.tar.gz
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
pg_cooldown | 0.1 | ADMIN | Apache-2.0 | C |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 5070 | pg_cooldown | No | Yes | No | Yes | No | Yes | - |
| Related | pgfincore pgcozy pg_prewarm pg_buffercache pg_repack pg_squeeze system_stats pgmeminfo |
|---|
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | PIGSTY | 0.1 | 1817161514 | pg_cooldown | - |
| RPM | PIGSTY | 0.1 | 1817161514 | pg_cooldown_$v | - |
| DEB | PIGSTY | 0.1 | 1817161514 | postgresql-$v-pg-cooldown | - |
Build
You can build the RPM / DEB packages for pg_cooldown using pig build:
pig build pkg pg_cooldown # build RPM / DEB packages
Install
You can install pg_cooldown directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:
pig repo add pgsql -u # Add repo and update cache
Install the extension using pig or apt/yum/dnf:
pig install pg_cooldown; # Install for current active PG version
pig ext install -y pg_cooldown -v 18 # PG 18
pig ext install -y pg_cooldown -v 17 # PG 17
pig ext install -y pg_cooldown -v 16 # PG 16
pig ext install -y pg_cooldown -v 15 # PG 15
pig ext install -y pg_cooldown -v 14 # PG 14
dnf install -y pg_cooldown_18 # PG 18
dnf install -y pg_cooldown_17 # PG 17
dnf install -y pg_cooldown_16 # PG 16
dnf install -y pg_cooldown_15 # PG 15
dnf install -y pg_cooldown_14 # PG 14
apt install -y postgresql-18-pg-cooldown # PG 18
apt install -y postgresql-17-pg-cooldown # PG 17
apt install -y postgresql-16-pg-cooldown # PG 16
apt install -y postgresql-15-pg-cooldown # PG 15
apt install -y postgresql-14-pg-cooldown # PG 14
Create Extension:
CREATE EXTENSION pg_cooldown;
Usage
pg_cooldown is the complement to pg_prewarm: it removes all buffered pages of a specific relation from the shared buffer, useful for simulating cold-start scenarios in research and testing.
Remove Pages from Shared Buffer
-- Remove all data pages of a table
SELECT pg_cooldown('my_relation');
-- Remove pages of a primary key index
SELECT pg_cooldown('my_relation_pkey');
-- Remove pages of any index
SELECT pg_cooldown('my_index_name');
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.