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 12:19:56
Message-ID: CAPG-CvUpqD-La-M-buPrA_5+oktP2k+DW_Zk8ePMqjPy4BgihA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Please find the attachmment.

On Tue, Sep 21, 2021 at 2:20 PM satish v <vuyyuru(dot)satish59(at)gmail(dot)com> wrote:

> [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]
>>
>

Attachment Content-Type Size
image/png 10.8 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Prashant Kulkarni 2021-09-21 12:52:41 How to Export Import particular/selected tables using PG Admin tool
Previous Message satish v 2021-09-21 08:50:55 Re: Autovacuum on toast tables