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

Надежный VDS
2 Просмотры
Поддержите сайт и поделитесь материалом в соц.сетях:

Издатель
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
Категория
PostgreSQL
Комментариев нет.
Kwork.ru - услуги фрилансеров от 500 руб.