I am trying to rebuild index and update statistics for a postgresql 9.3.6 DB and the command I use is:
REINDEX DATABASE <Application database>;
REINDEX SYSTEM <Application database> ;
VACUUM(FULL, ANALYZE, VERBOSE);
I ran that for the first time and 137GB database takes 9 hours to finish but later that the DB size seems goes down to 80GB.