Syn Postgres Partitioning

PostgreSQL: declarative table partitioning

legendtkl d3116cc 734 B Updated

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/tree/main/experiments/dci-compare/synthetic-skills/syn-postgres-partitioning commit d3116cce55

Frequently asked questions

npx skillmds@latest add legendtkl/syn-postgres-partitioning