David Rowley <dgrowle...@gmail.com> writes: > I've recently been thinking it would be good if you were unable to > access partitions directly by name at all.
I strongly disagree. That's essentially betting the whole farm on our always being able to optimize parent-level operations fully, which I do not think we are anywhere close to. > That would also get around > the problem of having to lock all non-pruned partitions during queries > to the partitioned table. Maybe it's too late for that though. Yeah, I think we are locked into the current design now, for better or worse. regards, tom lane