Hi!
I’m not a database expert but in normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table; they remain present until a VACUUM
is done. Therefore it’s necessary to do VACUUM
periodically, especially on frequently-updated tables.
Talk with your database admin or review the VACUUM command:
Best regards.