Hi Thanks a lot for the response.

I did run VACCUM with 0-hour retention(VACUUM <table_name> RETAIN 0 HOURS;) immedialty after deletion query.

Also, we have default VACCUM running every day once.

Please let me know if you need any more information.