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
Copy and paste this URL into your WordPress site to embed
Copy and paste this code into your site to embed