"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes: > On Mon, Jan 17, 2022 at 7:58 AM Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> Ron <ronljohnsonjr@xxxxxxxxx> writes: >>> 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. > Is "never" really the correct threshold here? It is if you've pushed things to the point where, say, "select count(*) from partitioned_table" will fail outright. I don't have a lot of faith in system designs that assume there will never be any ad-hoc queries that are outside your normal pattern. regards, tom lane
