Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
От | Christoph Berg |
---|---|
Тема | Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc() |
Дата | |
Msg-id | Zpp3axAcU7oC5lrB@msg.df7cb.de обсуждение исходный текст |
Ответ на | Fwd: Regarding tables detach concurrently with run_maintenance_proc() (Durgamahesh Manne <maheshpostgres9@gmail.com>) |
Ответы |
Re: Fwd: Regarding tables detach concurrently with run_maintenance_proc()
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: