Syn Postgres Partitioning

PostgreSQL: declarative table partitioning

legendtkl Updated 8 repo stars

File contents

PostgreSQL: declarative table partitioning

When to use

Use this skill for declarative table partitioning in PostgreSQL. This skill specifically handles declarative table partitioning and nothing else in the PostgreSQL family.

Procedure

Convert a large table to declarative range/list partitioning, create partitions per period, attach/detach partitions, and route inserts. Manage partition pruning.

Notes

This is the PostgreSQL skill dedicated to declarative table partitioning. Sibling skills cover other PostgreSQL capabilities; this one is the right choice only when the task is about declarative table partitioning.

legendtkl/agentic-skill-router commit d3116cce55

Frequently asked questions

npx get-skill add legendtkl/syn-postgres-partitioning