CREATE FOREIGN TABLE CREATE FOREIGN TABLE — define a new foreign table Synopsis CREATE FOREIGN TABLE [ IF NOT EXISTS …| PostgreSQL Documentation
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation
73.2. TOAST # 73.2.1. Out-of-Line, On-Disk TOAST Storage 73.2.2. Out-of-Line, In-Memory TOAST Storage This section provides an overview of TOAST (The …| PostgreSQL Documentation
CREATE TABLE CREATE TABLE — define a new table Synopsis CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | …| PostgreSQL Documentation
25.1. Routine Vacuuming # 25.1.1. Vacuuming Basics 25.1.2. Recovering Disk Space 25.1.3. Updating Planner Statistics 25.1.4. Updating the Visibility Map 25.1.5. …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation
13.3. Explicit Locking # 13.3.1. Table-Level Locks 13.3.2. Row-Level Locks 13.3.3. Page-Level Locks 13.3.4. Deadlocks 13.3.5. Advisory Locks PostgreSQL provides various …| PostgreSQL Documentation
Altering an SQL database schema in production can be tricky. This article summarizes the most common use cases and solutions.| TMSVR - Dev Blog