Jerry Champlin <jchamplin@xxxxxxxxxxxxxxxxxxxxxxxx> writes: > Is there a way to use multi-level inheritance to achieve sub > partitioning that the query optimizer will recognize? No, I don't think so. How would that make things any better anyway? You're still going to end up with the same very large number of partitions. regards, tom lane