MIME-Version: 1.0
References: 
 <CAKDb7aEjDQ9HrPrCb3hXqioEAJNQUYBdnuZ=TgBpuqfFa3LaRA@mail.gmail.com>
 <CAKDb7aHwchiYSwQAzA36Uv2s0wajA0=CX1dYGcRXX1r9CP27XA@mail.gmail.com>
In-Reply-To: 
 <CAKDb7aHwchiYSwQAzA36Uv2s0wajA0=CX1dYGcRXX1r9CP27XA@mail.gmail.com>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Mon, 16 Jun 2025 23:33:06 +0530
Message-ID: 
 <CAM+6J95VPJi52zqR3ucOWBGFudHgsz7OemAP2zTvQ+j1k81AZA@mail.gmail.com>
Subject: Re: Regarding Partition
To: ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d158230637b43509"
Archived-At: 
 <https://www.postgresql.org/message-id/CAM%2B6J95VPJi52zqR3ucOWBGFudHgsz7OemAP2zTvQ%2Bj1k81AZA%40mail.gmail.com>
Precedence: bulk

--000000000000d158230637b43509
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

i guess AWS rds supports pg_partman extension

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL_Partition=
s.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=E2=80=AFPM ROHIT SACHDEVA <sachdeva.rohit648@gm=
ail.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
>

--000000000000d158230637b43509
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><p dir=3D"ltr">i guess AWS rds supports pg_partman extens=
ion<br>
</p><p dir=3D"ltr"><a href=3D"https://docs.aws.amazon.com/AmazonRDS/latest/=
UserGuide/PostgreSQL_Partitions.html">https://docs.aws.amazon.com/AmazonRDS=
/latest/UserGuide/PostgreSQL_Partitions.html</a></p><p dir=3D"ltr">there is=
 also pgslice if one wants to do it externally via cli</p><p dir=3D"ltr"><b=
r></p><div data-smartmail=3D"gmail_signature"><div dir=3D"ltr">Thanks,<div>=
Vijay</div><div><br></div><div>Open to work</div><div>Resume -=C2=A0<a href=
=3D"https://github.com/cabecada" target=3D"_blank">Vijaykumar Jain</a><br><=
/div></div></div></div><br><div class=3D"gmail_quote gmail_quote_container"=
><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Jun 16, 2025, 11:27=E2=80=AF=
PM ROHIT SACHDEVA &lt;<a href=3D"mailto:sachdeva.rohit648@gmail.com">sachde=
va.rohit648@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex=
"><div dir=3D"auto"><div><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr"><br></div><br><br><div dir=3D"auto">Hi Team,<div dir=3D"aut=
o"><br></div><div dir=3D"auto">I have a table having a total row count arou=
nd 121 crores and I am using Partition by hash to handle this.</div><div di=
r=3D"auto"><br></div><div dir=3D"auto">As the size is increasing day by day=
 I want to increase the number of partition in an automatic way or free too=
l to manage all these.</div><div dir=3D"auto"><br></div><div dir=3D"auto">I=
 am using postgres 14 and using the service of AWS RDS=C2=A0</div><div dir=
=3D"auto"><br></div><div dir=3D"auto">Let me know is it possible.</div><div=
 dir=3D"auto"><br></div><div dir=3D"auto">Regards</div><div dir=3D"auto">Ro=
hit Sachdeva</div></div>
</div></div></div>
</blockquote></div>

--000000000000d158230637b43509--