PostgreSQL: Short note on VACUUM, VACUUM FULL and ANALYZE

VACUUM, VACUUM FULL and ANALYZE: These are the maintenance related commands of PostgreSQL which requires frequent execution because PostgreSQL based on MVCC architecture where every UPDATE and DELETE generates dead rows or dead tuples as an internal fragmentation. If you don’t about the MVCC, you must visit the below article. What is MVCC? VACUUM: VACUUM … Continue reading PostgreSQL: Short note on VACUUM, VACUUM FULL and ANALYZE