Slice your data for autovacuum to work better! NO HUGE TABLES
UPDATE in postgresql is basical DELETE and INSERT.{
"big_column_with_large_data_less_updates": "",
"some_jsonb_large": {},
"id": "int",
"created_at": "Date",
"updated_at": "Date",
"some_frequently_updatd_column": ""
}
updated_at is changed or some other property, that is frequently changed, IT DOES NOT make sense to delete and insert the whole row again!// Table_D_1
{
"big_column_with_large_data_less_updates": "",
"some_jsonb_large": {},
"id": "int",
"created_at": "Date",
}
// Table_D_2 with 1-1 on Table_D_1
{
"updated_at": "Date",
"some_frequently_updatd_column": ""
}