ankane/pgslice
Postgres partitioning as easy as pie observed · 2026-08-28
Health v2 · maintenance only
73/100
- Activity 90
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 3783
- days_rel: n/a
- days_push: 65
- n_releases_24m: 0
Adoption not part of the score
1244 stars · 69 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
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
cli-tool · maturity stable
database developer-tools databases developer-tools cli windows postgresql partitioning zero-downtime ruby database-maintenance linux macos
1 source
- readme: https://github.com/ankane/pgslice · fetched 2026-08-28 · 61fa1d213b1f
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| ankane/pgslice | main | 73 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem