Internals//GIN Indexes: Examples
  • References/Database/PostgreSQL/Internals/GIN Indexes

The PostgreSQL source distribution includes GIN operator classes for tsvector

2025-01-10 15:47:30
Internals//Genetic Query Optimizer: Genetic Algorithms
  • References/Database/PostgreSQL/Internals/Genetic Query Optimizer

The genetic algorithm (GA) is a heuristic optimization method which operates through randomized search. The set of possible solutions for

2025-01-10 15:47:30
DROP TEXT SEARCH CONFIGURATION
  • References/Database/PostgreSQL/Commands

NameDROP TEXT SEARCH CONFIGURATION -- remove a text search configuration Synopsis

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

NameALTER LANGUAGE -- change the definition of a procedural language Synopsis

2025-01-10 15:47:30
Index Types
  • References/Database/PostgreSQL/Indexes

PostgreSQL provides several index types: B-tree, Hash, GiST, SP-GiST, GIN and BRIN. Each index type uses a different algorithm that is best

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

The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all

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

The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways:

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

NameRELEASE SAVEPOINT -- destroy a previously defined savepoint Synopsis

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

Create vs. insert Insertion into a GIN index can be slow due to the likelihood of many keys

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

NameCLOSE -- close a cursor Synopsis

2025-01-10 15:47:30