Replies: 1 comment
-
When sub-partitioning, the child tables which are themselves parent tables of another partition set, may have a different partition configuration than the upper level parent. Like at the top level it's partitioned by month, but the child tables are themselves partitioned by 100,000 integer intervals or daily or some other interval. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi,
According to the documentation( and to our experience), the run_maintenance() runs on tables that appear in the part_config table only.
That means that when we use pg_partman to manage subpartitions, we have to configure part_config as well as part_config_sub. Is it possible that we missed something? If not, we were wondering what the role of part_config_sub is if run_maintneance takes its data from the part_config table anyways.
Thanks!
Beta Was this translation helpful? Give feedback.
All reactions