In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series

NameCREATE TABLE -- define a new table Synopsis

bloom provides an index access method based on Bloom filters

NameLOAD -- load a shared library file Synopsis

The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection

NameALTER USER MAPPING -- change the definition of a user mapping Synopsis

Currently PostgreSQL provides one built in trigger function, suppress_redundant_updates_trigger, which will prevent

The catalog pg_collation describes the available collations, which are essentially mappings from an SQL name to operating system locale categories

Here we give a short overview of the stages a query has to pass in order to obtain a result.

Table 9-36 shows the operators available for the cidr and inet types. The operators <<