↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

pg_dropcache

Invalidate PostgreSQL shared_buffers cache for a database or relation

pgext.cloud · Source code · Documentation · License text · Control file · PGXN

Overview

Packagepg_dropcache
Version1.0.0
PostgreSQL versions11 · 12 · 13 · 14 · 15 · 16
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars1
Latest commit2026-04-04
Latest release2026-04-04
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

pg_dropbuffersDrop PostgreSQL shared buffers and the operating-system page cache for testing
pg_buffercacheexamine the shared buffer cache
pgfincoreexamine and manage the os buffer cache
pg_prewarmprewarm relation data
buffercache_toolsInspect and manipulate PostgreSQL buffer cache entries for relations, forks, databases, and tablespaces.
pgcozyPre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.