Re: Autovacuum on toast tables

Поиск

Список

Период

Сортировка

От	satish v
Тема	Re: Autovacuum on toast tables
Дата	21 сентября 2021 г. 15:19:56
Msg-id	CAPG-CvUpqD-La-M-buPrA_5+oktP2k+DW_Zk8ePMqjPy4BgihA@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Autovacuum on toast tables (satish v <vuyyuru.satish59@gmail.com>)
Список	pgsql-admin

Дерево обсуждения

Please find the attachmment.

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

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.