Inheritance and sharding with PostgresI’ve used sharding with inheritance in the past but on a warehousing backend where we did not need to worry about locks. Using LIKE to define child tables creates a maintenance burden but there are ways to work around it in your application code which can be made ‘version’ aware. In effect you would never update old shards and only add those columns in the newer shards – the application code being
