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
Смотрите видео Tutorial 30-What is a vacuum in PostgreSQL | PostgreSQL Vacuum онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь mynotesoracledba 27 Июль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 7,382 раз и оно понравилось 72 людям.