Proof-of-concept shared-memory execution-plan cache for PostgreSQL
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_shared_plans |
|---|---|
| Version | 0.0.1 |
| PostgreSQL versions | 12 · 13 · 14 · 15 · 16 · 17 |
| Repository | Unspecified |
| Extension type | Preloaded |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | Yes |
| Trusted | No |
| Relocatable | Yes |
| Shared libraries | pg_stat_statements, pg_shared_plans |
| Stars | 22 |
| Latest commit | 2025-10-12 |
| Catalogue updated | 2026-08-30 |
| pg_stat_statements | track planning and execution statistics of all SQL statements executed |
| pg_buffercache | examine the shared buffer cache |
| pgfincore | examine and manage the os buffer cache |
| pg_prewarm | prewarm relation data |
| hash_fdw | Shared-memory hash-table foreign data wrapper for storing and querying rows by a configured key. |
| shared_ispell | Shared-memory ispell dictionary template for reducing per-session initialization and memory. |
| postfga | A preload PostgreSQL extension integrating OpenFGA authorization through an FDW, C functions, gRPC background work and shared-memory caching. |
| statsmgr | C extension that snapshots PostgreSQL cumulative WAL, SLRU, checkpoint, archiver, I/O, and background-writer statistics in dynamic shared memory. |
| pgcozy | Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL. |