Postgres Pro
Downloads
Home   >   mailing lists

Thread: Run maintenance proc

Run maintenance proc

From
Sathish Reddy
Date:
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 

Re: Run maintenance proc

From
SOzcn
Date:

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> ş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 

Re: Run maintenance proc

From
Keith Fiske
Date:


On Thu, Oct 17, 2024, 2:22 PM Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
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


Take a look at the pg_partman extension. It automates new child table creation for time-based partitioning and can set retention rules as well


Keith

Re: Run maintenance proc

From
Sathish Reddy
Date:

Thanks, I'll check it out.

On Sat, Oct 19, 2024, 6:25 PM Keith Fiske <keith.fiske@crunchydata.com> wrote:


On Thu, Oct 17, 2024, 2:22 PM Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
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


Take a look at the pg_partman extension. It automates new child table creation for time-based partitioning and can set retention rules as well


Keith