select open change scope Open full search

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

Extensions / Administration

pg_rewrite

Tool allows read write to the table during the rewriting

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

Overview

Packagepg_rewrite
Version2.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryMultiple repositories
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_rewrite
Stars46
Latest commit2026-07-13
Latest release2026-07-13
Catalogue updated2026-08-30

Related extensions

See also

pg_repackReorganize tables in PostgreSQL databases with minimal locks
pgstattupleshow tuple-level statistics
pg_squeezeA tool to remove unused space from a relation.
pg_dirtyreadRead dead but unvacuumed rows from table
pg_column_tetrisEnforce optimal column alignment to minimize row padding
pg_visibilityexamine the visibility map (VM) and page-level visibility info