> On May 10, 2024, at 7:57 AM, Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com> wrote:
>
> Can any body please advise, how to reduce the size of the table?
VACUUM FULL
Read the docs to understand what it does. Deleting a row does not shrink the table.
Think about it, what happens when you delete a row that's first in the file on disk? Do you expect the rest of the
tableto be rewritten? Do you expect the file to be rewritten every time a row is deleted? On commit of any transaction
thatincluded a delete?
Postgres will eventually reuse the space left behind by deleted rows (read the docs for VACUUM), so under most use
casesthis is not a problem.