syn-postgres-partitioning

name	syn-postgres-partitioning
description	PostgreSQL operations skill. Primary capability: declarative table partitioning. It sits among neighboring PostgreSQL areas — related skills cover autovacuum and bloat control and streaming replication between a primary and standby — so confirm the task is about declarative table partitioning specifically.

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.