PL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance.
pgext.cloud · Source code · Documentation · PGXN
| Package | tab_tier |
|---|---|
| Version | 1.1 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | tab_tier |
| Latest release | 2016-06-15 |
| Catalogue updated | 2026-07-30 |
| plpgsql | PL/pgSQL procedural language |
| pg_kpart | Reject full partition scans that omit the partition key |
| pg_partition | Generate and manage timestamp-based PostgreSQL table partitions |
| pg_prttn_tools | Provides PL/pgSQL tools for managing inheritance-based partition tables. |
| pg_table_range | Planning-time partition pruning by per-partition data ranges, including non-key columns. |
| 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 |