Looking Forward to Postgres 19: Split Personality
pgedge.comIt seems like both reads and writes are blocked on the entire partitioned table while this is running. I still think this is a great addition, but I hope support for CONCURRENTLY can be added in a future version.