PostgresSQL database maintenance script

今日想同大家分享一個 PostgresSQL Database maintenance script 用來 reclaim 返 D space

解決方法:

VACUUM (FULL, FREEZE, VERBOSE, ANALYZE, SKIP_LOCKED, INDEX_CLEANUP, TRUNCATE);

hope you find it useful