PostgreSQL Database Administration Essential Training

This is an updated video there the IP used will be different for other videos.

In version 16, the path is: /etc/postgresql/16/main.

Syntax Parameters in PostgreSQL VACUUM Command

FULL: The FULL request selects a “full” vacuum. The request takes a longer processing time and locks the table. One vivacious is that it can free up more space. The request creates new duplicates of the table queried and do not delete the old one until the operation is finished. This approach uses more disc space, limiting its use only when a substantial quantity of table space has to be freed up.

FREEZE: The FREEZE request is for aggressive freezing of tuple. Whenever you specify FREEZE, it is equivalent to performing VACUUM with the parameters set to zero for vacuum_freeze_min_age and vacuum_freeze_table_age. The FREEZE request should only be performed whenever you need to rewrite the table — making it counterintuitive/redundant if the user states a FULL request.

VERBOSE: The VERBOSE request prints a thorough report on the vacuum action for every table.

ANALYZE: The ANALYZE request updates the facts/statistics that the planner uses to decide the best and the most efficient way to carry out a query.

SYNTAX: REINDEX [ ( VERBOSE ) ] {SCHEMA | DATABASE | TABLE |SYSTEM | INDEX } name;

VERBOSE: This keyword is optional. The statement shows the progress report when the VERBOSE is defined while indexes being reindexed.

INDEX: Reconstruct the defined index.

TABLE: Reconstruct all indexes of the defined table.

DATABASE: Reconstruct all indexes of the defined database.

SYSTEM: Reconstruct all indexes on the system of the defined database.

name: This field defines the name of the index, table, database, or schema.