Re: Autovacuum on Toast table

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: satish v <vuyyuru(dot)satish59(at)gmail(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Autovacuum on Toast table
Date: 2021-09-21 12:35:47
Message-ID: CAM9w-_kUkUYQPV0M-mfc1hK6L_ZL8m980Hd5hdfsozBkD9WTnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Satish,

The question is more suitable to be redirected to pgsql-admin(at)postgresql(dot)org

On Tue, Sep 21, 2021 at 5:48 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 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
>
> [image: image.png]
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Aditya Toshniwal 2021-09-22 06:19:17 [pgAdmin][RM6770] Foreign Key multiple fixes
Previous Message satish v 2021-09-21 12:17:45 Autovacuum on Toast table