Scaling a fast growing database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Scaling a fast growing database

Yambu
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
Reply | Threaded
Open this post in threaded view
|

Re: Scaling a fast growing database

Alex Balashov
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 <[hidden email]> 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