Обсуждение: Autovacuum on toast tables

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 azure postgresql service.

in 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 2:18 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 azure postgresql service.