It looks like you are creating a partition for each minute of the day (when
logs get inserted for a given minute at least). Would it be at all
reasonable to have an hourly or daily job which creates the partitions
ahead of when they are actually needed? If partitions went unused in the
recent past, you could also drop those if appropriate to your workflow. I
just wonder about doing the work just-in-time via 2+ connections vs doing
it from a single process to avoid the chance of deadlock completely.