Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum on Toast table - Mailing list pgadmin-hackers

From Aditya Toshniwal
Subject Re: Autovacuum on Toast table
Date
Msg-id CAM9w-_kUkUYQPV0M-mfc1hK6L_ZL8m980Hd5hdfsozBkD9WTnQ@mail.gmail.com
Whole thread Raw
In response to Autovacuum on Toast table  (satish v <vuyyuru.satish59@gmail.com>)
List pgadmin-hackers
Tree view
Hi Satish,

The question is more suitable to be redirected to pgsql-admin@postgresql.org


On Tue, Sep 21, 2021 at 5:48 PM satish v <vuyyuru.satish59@gmail.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.png


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"
Attachment

pgadmin-hackers by date:

Previous
From: satish v
Date:
Subject: Autovacuum on Toast table
Next
From: Aditya Toshniwal
Date:
Subject: [pgAdmin][RM6770] Foreign Key multiple fixes