Provides PL/pgSQL tools for managing inheritance-based partition tables.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg_prttn_tools |
|---|---|
| Version | 0.5 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | prttn_tools |
| Stars | 1 |
| Latest commit | 2017-06-16 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| pg_dbwa | Analyzes local or remote PostgreSQL workloads using historical pg_stat_statements snapshots. |
| pg_kpart | Reject full partition scans that omit the partition key |
| tab_tier | PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. |
| pg_table_range | Planning-time partition pruning by per-partition data ranges, including non-key columns. |
| pg_partition | Generate and manage timestamp-based PostgreSQL table partitions |
| partman_to_cstore | Move old pg_partman partitions to cstore columnar storage. |
| pgparts | SQL/PLpgSQL helper extension for creating and maintaining table partitions with triggers |
| gogudb | PostgreSQL extension for distributed hash and range partitioning across foreign servers. |
| pg_particulous | Migrate tables between vanilla PostgreSQL and pg_pathman partitioning |