public inbox for [email protected]  

help / color / mirror / Atom feed

From: Vijaykumar Jain <[email protected]>
To: ROHIT SACHDEVA <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Regarding Partition
Date: Mon, 16 Jun 2025 23:33:06 +0530
Message-ID: <CAM+6J95VPJi52zqR3ucOWBGFudHgsz7OemAP2zTvQ+j1k81AZA@mail.gmail.com> (raw)
In-Reply-To: <CAKDb7aHwchiYSwQAzA36Uv2s0wajA0=CX1dYGcRXX1r9CP27XA@mail.gmail.com>
References: <CAKDb7aEjDQ9HrPrCb3hXqioEAJNQUYBdnuZ=TgBpuqfFa3LaRA@mail.gmail.com>
	<CAKDb7aHwchiYSwQAzA36Uv2s0wajA0=CX1dYGcRXX1r9CP27XA@mail.gmail.com>

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 <[email protected]>
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
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Regarding Partition
  In-Reply-To: <CAM+6J95VPJi52zqR3ucOWBGFudHgsz7OemAP2zTvQ+j1k81AZA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox