MIME-Version: 1.0
References: 
 <CA+M9Y+Dan7N2Z4SbZ19h9NcnHGUaGw9U8zm+ongM+kn8Pcu4LA@mail.gmail.com>
In-Reply-To: 
 <CA+M9Y+Dan7N2Z4SbZ19h9NcnHGUaGw9U8zm+ongM+kn8Pcu4LA@mail.gmail.com>
From: SOzcn <selahattinozcnma@gmail.com>
Date: Sat, 19 Oct 2024 11:25:38 +0300
Message-ID: 
 <CAJyV5AYM=cQJP9QWseWhFzf1BKdLqqrY5AGZ0=t-85tgAdxQwA@mail.gmail.com>
Subject: Re: Run maintenance proc
To: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000bfc8880624d02a1d"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJyV5AYM%3DcQJP9QWseWhFzf1BKdLqqrY5AGZ0%3Dt-85tgAdxQwA%40mail.gmail.com>
Precedence: bulk

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

Hello,

Partitioning tables belongs to main table. If you see table scans on the
partition tables it's might be because of the automatic maintenance doesn't
work. Like vacuum etc. Which version you have been using? There have some
issues on the versions of 13-14 because of your issue. 15 also have but
they fixed many issue on that.

You can try to build your indexes on partition tables. And then they can be
in list your index maintenance progress. What's your reality issue? Can u
give detail?

Have a nice weekend.

17 Eki 2024 Per 21:22 tarihinde Sathish Reddy <
sathishreddy.postgresql@gmail.com> =C5=9Funu yazd=C4=B1:

> Hi
>
>  .. please help on below one
> Automate partition maintenance on postgres without any script on primary
> detach 3months partition at same time 4 months partition detach partition
> from replica on postgres rds.
>
> Thanks
> Sathish Reddy
>

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

<p dir=3D"ltr">Hello, </p>
<p dir=3D"ltr">Partitioning tables belongs to main table. If you see table =
scans on the partition tables it&#39;s might be because of the automatic ma=
intenance doesn&#39;t work. Like vacuum etc. Which version you have been us=
ing? There have some issues on the versions of 13-14 because of your issue.=
 15 also have but they fixed many issue on that. </p>
<p dir=3D"ltr">You can try to build your indexes on partition tables. And t=
hen they can be in list your index maintenance progress. What&#39;s your re=
ality issue? Can u give detail? </p>
<p dir=3D"ltr">Have a nice weekend. </p>
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">17 Eki=
 2024 Per 21:22 tarihinde Sathish Reddy &lt;<a href=3D"mailto:sathishreddy.=
postgresql@gmail.com">sathishreddy.postgresql@gmail.com</a>&gt; =C5=9Funu y=
azd=C4=B1:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0=
 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir=3D"auto">Hi=C2=
=A0<div dir=3D"auto"><br></div><div dir=3D"auto">=C2=A0.. please help on be=
low one=C2=A0</div><div dir=3D"auto">Automate partition maintenance on post=
gres without any script on primary detach 3months partition at same time 4 =
months partition detach partition from replica on postgres rds.</div><div d=
ir=3D"auto"><br></div><div dir=3D"auto">Thanks=C2=A0</div><div dir=3D"auto"=
>Sathish Reddy=C2=A0</div></div>
</blockquote></div>

--000000000000bfc8880624d02a1d--