Postgres Pro
Downloads
Home   >   mailing lists

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

From Edwin UY
Subject delete and pg_toast = shrink database?
Date
Msg-id CA+wokJ8utE8=5OAx8e_9Zo3S9QUoKy0pTK27PZqYgRujpdvVYA@mail.gmail.com
Whole thread Raw
Responses Re: delete and pg_toast = shrink database?
Re: delete and pg_toast = shrink database?
List pgsql-admin
Tree view
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?


pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: pg_toast doesn't show in pgAdmin 4 6.21
Next
From: "David G. Johnston"
Date:
Subject: Re: pg_toast doesn't show in pgAdmin 4 6.21