NameCREATE MATERIALIZED VIEW -- define a new materialized view Synopsis
Namepostgres -- PostgreSQL database server Synopsis
The PostgreSQL source distribution includes several examples of index methods implemented using GiST. The
BRIN stands for Block Range Index. BRIN is designed for handling very large tables in which certain columns
NameALTER LARGE OBJECT -- change the definition of a large object Synopsis
NameANALYZE -- collect statistics about a database Synopsis
The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all
PostgreSQL provides a rich set of tools for developers to manage concurrent access to data. Internally, data consistency is maintained by using
NameCREATE EXTENSION -- install an extension Synopsis
NameDROP TEXT SEARCH TEMPLATE -- remove a text search template Synopsis
Page 19 of 60