public inbox for [email protected]  

help / color / mirror / Atom feed

From: Muhammad Imtiaz <[email protected]>
To: Durgamahesh Manne <[email protected]>
Cc: Christoph Berg <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
Date: Mon, 22 Jul 2024 09:59:53 +0500
Message-ID: <CACW1Ly0YKoPXLcy6wmOhZUtGX-pWpT12zS10y=MAja3oB6_Dug@mail.gmail.com> (raw)
In-Reply-To: <CAJCZkoLoubpxgiuz2d5n+CkCdjc44FiE_zMMchghxGXFjrJqMA@mail.gmail.com>
References: <CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com>
	<CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z+=y-A@mail.gmail.com>
	<[email protected]>
	<CAJCZkoLoubpxgiuz2d5n+CkCdjc44FiE_zMMchghxGXFjrJqMA@mail.gmail.com>

Hi ,

You can consider the pg_pathman extension.



*Muhammad Imtiaz*

*PostgreSQL Technical Support Lead *
*/ Pakistan R&D*
*Mobile: +923345072521*
*Email: [email protected] <[email protected]>*

On Fri, Jul 19, 2024 at 7:55 PM Durgamahesh Manne <[email protected]>
wrote:

>
>
> On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg <[email protected]> wrote:
>
>> Re: Durgamahesh Manne
>> > with pg_partman By default proc() does not detach tables concurrently.
>> How
>> > do we implement tables detach concurrently without blocking other
>> sessions
>> > Here queries not using date column to detach tables with
>> > run_maintenance_proc() which is not using concurrently  based on the
>> > retention policy which leads to scan all available child tables hence
>> need
>> > to trigger this proc with concurrently option to avoid blocking other
>> child
>> > tables beyond rentention policy while running statements on them
>>
>> You might have more success by filing pg_partman issues at
>> https://github.com/pgpartman/pg_partman/issues
>>
>> > Do we have any other alternative rather than using pg_partman()?
>>
>> Well you can just run the same commands manually that pg_partman would
>> run.
>>
>> Christoph
>>
>
> Hi
> You might have more success by filing pg_partman issues at
> https://github.com/pgpartman/pg_partman/issues     >>> okay
>  My intention is to have any other extension other than pg_partman to
> manage table partitions manually
>
> Regards
> Durga Mahesh
>

view thread (3+ messages)

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], [email protected], [email protected]
  Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
  In-Reply-To: <CACW1Ly0YKoPXLcy6wmOhZUtGX-pWpT12zS10y=MAja3oB6_Dug@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