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