Re: Regarding Partition

From: Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>
To: ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Regarding Partition
Date: 2025-06-16 18:03:06
Message-ID: CAM+6J95VPJi52zqR3ucOWBGFudHgsz7OemAP2zTvQ+j1k81AZA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Thanks,
Vijay

Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada>

On Mon, Jun 16, 2025, 11:27 PM ROHIT SACHDEVA <sachdeva(dot)rohit648(at)gmail(dot)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 RDS
>
> Let me know is it possible.
>
> Regards
> Rohit Sachdeva
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gaspare Boscarino, P.Eng. 2025-06-16 18:10:22 Re: Upgrade from 12.22 to 16
Previous Message ROHIT SACHDEVA 2025-06-16 17:56:51 Regarding Partition