The task of the planner/optimizer is to create an optimal execution plan. A given SQL query (and hence, a query tree) can be actually executed in a

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

Another useful tool for monitoring database activity is the pg_locks system table. It allows the database administrator to view information

The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 62-1.

The fuzzystrmatch module provides several functions to determine similarities and distance between strings.

NameLOCK -- lock a table Synopsis

NameDROP OPERATOR -- remove an operator Synopsis

The view pg_locks provides access to information about the locks held by active processes within the database server. See Chapter 13 for more

This style guide is offered in the hope of maintaining a consistent, user-friendly style throughout all the messages generated by PostgreSQL

The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as