public inbox for [email protected]  

help / color / mirror / Atom feed

Run maintenance proc
4+ messages / 3 participants
[nested] [flat]

* Run maintenance proc
@ 2024-10-17 18:22  Sathish Reddy <[email protected]>
  0 siblings, 2 replies; 4+ messages in thread

From: Sathish Reddy @ 2024-10-17 18:22 UTC (permalink / raw)
  To: pgsql-admin <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Run maintenance proc
@ 2024-10-19 08:25  SOzcn <[email protected]>
  parent: Sathish Reddy <[email protected]>
  1 sibling, 0 replies; 4+ messages in thread

From: SOzcn @ 2024-10-19 08:25 UTC (permalink / raw)
  To: Sathish Reddy <[email protected]>; +Cc: pgsql-admin <[email protected]>

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
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Run maintenance proc
@ 2024-10-19 12:55  Keith Fiske <[email protected]>
  parent: Sathish Reddy <[email protected]>
  1 sibling, 1 reply; 4+ messages in thread

From: Keith Fiske @ 2024-10-19 12:55 UTC (permalink / raw)
  To: Sathish Reddy <[email protected]>; +Cc: pgsql-admin <[email protected]>

On Thu, Oct 17, 2024, 2:22 PM Sathish Reddy <
[email protected]> 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

https://github.com/pgpartman/pg_partman/

Keith


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Run maintenance proc
@ 2024-10-19 13:08  Sathish Reddy <[email protected]>
  parent: Keith Fiske <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Sathish Reddy @ 2024-10-19 13:08 UTC (permalink / raw)
  To: Keith Fiske <[email protected]>; +Cc: pgsql-admin <[email protected]>

Thanks, I'll check it out.

On Sat, Oct 19, 2024, 6:25 PM Keith Fiske <[email protected]>
wrote:

>
>
> On Thu, Oct 17, 2024, 2:22 PM Sathish Reddy <
> [email protected]> 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
>
> https://github.com/pgpartman/pg_partman/
>
> Keith
>
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2024-10-19 13:08 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-17 18:22 Run maintenance proc Sathish Reddy <[email protected]>
2024-10-19 08:25 ` SOzcn <[email protected]>
2024-10-19 12:55 ` Keith Fiske <[email protected]>
2024-10-19 13:08   ` Sathish Reddy <[email protected]>

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