Benjamin Tingle <ben@xxxxxxxxxx> writes: > Interesting. Why is it impossible to prune hash partitions? Maybe prune > isn’t the best word, more so use to advantage. At the very least, it should > be possible to utilize a parallel insert against a table partitioned by > hash. (Partition query rows, then distribute these rows to parallel workers) Your plan-shape complaint had nothing to do with insertions; it had to do with joining the partitioned table to another table. That join can't be optimized. regards, tom lane
