public inbox for [email protected]
help / color / mirror / Atom feedFrom: SOzcn <[email protected]>
To: Sathish Reddy <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: Run maintenance proc
Date: Sat, 19 Oct 2024 11:25:38 +0300
Message-ID: <CAJyV5AYM=cQJP9QWseWhFzf1BKdLqqrY5AGZ0=t-85tgAdxQwA@mail.gmail.com> (raw)
In-Reply-To: <CA+M9Y+Dan7N2Z4SbZ19h9NcnHGUaGw9U8zm+ongM+kn8Pcu4LA@mail.gmail.com>
References: <CA+M9Y+Dan7N2Z4SbZ19h9NcnHGUaGw9U8zm+ongM+kn8Pcu4LA@mail.gmail.com>
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 <
[email protected]> şunu yazdı:
> 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
>
view thread (4+ messages) latest in thread
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: Run maintenance proc
In-Reply-To: <CAJyV5AYM=cQJP9QWseWhFzf1BKdLqqrY5AGZ0=t-85tgAdxQwA@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