pgslice ☆

« Back to VersTracker

Description:
Postgres partitioning as easy as pie

Type: Formula | Latest Version: 0.7.1@0 | Tracked Since: Dec 26, 2025

Links: Homepage | GitHub | formulae.brew.sh

Stars: 1,222 | Forks: 69 | Language: Ruby | Category: Databases

Tags: postgresql database partitioning performance ruby

Install: brew install pgslice

About:
pgslice is a command-line tool for managing PostgreSQL table partitioning. It automates the creation and maintenance of time-based or serial-based partitions, helping to improve query performance and simplify data management for large tables. Its main value is providing a simple, declarative approach to partitioning without requiring deep database administration expertise.

Key Features:

Automates creation of time-based or serial-based partitions
Provides commands to fill, swap, and manage partitions
Supports declarative partitioning via PostgreSQL's native features
Includes helpers for analyzing and optimizing partitioned tables
Simple command-line interface with minimal configuration

Use Cases:

Partitioning large PostgreSQL tables by time (e.g., logs, events) for performance
Managing data lifecycle by archiving or dropping old partitions automatically
Simplifying database maintenance and improving query speed on growing datasets

Alternatives:

PostgreSQL Native Partitioning – pgslice provides a simpler CLI wrapper and automation for PostgreSQL's built-in partitioning.
pg_partman – pg_partman is a more feature-rich PostgreSQL extension, while pgslice is a lighter, external Ruby tool.

Version History

Detected	Version	Rev	Change	Commit
Dec 26, 2025 5:58pm	0.7.1	0	VERSION_BUMP	e8ee626a