VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …| PostgreSQL Documentation
CREATE TABLESPACE CREATE TABLESPACE — define a new tablespace Synopsis CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | …| PostgreSQL Documentation
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation
Imagine looking for a specific book in a library. Reading through books sequentially is like a sequential scan in a database, while jumping directly to the desired book is like a random access. The `random_page_cost` reflects the relative cost of random access compared to sequential access in the database. At a very high level.| Shayon Mukherjee
52.5. Planner/Optimizer # 52.5.1. Generating Possible Plans The task of the planner/optimizer is to create an optimal execution plan. A given …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation