Postgres Pro
Downloads
Home   >   mailing lists

Re: delete and pg_toast = shrink database? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: delete and pg_toast = shrink database?
Date
Msg-id CAKFQuwZdRgAMW__2Ge99FmoMZ9GxYW4diCbu=-0sHUC7Ey3xiw@mail.gmail.com
Whole thread Raw
In response to delete and pg_toast = shrink database?  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
Tree view
On Thu, Feb 27, 2025 at 2:19 PM Edwin UY <edwin.uy@gmail.com> wrote:
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?


Yes, most likely to reclaim the space to the OS you will need to use vacuum full or equivalent.

David J.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_toast doesn't show in pgAdmin 4 6.21
Next
From: Ron Johnson
Date:
Subject: Re: delete and pg_toast = shrink database?