Re: Dynamic creation of list partitions in highly concurrent write environment - Mailing list pgsql-general

Jim Vanns <jvanns@ilm.com> 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