Partitioning yana raba babbar tebur zuwa ƙananan sifofi jiki-jiki (partitions) dangane da ƙimar ginshiki, duk da haka ya kasance tebur ɗaya na hankali. Declarative partitioning na PostgreSQL (Postgres 10+) yana sa wannan da tsabta. Yana inganta aiki da hidima don manyan tebur.
Declarative partitioning (hanyar zamani)
orders (id , order_date , amount )
(order_date);
orders_2023 orders
() ();
orders_2024 orders
() ();
