Design PostgreSQL table partitioning with range, list, and hash strategies including partition pruning and maintenance.
Act as a PostgreSQL partitioning expert. Partition [TABLE_NAME] using [PARTITION_STRATEGY] (range, list, hash). Define partitions on [PARTITION_KEY]. Create sub-partitions for [SUB_PARTITION_LOGIC]. Set up auto-creation for [FUTURE_PARTITIONS]. Configure partition pruning for [QUERY_PATTERNS]. Add maintenance for [PARTITION_LIFECYCLE].
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.5 Pro.
Specify table name, partition strategy, partition key, sub-partition logic, future partition rules, query patterns, and partition lifecycle.
Initial release
Sign in and download this prompt to leave a review.