pg_freespacemap
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The pg_freespacemap module provides a means for examining the free space map (FSM). It provides a function called pg_freespace

2025-01-10 15:47:30
dict_xsyn
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

dict_xsyn (Extended Synonym Dictionary) is an example of an add-on dictionary template for full-text search. This dictionary type replaces words

2025-01-10 15:47:30
DROP OWNED
  • References/Database/PostgreSQL/Commands

NameDROP OWNED -- remove database objects owned by a database role Synopsis

2025-01-10 15:47:30
Type Conversion: Operators
  • References/Database/PostgreSQL/Type Conversion

The specific operator that is referenced by an operator expression is determined using the following procedure. Note that this procedure is indirectly affected by the precedence

2025-01-10 15:47:30
Internals//Genetic Query Optimizer: Genetic Query Optimization (GEQO) in PostgreSQL
  • References/Database/PostgreSQL/Internals/Genetic Query Optimizer

The GEQO module approaches the query optimization problem as though it were the well-known traveling salesman problem (

2025-01-10 15:47:30
REINDEX
  • References/Database/PostgreSQL/Commands

NameREINDEX -- rebuild indexes Synopsis

2025-01-10 15:47:30
ALTER POLICY
  • References/Database/PostgreSQL/Commands

NameALTER POLICY -- change the definition of a row level security policy Synopsis

2025-01-10 15:47:30
postgres
  • References/Database/PostgreSQL/Applications

Namepostgres -- PostgreSQL database server Synopsis

2025-01-10 15:47:30
DROP VIEW
  • References/Database/PostgreSQL/Commands

NameDROP VIEW -- remove a view Synopsis

2025-01-10 15:47:30
Constraints
  • References/Database/PostgreSQL/Data Definition

Data types are a way to limit the kind of data that can be stored in a table. For many applications, however, the constraint they provide is too coarse. For example, a column

2025-01-10 15:47:30