Creating partitions automatically in PostgreSQL

Why not do the insert, catch an exception if it happens and create the table in there? It seems like it would be more efficient that way.

Of course the most efficient way would be to create the tables ahead of time and create a rule instead of a trigger.

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

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