The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run
bloom provides an index access method based on Bloom filters
The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the
Once you have created a database, you can access it by: Running the PostgreSQL
The core PostgreSQL distribution includes the GIN operator classes shown in Table 63-1. (Some of the optional
NameROLLBACK TO SAVEPOINT -- roll back to a savepoint Synopsis
There are two kinds of indexes that can be used to speed up full text searches. Note that indexes are not mandatory for full text searching, but in cases where a column is
The GIN interface has a high level of abstraction, requiring the access method implementer only to implement the semantics of the data type
The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the
unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output
Page 1 of 60