Обсуждение: Autovacuum on Toast table
Hi,
We deleted the old data around 300GB from a table.i can see the auto vacuum performing on base table but not on toast table.due to this db size is growing rapidly. I am using the Azure PostgreSQL service.
In the base/parent table dead tuples are zero. Is it possible to run the vacuum on toast tables?.
Thanks in advance
Вложения
On Tue, Sep 21, 2021 at 5:48 PM satish v <vuyyuru.satish59@gmail.com> wrote:
Hi,We deleted the old data around 300GB from a table.i can see the auto vacuum performing on base table but not on toast table.due to this db size is growing rapidly. I am using the Azure PostgreSQL service.In the base/parent table dead tuples are zero. Is it possible to run the vacuum on toast tables?.Thanks in advance
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"