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 INDEX
  • References/Database/PostgreSQL/Commands

NameDROP INDEX -- remove an index Synopsis

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
SQL Dump
  • References/Database/PostgreSQL/Backup and Restore

The idea behind this dump method is to generate a file with SQL commands that, when fed back to the server, will recreate the database in the same state as it was at the time

2025-01-10 15:47:30
Boolean Type
  • References/Database/PostgreSQL/Data Types

PostgreSQL provides the standard SQL type boolean; see Table 8-19. The

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

Internally, a GIN index contains a B-tree index constructed over keys, where each key is an element of one or more indexed items (a member

2025-01-10 15:47:30
Server Configuration: File Locations
  • References/Database/PostgreSQL/Server Configuration

In addition to the postgresql.conf file already mentioned, PostgreSQL uses two other manually-edited configuration

2025-01-10 15:47:30
Default Roles
  • References/Database/PostgreSQL/Database Roles

PostgreSQL provides a set of default roles which provide access to certain, commonly needed, privileged capabilities and information. Administrators

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

NameVALUES -- compute a set of rows Synopsis

2025-01-10 15:47:30
Table Expressions
  • References/Database/PostgreSQL/Queries

A table expression computes a table. The table expression contains a FROM clause that is optionally followed by

2025-01-10 15:47:30