# ankane/pgslice

Postgres partitioning as easy as pie

Repository: https://github.com/ankane/pgslice
Canonical: https://ross.abutalabs.com/products/pgslice
Language: Ruby
License: MIT
License Family: permissive
Last push: 2026-06-29T04:56:01+00:00

## Health v2 (maintenance only)
Score: 73/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 90, release rhythm 35, longevity 100
- inputs: {"age_days": 3783, "days_push": 65, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1244, forks 69 (observed 2026-08-28T04:04:06.788174+00:00)

## What it is
pgslice is a command line tool that makes Postgres table partitioning easy, supporting both new and existing tables with zero downtime and minimal application changes. It manages creating partitioned intermediate tables, backfilling data in batches, and swapping tables in place.

## Use cases
- partition a large postgres table by date
- convert an existing table to a partitioned table without downtime
- archive old data on a rolling basis to keep database size under control
- backfill historical rows into partitions in batches
- manage day, month, or year partitions for time-series tables

## When to choose
- you need zero-downtime partitioning of an existing Postgres table
- you want a simple CLI with no database server extensions to install
- you need to archive older data on a rolling basis

## When to avoid
- you use a database other than Postgres
- you need partitioning by non-date columns
- you prefer declarative partitioning managed entirely in application migrations

## Facets
- artifact type: cli-tool
- maturity: stable
- function: database, developer-tools
- domain: databases, developer-tools
- platform: cli, windows
- tags: postgresql, partitioning, zero-downtime, ruby, database-maintenance, linux, macos

## Member repositories
- ankane/pgslice (main) score 73

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:06.788174+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T05:08:14.105965+00:00, confidence not recorded.
  - readme: https://github.com/ankane/pgslice (fetched 2026-08-28T04:04:06.788174+00:00, sha 61fa1d213b1f)
- Data as of 2026-08-30T08:39:29.467469+00:00.