Handling pg_toast tables

From: satish v <vuyyuru(dot)satish59(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Handling pg_toast tables
Date: 2021-02-25 11:40:22
Message-ID: CAPG-CvWzmDTM2BoHgkJ2BDRipye5BAvagyZs9m2yyhedx8sjHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

My table size is 15 MB but toast table size 92GB,i performed Vacuum and
vacuum full,but pg_toast table doesn't shrink.how can we shrink the
pg_toast table.

Thanks,
Satish.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Julien Rouhaud 2021-02-25 12:22:04 Re: unable to kill locked user session!
Previous Message Ganesh Korde 2021-02-25 11:30:05 Re: unable to kill locked user session!