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

The citext module provides a case-insensitive character string type, citext. Essentially, it internally calls

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

Namepg_xlogdump -- display a human-readable rendering of the write-ahead log of a PostgreSQL database cluster

2025-01-10 15:47:30
Monitoring: Dynamic Tracing
  • References/Database/PostgreSQL/Monitoring

PostgreSQL provides facilities to support dynamic tracing of the database server. This allows an external utility to be called at specific

2025-01-10 15:47:30
Lexical Structure
  • References/Database/PostgreSQL/Syntax

SQL input consists of a sequence of commands. A command is composed of a sequence of tokens, terminated by a semicolon (

2025-01-10 15:47:30
Server Configuration: Resource Consumption
  • References/Database/PostgreSQL/Server Configuration

19.4.1. Memory shared_buffers (integer)

2025-01-10 15:47:30
Acronyms
  • References/Database/PostgreSQL/Appendixes/Appendixes

This is a list of acronyms commonly used in the PostgreSQL documentation and in discussions about PostgreSQL

2025-01-10 15:47:30
Internals//SP-GiST Indexes: Examples
  • References/Database/PostgreSQL/Internals/SP-GiST Indexes

The PostgreSQL source distribution includes several examples of index operator classes for SP-GiST, as described

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

The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with

2025-01-10 15:47:30
Full Text Search: Controlling Text Search
  • References/Database/PostgreSQL/Full Text Search

To implement full text searching there must be a function to create a tsvector from a document and a tsquery from a user

2025-01-10 15:47:30
Full Text Search: Configuration Example
  • References/Database/PostgreSQL/Full Text Search

A text search configuration specifies all options necessary to transform a document into a tsvector: the parser to use to break text into tokens,

2025-01-10 15:47:30