Re: Dynamic creation of list partitions in highly concurrent write environment

2023-06-01 Thread Jim Vanns
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 wrote: > Jim Vanns writes: > > Here's the general approach we have, without code and with hypothetical > > model, since I'm writing this hastily; > > > tabl

Re: Dynamic creation of list partitions in highly concurrent write environment

2023-06-01 Thread Tom Lane
Jim Vanns 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 c