select open change scope Open full search

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

Extensions / Security

pg_kpart

Reject full partition scans that omit the partition key

pgext.cloud · Source code

Overview

Packagepg_kpart
Version1.0
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Requires CREATE EXTENSIONNo
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_kpart
Stars5
Latest commit2026-06-21
Latest release2026-06-11
Catalogue updated2026-08-30

Related extensions

See also

plan_filterfilter statements by their execution plans.
pg_partmanExtension to manage partitioned tables by time or ID
safeupdateRequire criteria for UPDATE and DELETE
block_copy_commandBlock COPY commands via a configurable ProcessUtility hook
pg_strictPrevent dangerous UPDATE and DELETE without WHERE clause
prioritizeget and set the priority of PostgreSQL backends
qosQoS resource governor extension for PostgreSQL sessions and queries
pg_readonlycluster database read only
pgextwlistPostgreSQL Extension Whitelisting
timescaledbEnables scalable inserts and complex queries for time-series data