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

The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. The

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

NameLOAD -- load a shared library file Synopsis

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

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

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

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

2025-01-10 15:47:30
Trigger Functions
  • References/Database/PostgreSQL/Functions/Trigger

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

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

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

2025-01-10 15:47:30
Internals: Path of a Query
  • References/Database/PostgreSQL/Internals

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

2025-01-10 15:47:30
Parallel Plans
  • References/Database/PostgreSQL/Parallel Query

Because each worker executes the parallel portion of the plan to completion, it is not possible to simply take an ordinary query plan and run it using multiple workers. Each

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
CREATE OPERATOR CLASS
  • References/Database/PostgreSQL/Commands

NameCREATE OPERATOR CLASS -- define a new operator class Synopsis

2025-01-10 15:47:30