delete and pg_toast = shrink database?

From: Edwin UY <edwin(dot)uy(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: delete and pg_toast = shrink database?
Date: 2025-02-27 21:18:35
Message-ID: CA+wokJ8utE8=5OAx8e_9Zo3S9QUoKy0pTK27PZqYgRujpdvVYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

DB is currently 500G. About 75% of this is pg_toast.
Had advised the application team to check for data purging as there are
some very old data.
Is it correct to assume that doing so should shrink the database size?
I believe I have to run vacuum full/table at some stage to really shrink it?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-02-27 21:21:41 Re: pg_toast doesn't show in pgAdmin 4 6.21
Previous Message Edwin UY 2025-02-27 21:09:14 pg_toast doesn't show in pgAdmin 4 6.21