How do people partition with a requirement where you also need unique index constraints (across all partitions)?
Something like this:
create table orders(
order_id int unique
, year int
, primary key (order_id, year)
);
create table order_data(
order_id int
, year int
, LOADS_OF_COLUMNS_HERE jsonb
, primary key (order_id, year)
, foreign key (order_id, year) references orders(order_id, year)
) partition by list(year);