agora inbox for pgsql-in-general@postgresql.org
help / color / mirror / Atom feedFrom: Christoph Berg <myon@debian.org>
To: Durgamahesh Manne <maheshpostgres9@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Cc: pgsql-in-general@postgresql.org
Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
Date: Fri, 19 Jul 2024 16:25:47 +0200
Message-ID: <Zpp3axAcU7oC5lrB@msg.df7cb.de> (raw)
In-Reply-To: <CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z+=y-A@mail.gmail.com>
References: <CAJCZkoJHVcz1QA4A-YpaLAjpW+_gB1D=qWShTS_b+5Rp7E=1Ng@mail.gmail.com>
<CAJCZkoJayD-9Ck0d0OZb0g-ptvCgv49Xwn_kyxLj9be-Z+=y-A@mail.gmail.com>
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
view thread (5+ messages) latest in thread
Message-ID: <Zpp3axAcU7oC5lrB@msg.df7cb.de>
Permalink: ../Zpp3axAcU7oC5lrB@msg.df7cb.de/
Also on: postgresql.org/message-id/Zpp3axAcU7oC5lrB@msg.df7cb.de
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: pgsql-in-general@postgresql.org
Cc: myon@debian.org, maheshpostgres9@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
In-Reply-To: <Zpp3axAcU7oC5lrB@msg.df7cb.de>
* 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