> On May 10, 2024, at 7:57 AM, Sabyasachi Mukherjee <mukherjee.sabyasachi@xxxxxxxxxxx> 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 table to be rewritten? Do you expect the file to be rewritten every time a row is deleted? On commit of any transaction that included a delete? Postgres will eventually reuse the space left behind by deleted rows (read the docs for VACUUM), so under most use cases this is not a problem.
