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

The auto_explain module provides a means for logging execution plans of slow statements automatically, without having to run

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

bloom provides an index access method based on Bloom filters

2025-01-10 15:47:30
Catalogs: pg_description
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the

2025-01-10 15:47:30
4.
  • References/Database/PostgreSQL/Tutorial/Getting Started

Once you have created a database, you can access it by: Running the PostgreSQL

2025-01-10 15:47:30
Internals//GIN Indexes: Built-in Operator Classes
  • References/Database/PostgreSQL/Internals/GIN Indexes

The core PostgreSQL distribution includes the GIN operator classes shown in Table 63-1. (Some of the optional

2025-01-10 15:47:30
ROLLBACK TO SAVEPOINT
  • References/Database/PostgreSQL/Commands

NameROLLBACK TO SAVEPOINT -- roll back to a savepoint Synopsis

2025-01-10 15:47:30
Full Text Search: GIN and GiST Index Types
  • References/Database/PostgreSQL/Full Text Search

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

2025-01-10 15:47:30
Internals//GIN Indexes: Extensibility
  • References/Database/PostgreSQL/Internals/GIN Indexes

The GIN interface has a high level of abstraction, requiring the access method implementer only to implement the semantics of the data type

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

The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the

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

unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, which means its output

2025-01-10 15:47:30