Planning-time partition pruning by per-partition data ranges, including non-key columns.
pgext.cloud · Source code · Documentation · License text · Control file · PGXN
| Package | pg_table_range |
|---|---|
| Version | 0.1.1 |
| PostgreSQL versions | 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Stars | 2 |
| Latest commit | 2026-06-23 |
| Latest release | 2026-06-23 |
| Catalogue updated | 2026-08-30 |
| pg_kpart | Reject full partition scans that omit the partition key |
| pg_prttn_tools | Provides PL/pgSQL tools for managing inheritance-based partition tables. |
| qdgc | Encode, decode, navigate, and fill Extended Quarter Degree Grid Cell codes in pure SQL. |
| tab_tier | PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. |
| brin4postgis | BRIN indexes for PostGIS |
| planinstr | Planner hook for measuring PostgreSQL planning time, intended mainly for debugging. |
| pg_stash_advice | Store plan advice by query ID and automatically apply it during PostgreSQL query planning |
| pargres | Prototype parallel query execution module for shared-nothing PostgreSQL clusters |
| edb_foreignkeyconstraintmanager | Manage trigger-based foreign-key behavior for partitioned tables on EDB Postgres Advanced Server |
| gogudb | PostgreSQL extension for distributed hash and range partitioning across foreign servers. |