Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
От | Durgamahesh Manne |
---|---|
Тема | Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
Дата | |
Msg-id | CAJCZkoLoubpxgiuz2d5n+CkCdjc44FiE_zMMchghxGXFjrJqMA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() (Christoph Berg <myon@debian.org>) |
Ответы |
Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
|
Список | pgsql-general |
On Fri, Jul 19, 2024 at 7:55 PM Christoph Berg <myon@debian.org> 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
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
В списке pgsql-general по дате отправления: