You are asking for race conditions handling the creation of the next, necessary partition within…
Keith Fiske

Keith, thanks for the link! Luckily we can make sure of two things where we use this trigger:

  • inserts happen only from 1 connection and 1 thread
  • insertion is not time critical

I think with these preconditions the way we set it up still good for the use case. If we are running into concurrency issues ever I am moving it to cron the first time it happens.

Like what you read? Give StreamBright a round of applause.

From a quick cheer to a standing ovation, clap to show how much you enjoyed this story.