The vacuum of the PostgreSQL system is a routine maintenance process. The differences between VACUUM and VACUUM FULL is as follows :
| VACUUM | VACUUM FULL |
| 1. It only delets the dead tuples in the table, and there is no real physical deletion; 2. During the vacuum process, the data table can be accessed normaly. |
1. Physically delete dead tuples in the table to free up space to the operating system; 2. During vacuum full, the table is locked and access is not allowed. |
Source from : https://pankajconnect.medium.com/vacuum-and-vacuum-full-postgresql-4c9da30a1500
'DB > PostgreSQL' 카테고리의 다른 글
| [Theorem] Differences between conn.commit and conn.autocommit (0) | 2022.10.01 |
|---|---|
| [psycopg2] Vacuuming Postgres Database (0) | 2022.10.01 |
| [psycopg2] More efficient Index Scan (0) | 2022.10.01 |
| [psycopg2] Efficient query with Index Scan (0) | 2022.10.01 |
| [psycopg2] Debugging Postgres Queries (0) | 2022.10.01 |
