Re: delete and pg_toast = shrink database?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Feb 27, 2025 at 2:19 PM Edwin UY <edwin.uy@xxxxxxxxx> 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.