Re: Handling pg_toast tables

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: satish v <vuyyuru(dot)satish59(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Handling pg_toast tables
Date: 2021-02-25 15:08:51
Message-ID: 50d73c5f33c7c2b0b9155186e4d4549e9fbd7613.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 2021-02-25 at 17:10 +0530, satish v wrote:
> 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.

Delete soe rows from the table? I guess there are some large attributes.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Keith Fiske 2021-02-25 15:30:48 Re: Handling pg_toast tables
Previous Message Julien Rouhaud 2021-02-25 13:23:22 Re: unable to kill locked user session!