Partitioning!
https://www.postgresql.org/docs/current/ddl-partitioning.html
—
Sent from mobile, with due apologies for brevity and errors.
> On Feb 18, 2021, at 12:42 AM, Yambu <hyambu(at)gmail(dot)com> wrote:
>
>
> Hello
>
> One of my tables is getting 1mil records per week , what changes do i need to make, to keep it fast and scalable?
>
> regards