Ron <ronljohnsonjr@xxxxxxxxx> writes: > On 1/16/22 11:38 PM, Victor Sudakov wrote: >> so no query should ever have to use more than 1 partition. > I find it hard to believe that you'll *never* run a report against more > customers than are in a single partition. Yeah, I'm a little suspicious of that. The other thing I'd be worried about, given that the OP is using v13, is that UPDATE/DELETE planning performance can be pretty awful with lots of partitions. There were some O(N^2) behaviors in there that we didn't get rid of till v14. regards, tom lane
