Thread: Regarding Partition
Hi Team,
I have a table having a total row count around 121 crores and I am using Partition by hash to handle this.
As the size is increasing day by day I want to increase the number of partition in an automatic way or free tool to manage all these.
I am using postgres 14 and using the service of AWS RDS
Let me know is it possible.
Regards
Rohit Sachdeva
i guess AWS rds supports pg_partman extension
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_Partitions.html
there is also pgslice if one wants to do it externally via cli
On Mon, Jun 16, 2025, 11:27 PM ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> wrote:
Hi Team,I have a table having a total row count around 121 crores and I am using Partition by hash to handle this.As the size is increasing day by day I want to increase the number of partition in an automatic way or free tool to manage all these.I am using postgres 14 and using the service of AWS RDSLet me know is it possible.RegardsRohit Sachdeva