I have upgraded Postgresql 9.5 to Postgresql 12.4 a few days back using pg_upgrade utility with link (-k) option.
So basically I am having two data directories i.e. One is old data directory (v9.5) and the current one in running state (v12.4).
Yesterday I have dropped two tables of size 700MB and 300MB.
After connecting to postgres using psql utility I can see database size whose tables was dropped got decreased (with l+ ) but what is making me worry is that only a few MBs have been freed from storage partition.
I have checked if any deleted open file is there on OS level using lsof but there is none. I have run vacuumdb only on that database but no luck
Looking for the solution.