Re: Handling pg_toast tables

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Handling pg_toast tables
Date: 2021-02-25 18:35:04
Message-ID: cdd589ef-7dd0-46dc-c9dc-4b19f2e19136@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 2/25/21 5:40 AM, satish v wrote:
> 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.

If your database has many LARGE columns (bytea, xml, json or even long text
values) then... that's how big the tables really are.

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Celia McInnis 2021-02-25 22:06:20 Trouble after crashing postgresql
Previous Message Keith Fiske 2021-02-25 15:30:48 Re: Handling pg_toast tables