pg_partman is a PostgreSQL extension for managing time-based and serial-based table partitioning. It automates the creation, maintenance, and retention of partitions, making it easier to manage large datasets with better performance and query efficiency. Designed for both native and trigger-based partitioning, pg_partman is ideal for applications handling time-series or log data.

Features

  • Automates time and serial-based table partitioning
  • Supports native and trigger-based partitioning
  • Background worker for automatic partition creation
  • Retention policy to drop or archive old partitions
  • Partition template system for schema consistency
  • Supports subpartitioning for complex data structures

Project Samples

Project Activity

See All Activity >

Categories

Database

Follow pg_partman

pg_partman Web Site

Other Useful Business Software
Build Agents and Models on One Platform Icon
Build Agents and Models on One Platform

Everything you need to build production-ready agents and models. Access 200+ Google and third-party AI models and tools.

Gemini Enterprise Agent Platform is Google Cloud's comprehensive platform for developers to build, scale, govern, and optimize agents and models. Choose from Google's most advanced models and third-party models like Anthropic's Claude Model Family.
Try It Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of pg_partman!

Additional Project Details

Operating Systems

BSD

Registered

2025-06-05