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