Postgres Pro
Downloads
Home   >   mailing lists

Re: Autovacuum on toast tables - Mailing list pgsql-admin

From satish v
Subject Re: Autovacuum on toast tables
Date
Msg-id CAPG-CvUpqD-La-M-buPrA_5+oktP2k+DW_Zk8ePMqjPy4BgihA@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum on toast tables  (satish v <vuyyuru.satish59@gmail.com>)
List pgsql-admin
Tree view
Please find the attachmment.

On Tue, Sep 21, 2021 at 2:20 PM satish v <vuyyuru.satish59@gmail.com> wrote:
image.png

in base/parent table dead tuples are zero.is it possible to run the vacuum on toast tables?.

Thanks in advance 

On Tue, Sep 21, 2021 at 2:18 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 azure postgresql service.

image.png
Attachment

pgsql-admin by date:

Previous
From: satish v
Date:
Subject: Re: Autovacuum on toast tables
Next
From: Prashant Kulkarni
Date:
Subject: How to Export Import particular/selected tables using PG Admin tool