Re: Autovacuum on toast tables

From: satish v <vuyyuru(dot)satish59(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Autovacuum on toast tables
Date: 2021-09-21 08:50:55
Message-ID: CAPG-CvVxgds1HvzyeG+uHXXDnD7x_EprVN+yZBkqo3QSxKXs+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

[image: image.png]

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(dot)satish59(at)gmail(dot)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.
>
> [image: image.png]
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message satish v 2021-09-21 12:19:56 Re: Autovacuum on toast tables
Previous Message satish v 2021-09-21 08:48:55 Autovacuum on toast tables