The Benefits of Splitting Tables in Postgres

partitioning is not an enforced clustering in terms of strict but it's kind of a loose cluster in postgres. Things aren't guaranteed to be in order within a partition but each partition will be separate yeahYeah so you need to split tables definitely maybe one more reason like the data locality is very important because updates or deletes happen very infrequently there or inserts also. So we autovac can keep many more pages keeping them all frozen all visible all the time right? It's also about vacuum efficiency but different vacuum not deleting that apples but keeping this visibility map up to date and this is super beneficial for performance query performance.