Re: Autovacuum on toast tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 

Please find the attachmment.

On Tue, Sep 21, 2021 at 2:20 PM satish v <vuyyuru.satish59@xxxxxxxxx> 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@xxxxxxxxx> 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: toasttable.png
Description: PNG image

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux