CREATE TABLESPACE CREATE TABLESPACE — define a new tablespace Synopsis CREATE TABLESPACE tablespace_name [ OWNER { new_owner | CURRENT_ROLE | …| PostgreSQL Documentation
14.2. Statistics Used by the Planner # 14.2.1. Single-Column Statistics 14.2.2. Extended Statistics 14.2.1. Single-Column Statistics # As we saw in the …| PostgreSQL Documentation
CLUSTER CLUSTER — cluster a table according to an index Synopsis CLUSTER [ ( option [, ...] ) ] [ …| PostgreSQL Documentation
vacuumdb vacuumdb — garbage-collect and analyze a PostgreSQL database Synopsis vacuumdb [connection-option...] [option...] [ -t | --table table [( column …| PostgreSQL Documentation
CREATE FUNCTION CREATE FUNCTION — define a new function Synopsis CREATE [ OR REPLACE ] FUNCTION name ( [ [ …| PostgreSQL Documentation
19.7. Query Planning # 19.7.1. Planner Method Configuration 19.7.2. Planner Cost Constants 19.7.3. Genetic Query Optimizer 19.7.4. Other Planner Options 19.7.1. Planner …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation
If you work with Postgres, it’s likely that at some point you’re going to wonder why it is not using an index that you think it should be.| pgMustard