Tutorial 30-What is a vacuum in PostgreSQL | PostgreSQL Vacuum
In this session, we are going to discuss a brief explanation about the vacuum in PostgreSQL
what is a vacuum?
The VACUUM statement is used to reclaim storage by removing obsolete data
or tuples from the PostgreSQL database.
Why we need a vacuum?
Postgresql is an MVCC architecture, Because of that delete doesn’t delete the rows in physical files but it marks them internally. as the same, tuples that are deleted or obsoleted by an update are not physically removed from their table.
It will occupy more storage space to recover that space to perform vacuum and vacuum full.
subscribe to our channel:
-----------------------------------------
https://rebrand.ly/8z3l1y1
For doubts and queries kindly contact us on
-----------------------------------------------------------------------
[email protected]
Follow us:
www.facebook.com/MyNotesOracleDba
#whatisvacuuminpostgresql #postgresqlvacuum
Watch video Tutorial 30-What is a vacuum in PostgreSQL | PostgreSQL Vacuum online without registration, duration hours minute second in high quality. This video was added by user mynotesoracledba 27 July 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,38 once and liked it 7 people.