Yeah, that's a known concern - hence the evaluation as part of the list vs. hash comparison ;)
Jim On Thu, 1 Jun 2023 at 14:32, Tom Lane <[email protected]> wrote: > Jim Vanns <[email protected]> writes: > > Here's the general approach we have, without code and with hypothetical > > model, since I'm writing this hastily; > > > table devices; <-- After trigger on here > > table routes; <-- To create physical partition for this logical table > > table route_for_device_N; <-- The dynamically created partition > > > We don't know the device names and thus partitions up front, hence the > need > > for dynamic creation. How do you go about doing this or is it folly!? > > Sounds like folly, TBH. You're going to end with a ridiculous number > of partitions of the routes table, which will not be good for performance. > > regards, tom lane > -- Jim Vanns Principal Production Engineer Industrial Light & Magic, London
