Postgres Pro
Downloads
Home   >   mailing lists

Autovacuum on Toast table - Mailing list pgadmin-hackers

From satish v
Subject Autovacuum on Toast table
Date
Msg-id CAPG-CvXH6pKbLpHSwSct0yN0p2Jrx0DhLph_PMujqgFhJMLbVw@mail.gmail.com
Whole thread Raw
Responses Re: Autovacuum on Toast table  (Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>)
List pgadmin-hackers
Tree view
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
Attachment

pgadmin-hackers by date:

Previous
From: Akshay Joshi
Date:
Subject: Re: [pgAdmin][RM2546]: Partitioned table should be created using COLLATE and opclass.
Next
From: Aditya Toshniwal
Date:
Subject: Re: Autovacuum on Toast table