Tutorial 28-What are Data fragmentation and bloat in PostgreSQL | PostgreSQL Bloat

Published: 07 November 2021
on channel: mynotesoracledba
915
15

What is a Data Fragment & Bloat?


As a simple definition Data Fragmentation Happens when ever we do activity
Which stored in data files

The MVCC (Multi Version Concurrency Control) Which maintains multiple versions of the rows are available

When the vacuum is run on the tables frequently to remove the internal previous images of records but it is not released at the filesystem level

#Postgresql #bloating #fragmentation


Watch video Tutorial 28-What are Data fragmentation and bloat in PostgreSQL | PostgreSQL Bloat online without registration, duration hours minute second in high quality. This video was added by user mynotesoracledba 07 November 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 91 once and liked it 1 people.