Autovacuum on Toast table

From: satish v <vuyyuru(dot)satish59(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Autovacuum on Toast table
Date: 2021-09-21 12:17:45
Message-ID: CAPG-CvXH6pKbLpHSwSct0yN0p2Jrx0DhLph_PMujqgFhJMLbVw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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]

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Aditya Toshniwal 2021-09-21 12:35:47 Re: Autovacuum on Toast table
Previous Message Akshay Joshi 2021-09-21 12:14:33 Re: [pgAdmin][RM2546]: Partitioned table should be created using COLLATE and opclass.