Re: Autovacuum on Toast table

Поиск

Список

Период

Сортировка

От	Aditya Toshniwal
Тема	Re: Autovacuum on Toast table
Дата	21 сентября 2021 г. 15:35:47
Msg-id	CAM9w-_kUkUYQPV0M-mfc1hK6L_ZL8m980Hd5hdfsozBkD9WTnQ@mail.gmail.com обсуждение исходный текст
Ответ на	Autovacuum on Toast table (satish v <vuyyuru.satish59@gmail.com>)
Список	pgadmin-hackers

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

Hi Satish,

The question is more suitable to be redirected to pgsql-admin@postgresql.org

On Tue, Sep 21, 2021 at 5:48 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 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