Jim Vanns <jvanns@xxxxxxx> 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
